DA-100 무료 덤프문제 온라인 액세스

You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE; Each correct selection is worth one point.

정답:

Answer as below

You need to create a measure that will return the percentage of late orders.
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/calculate-function-dax
https://docs.microsoft.com/en-us/dax/filter-function-dax

What is the minimum number of datasets and storage modes required to support the reports?

• A.a single imported dataset
• B.two DirectQuery datasets
• C.two imported datasets
• D.a single DirectQuery dataset

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.

정답:

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

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Deploy an On-premises data gateway in personal mode.
• B.Configure the dataset to use the existing On-premises data gateway.
• C.Configure the dataset to use the personal gateway.
• D.Set the refresh frequency to Daily.