毎月、GOWUKAKUは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
Analyzing Data with Microsoft Power BI 試験
【2024桜まつりキャンペーン】：DA-100 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。
実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。
さらに試験準備時間の35％を節約するには、DA-100 問題集を使用してください。
Question No : 1
You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?
正解:
Explanation:
Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.
When you have one or more columns that you’d like to add to another query, you merge the queries.
Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical expression.
CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Question No : 2
In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset.
You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data.
What should you do?
正解:
Question No : 3
You are reviewing a query that produces 10,000 rows in the Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
正解:
Explanation:
B: Column distribution: This feature provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns. The data in these visualizations is sorted in descending order from the value with the highest frequency.
By hovering over the distribution data in any of the columns, you get information about the overall data in the column (with distinct count and unique values).
A: Column profile: This feature provides a more in-depth look at the data in a column [compared to column distribution]. Apart from the column distribution chart, it contains a column statistics chart.
Reference: https://docs.microsoft.com/en-us/power-query/data-profiling-tools
Question No : 4
ion have a Power B1 dataset that contains a table named Temperature Readings.
Temperature Readings contains the columns shown in the following table.
The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.
What should you do?
正解:
Question No : 5
You import a large dataset to Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point
正解:
Question No : 6
HOTSPOT
You are enhancing a Power BI model that has DAX calculations.
You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
正解: 
Question No : 7
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You publish an app to the entire organization.
Does this meet the goal?
正解:
Explanation:
https://docs.microsoft.com/es-es/power-bi/collaborate-share/service-create-distribute-apps
Question No : 8
You have the following three versions of an Azure SQL database:
✑ Test
✑ Production
✑ Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?
正解:
Explanation:
https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/4-development-lifecycle-strategy
Question No : 9
Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?
正解:
Explanation:
https://docs.microsoft.com/en-us/stream/portal-embed-video
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#add-web-content
Question No : 10
You have a query that returns the data shown in the following exhibit.
You need to configure the query to display the data as shown in the following exhibit.
Which step should you use in the query?
正解:
Explanation:
Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.
Chart
Description automatically generated
Note:
Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table
Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.
Reference:
https://docs.microsoft.com/en-us/power-query/unpivot-column
https://docs.microsoft.com/en-us/powerquery-m/table-unpivot
Question No : 11
DRAG DROP
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解: 
Explanation:
Question No : 12
HOTSPOT
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales.
CityData contains only the data shown in the following table.
Sales contains only the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
正解: 
Explanation:
Text
Description automatically generated
Box 1: Yes
The Related function returns a related value from another table.
The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table. If a relationship does not exist, you must create a relationship.
Box 2: Yes
Box 3: No
TX only occurs in the Sales table, but not in the CityData table.
Question No : 13
DRAG DROP
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.
You need to prepare the data to support the following:
✑ Visualizations that include all measures in the data over time
✑ Year-over-year calculations for all the measures
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解: 
Question No : 14
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
正解:
Explanation:
Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table.
Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities:
✑ Column quality
✑ Column distribution
✑ Column profile
Reference: https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/ba-p/674555
Question No : 15
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.
Does this meet the goal?
正解:
Explanation:
The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference: https://dash-intel.com/powerbi/statistical_functions_percentile.php