[2022年更新]合格できるMicrosoft DA-100試験最新142問題 [Q65-Q82]

[2022年更新]合格できるMicrosoft DA-100試験最新142問題

ゲット2022年最新の無料Microsoft DA-100試験問題 アンサー

Microsoft DA-100 認定試験の出題範囲：

トピック	出題範囲
トピック 1	パフォーマンスの低い測定値、関係、およびビジュアルを特定する ユーザーフレンドリーな値の置換を適用する
トピック 2	AdvancedEditorを活用してPowerQueryMコードを変更 結合に適切なキーを特定して作成する
トピック 3	基本的な統計関数を使用してデータを強化 クロスフィルター方向とセキュリティフィルタリングを適用
トピック 4	Daxを使用して複雑なメジャーを作成する Calculateを使用してフィルターを操作する
トピック 5	モバイルビューの設定 ダッシュボードのタイルの管理 ドリルスルーとクロスフィルターの使用
トピック 6	ビジュアル間の相互作用の編集と構成 条件付き書式の構成
トピック 7	アクセシビリティのための設計と構成 適切な視覚化タイプの選択
トピック 8	数値列をメジャーに置き換える ロールプレイングディメンションを定義する
トピック 9	関係のカーディナリティとクロスフィルターの方向を定義する 共有データセットを選択するか、ローカルデータセットを作成する
トピック 10	不整合、予期しない値またはヌル値、およびデータ品質の問題を解決する
トピック 11	行レベルのセキュリティロールを実装する 親子階層をフラット化する
トピック 12	階層の作成 計算列の作成 列とクエリへの使いやすい命名規則の適用
トピック 13	要約とデータ型の変更により、カーディナリティレベルを向上させます

 

質問 65
You have the visual shown in the Original exhibit. {Click the Original tab.)

You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

What should you add to the visual?

• A. a forecast
• B. an Average line
• C. a trendline
• D. a measure

正解: C

 

質問 66
You are creating an analytics report that will consume data from the tables shown in the following table.

There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.

正解:

解説:

 

質問 67
You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

• A. Add a measure to the visual that uses the following DAX expression.
  Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],0.40)
• B. Create a horizontal line that has a fixed value of 24,000.
• C. Add a measure to the visual that uses the following DAX expression.
  Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
• D. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.

正解: C

 

質問 68
Drag and Drop Question
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.

The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

正解:

解説:

Explanation:
Box 1: Member

Incorrect Answers:
Contributors can update the app metadata but not publish a new app or change who has permission to the app.
Box 2: Contributor

Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces

 

質問 69
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
* CustomerID
* Customer City
* Customer State
* Customer Name
* Customer Address 1
* Customer Address 2
* Customer Postal Code
The Invoice table contains the following fields:
* Order ID
* Invoice ID
* Invoice Date
* Customer ID
* Total Amount
* Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
* The number of customers invoiced in each state last month
* The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解:

解説:

Explanation

Box 1: One-to-many
A customer can have many invoices within one month.
Box 2: Single
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the
"many" side (bi-directional). For
Single cross filter direction means "single direction", and Both means "both directions". A relationship that filters in both directions is commonly described as bi-directional.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

 

質問 70
You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?

• A. stacked area chart
• B. waterfall chart
• C. line chart
• D. donut chart

正解: C

解説:
Explanation
A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used to visualize a trend in data over intervals of time - a time series - thus the line is often drawn chronologically.
Example:

Reference:
https://www.data-to-viz.com/graph/line.html

 

質問 71
You need to create a visual as shown in the following exhibit.

The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解:

解説:

 

質問 72
You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.
Which relationship should you use to link the tables?

• A. many-to-many between Customer and Transaction
• B. one-to-many from Transaction to Customer
• C. one-to-many from Customer to Transaction
• D. one-to-one between Customer and Transaction

正解: C

解説:
Each customer can have many transactions.
For each transaction there is exactly one customer.

 

質問 73
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.

You need to develop a measure to support the visual.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解:

解説:

Explanation
Box 1: CALCULATE
Start with CALCULATE and use a SUMX.
CALCULATE evaluates an expression in a modified filter context.
Box 2: SUM
Box 3: TOPN
TOPN returns the top N rows of the specified table.
Box 4: [TransactionDate]
TOPN Syntax: TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>,
[<order>]]...])
The orderBy_expression: Any DAX expression where the result value is used to sort the table and it is evaluated for each row of table.
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax

 

質問 74
You have a sales system that contains the tables shown in the following table.

The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?

• A. CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DatelD]))
• B. (SUN(sales[sales_araount]) - CALCULATE(SUM(sales[sales_amount]),
  SAHEPERIOOLASTYEAR('Date'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR ('Date'[DateID])
• C. CALCULATE(SUH(sales[sales_araount]), SAMEPERIODLASTYEAR('Date'[DatelD])
• D. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),
  SAMEPERIODLASTYEAR('Date'[DatelD])

正解: C

 

質問 75
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?

• A. Create a parameter and update the queries to use the parameter.
• B. Create a JSON file that contains the database server names. Import the JSON file to the dataset.
• C. Create a query for each database server and hide the development tables.
• D. Set the data source privacy level to and use the ReplaceValue Power Query M function.

正解: A

解説:
Explanation
https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/4-development-lifecycle-st

 

質問 76
You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.
In powerbi.com, when users load the visual, they only see some of the customers.
What is the cause of the issue?

• A. The visual was built by using a different version of R.
• B. The data is deduplicated.
• C. Too many records were sent to the visual.
• D. The data comes from a Microsoft SQL Server source.

正解: C

解説:
R visuals in the Power BI service have a few limitations including:
* Data size limitations - data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image.
Additionally, the input data has a limit of 250 MB.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals

 

質問 77
Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?

• A. Create a new aggregation that summarizes by state.
• B. Create a new aggregation that summarizes by employee.
• C. Create a new group on the state column and set the Group type to Bin.
• D. Create a new group on the state column and set the Group type to List.

正解: C

解説:
With grouping you are normally working with dimensional attributes.
Here we add three new groups (East, West, and North) and add each state to the appropriate group.
Reference:
https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/

 

質問 78
You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解:

解説:

Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
https://docs.microsoft.com/en-us/dax/summarize-function-dax

 

質問 79
You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

正解:

解説:

Explanation
Divide, Calculate, AllSelected.
Reference:
https://docs.microsoft.com/en-us/dax/allselected-function-dax

 

質問 80
You have a dataset named Pens that contains the following columns:
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解:

解説:

Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

 

質問 81
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

• A. Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.
• B. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
• C. Add the Weekly_Returns data to the Sales table by using related DAX functions.

正解: B

解説:
Scenario: Region managers require a visual to analyze weekly sales and returns.
To relate the two tables we need a common column.

 

質問 82
......

高合格率DA-100テスト問題集解答と正解142問題と回答：https://jp.fast2test.com/DA-100-premium-file.html