DA-100-Questions Flashcards

1
Q

How should you prepare the data on Sales spreadsheet?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

B. No, it does not

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

A. Yes, it does

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

B. No, it does not

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which Power Query M formula should you use?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which Power Query function should you use?

A

D. Append Queries

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

B. No, it does not

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

B. No, it does not

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

A. Yes, it does

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What should you do?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What should you do?

A

D. In Power BI Settings, configure Datasets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Does this action produce the desired outcome?

A

B. No, it does not

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Does this action produce the desired outcome?

A

B. No, it does not

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Does this action produce the desired outcome?

A

A. Yes, it does

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What should you do before you can create the report?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Which DAX function should you use?

A

C. SAMEPERIODLASTYEAR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

How would you calculate the number of orders?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Which operation should you perform?

A

A. Append

20
Q

What should you configure for [Customer_ID] column?

A

B. Hide the [Customer_ID] column.

21
Q

Which DAX expression should you use?

A

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

22
Q

What should you do?

A

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

23
Q

Which two visualizations can you embed into the website?

A

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

24
Q

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

A

B. No, it does not

25
Q

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

A

A. Yes, it does

26
Q

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

A

B. No, it does not

27
Q

How should you configure the tile?

A

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

28
Q

Which action should you take?

A

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

29
Q

What should you do?

A

B. Use default or certified custom visuals.

30
Q

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.)

A

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

31
Q

What action should you take?

A

B. Add a Custom streaming data tile

32
Q

What action should you take?

A

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

33
Q

What action could you take?

A

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

34
Q

What should you do next?

A

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

35
Q

How should you prepare the data in the Date_Time column?

A

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

36
Q

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

A

A. Yes, it does

37
Q

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

A

B. No, it does not

38
Q

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

A

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

39
Q

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

A

B. No, it does not

40
Q

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

A

A. Yes, it does

41
Q

What should you do?

A

D. In the Microsoft 365, select Members.

42
Q

What should you do in the Power BI service?

A

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

43
Q

What should you do?

A

C. Modify the Access settings of the dashboards.

44
Q

How should you connect to the Azure Analysis Services cube?

A

B. Connect Live

45
Q

What role should you assign to the MiaHamm account?

A

B. Member