Free Access Microsoft.DA-100.v2022-05-11.q52 Practice Test (Page 5)

Question 16

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

A.Key influences

B.Funnel chart

C.Q&A

D.Line and clustered column chart

Question 17

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

A.FORMAT('Date'[date], "MMM YYYY")

B.FORMAT('Date' [date], "M YY")

C.FORMAT('Date' [date_id], "MMM YYYY")

D.FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")

Question 18

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 calculated column that use a formula of COUNTA(sales [sales_id])

C.a measure that uses a formula of COUNTROWS (Sales)

D.a calculated column that uses a formula of SUM (Sales [sales_id])

Question 19

You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?

A.Create a security role that has a table filter on the Sales_Manager table where username = UserName()

B.Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().

C.Create a security role that has a table filter on the Sales_Manager table where name = UserName().

D.Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

Question 20

You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

You need to prepare the data to support the following:
Visualizations that include all measures in the data over time
Year-over-year calculations for all the measures
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.

Other Version: 2842Microsoft.DA-100.v2022-07-18.q119; 2715Microsoft.DA-100.v2022-05-06.q145; 88Microsoft.Examboosts.DA-100.v2021-09-27.by.ford.149q.pdf

Latest Upload: 124Huawei.H19-315-ENU.v2025-10-27.q108; 107Salesforce.CRT-550.v2025-10-27.q146; 114SAP.E-S4CPE-2405.v2025-10-27.q51; 107Microsoft.SC-200.v2025-10-27.q144; 123CompTIA.SY0-701.v2025-10-27.q603; 108MedicalTests.AAPC-CPC.v2025-10-27.q53; 108ICF.ICF-ACC.v2025-10-27.q28; 133Cisco.400-007.v2025-10-27.q275; 124Salesforce.Certified-Business-Analyst.v2025-10-24.q293; 182Salesforce.B2C-Solution-Architect.v2025-10-23.q111

Question 16

Question 17

Question 18

Question 19

Question 20

Download PDF File