Online Access Free DA-100 Exam Questions

You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?

• A.Performance Analyzer in Power BI Desktop
• B.SQL Server Profiler
• C.Microsoft Edge DevTools
• D.Query Diagnostics in Power BI

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.

Correct Answer:

Answer as below

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

• A.Filter out discontinued products while importing the Product table.
• B.Change lite OrderlD column in the Orders table to the text data type.
• C.Remove the QuantityPerUnit column from the Products table
• D.Group the Categories table by the CategorylD column.

What should you create to meet the reporting requirements of the sales department?

• A.a measure that uses a formula of SUM (Sales [sales_id])
• B.a measure that uses a formula of COUNTROWS (Sales)
• C.a calculated column that uses a formula of SUM (Sales [sales_id])
• D.a calculated column that use a formula of COUNTA(sales [sales_id])

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.

Correct Answer:

1 - Pin items from report to Dashboard.
2 - Open Dashboard.
3 - Change the dashboard view to Phone view.
4 - Rearrange, resize the visuals.