DA-100-Questions

Question 1

How should you prepare the data on Sales spreadsheet?

Answer 1

C. In Microsoft Excel, convert the data in the Sales spreadsheet to a flat table.

Question 2

Does this action allow you to use Microsoft R scripts in your visualization?

Answer 2

B. No, it does not

Question 3

Does this action allow you to use Microsoft R scripts in your visualization?

Answer 3

A. Yes, it does

Question 4

Does this action allow you to use Microsoft R scripts in your visualization?

Answer 4

B. No, it does not

Question 5

Which Power Query M formula should you use?

Answer 5

A. Text.Replace([SSN], Text.Start([SSN],6), “xxx-xx”)

Question 6

Which Power Query function should you use?

Answer 6

D. Append Queries

Question 7

Does this action allow you to ascertain the percentage of empty values in each column?

Answer 7

B. No, it does not

Question 8

Does this action allow you to ascertain the percentage of empty values in each column?

Answer 8

B. No, it does not

Question 9

Does this action allow you to ascertain the percentage of empty values in each column?

Answer 9

A. Yes, it does

Question 10

What should you do?

Answer 10

B. In your query definitions, modify the source step to use the DS parameter as the file path.

Question 11

Which two actions could you take? Each correct selection is a complete solution.

Answer 11

B. Create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.
D. Create measures that use the CALCULATE, COUNT, and FILTER DAX functions.

Question 12

What should you do?

Answer 12

D. In Power BI Settings, configure Datasets

Question 13

Does this action produce the desired outcome?

Answer 13

B. No, it does not

Question 14

Does this action produce the desired outcome?

Answer 14

B. No, it does not

Question 15

Does this action produce the desired outcome?

Answer 15

A. Yes, it does

Question 16

What should you do before you can create the report?

Answer 16

B. For each relationship, change the Cross filter direction to Both.

Question 17

Which DAX function should you use?

Answer 17

C. SAMEPERIODLASTYEAR

Question 18

How would you calculate the number of orders?

Answer 18

A. Create a calculated measure that uses the COUNTA(‘Orders’[Order_id]) DAX formula.

Question 19

Which operation should you perform?

Answer 19

A. Append

Question 20

What should you configure for [Customer_ID] column?

Answer 20

B. Hide the [Customer_ID] column.

Question 21

Which DAX expression should you use?

Answer 21

B. SUM(Sales[SalesAmount]) - CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(‘Date’[DateID])) /

Question 22

What should you do?

Answer 22

D. Use the Test as role option to view data as the Sales role.

Question 23

Which two visualizations can you embed into the website?

Answer 23

B. Visualizations that use datasets stored in Microsoft OneDrive for Business
C. Custom visualizations

Question 24

Does this action allow users to find data by using natural language queries?

Answer 24

B. No, it does not

Question 25

Does this action allow users to find data by using natural language queries?

Answer 25

A. Yes, it does

Question 26

Does this action allow users to find data by using natural language queries?

Answer 26

B. No, it does not

Question 27

How should you configure the tile?

Answer 27

C. From the Power BI tab in Excel, pin the table.

Question 28

Which action should you take?

Answer 28

B. In your data model, add synonyms to tables and columns.

Question 29

What should you do?

Answer 29

B. Use default or certified custom visuals.

Question 30

You need to filter all the visualizations in the report except the KPI visualization. Which two actions should you perform? Each correct answer is part of the solution. (Choose two.)

Answer 30

A. Add the same slicer to each page and configure Sync slicers. B. Edit the interactions of the KPI visualization.

Question 31

What action should you take?

Answer 31

B. Add a Custom streaming data tile

Question 32

What action should you take?

Answer 32

A. In Microsoft Power BI Desktop, configure the tab order

Question 33

What action could you take?

Answer 33

C. In the Power Query Editor, filter the Sales table by Sales_Date.

Question 34

What should you do next?

Answer 34

B. Group the sales by Order_Date, Product_id, and Salesperson_id. Then aggregate by using the CountRows function.

Question 35

How should you prepare the data in the Date_Time column?

Answer 35

D. Add a new column by example that starts with 2020-08-13. Set the data type of the new column to Date.

Question 36

Does this action show the top 5 performing sales persons based on sales value?

Answer 36

A. Yes, it does

Question 37

Does this action show the top 5 performing sales persons based on sales value?

Answer 37

B. No, it does not

Question 38

What action should you take to quickly view sales data by week?

Answer 38

C. Create a new group on the Date column and set the Group type to Bin.

Question 39

Does this action prevent MiaHamm from exporting data from the visualizations in the workspace?

Answer 39

B. No, it does not

Question 40

Does this action prevent MiaHamm from exporting data from the visualizations in the workspace?

Answer 40

A. Yes, it does

Question 41

What should you do?

Answer 41

D. In the Microsoft 365, select Members.

Question 42

What should you do in the Power BI service?

Answer 42

C. Publish the report to the web. In the website, use the embed code URL.

Question 43

What should you do?

Answer 43

C. Modify the Access settings of the dashboards.

Question 44

How should you connect to the Azure Analysis Services cube?

Answer 44

B. Connect Live

Question 45

What role should you assign to the MiaHamm account?

Answer 45

B. Member