DA-100 試験問題を無料オンラインアクセス

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A.
You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID])
Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.
What should you do?

• A.Add a description of "Subscriber" to the Customer table.
• B.Add a description of "subscriber count" to the Customer Count measure.
• C.Add a synonym of "subscriber" to the Customer table.
• D.Set Summarize By to None for the CustomerlD column.

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 group on the state column and set the Group type to Bin.
• C.Create a new group on the state column and set the Group type to List.
• D.Create a new aggregation that summarizes by employee.

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.
You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.
What should you recommend?

• A.In one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.
• B.Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.
• C.Create a workspace for development and a workspace for production. From the production workspace, publish an app.
• D.Create one workspace for development. From the new workspace, publish an app for production.

You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

Reference:
https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054

You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

正解：