Free Access Microsoft.DA-100.v2022-05-06.q145 Practice Test (Page 8)

Question 31

You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Question 32

You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 33

You have a sales system that contains the tables shown in the following table.

The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?

A.CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DatelD]))

B.CALCULATE(SUH(sales[sales_araount]), SAMEPERIODLASTYEAR('Date'[DatelD])

C.(SUN(sales[sales_araount]) - CALCULATE(SUM(sales[sales_amount]),
SAHEPERIOOLASTYEAR('Date'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR ('Date'[DateID])

D.SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),
SAMEPERIODLASTYEAR('Date'[DatelD])

Question 34

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

A.Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.

B.Publish the reports to a different workspace other than the one hosting the datasets.

C.Publish the reports in an app and grant the HR managers access permission.

D.Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Question 35

You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit.

You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model.
What should you do?

A.Add a duplicate query named Airline.

B.Add airline as a synonym of carrier.

C.Rename the carrier column as airline in the Carriers query.

D.Rename the query from Carriers to airlines.

Premium Bundle

Newest DA-100 Exam PDF Dumps shared by BraindumpsPass.com for Helping Passing DA-100 Exam! BraindumpsPass.com now offer the updated DA-100 exam dumps, the BraindumpsPass.com DA-100 exam questions have been updated and answers have been corrected get the latest BraindumpsPass.com DA-100 pdf dumps with Exam Engine here:

Access DA-100 Premium Version

(150 Q&As Dumps, 40%OFF Special Discount: Exam-Tests)

Other Version: 2832Microsoft.DA-100.v2022-07-18.q119; 1340Microsoft.DA-100.v2022-05-11.q52; 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; 113SAP.E-S4CPE-2405.v2025-10-27.q51; 107Microsoft.SC-200.v2025-10-27.q144; 122CompTIA.SY0-701.v2025-10-27.q603; 108MedicalTests.AAPC-CPC.v2025-10-27.q53; 108ICF.ICF-ACC.v2025-10-27.q28; 131Cisco.400-007.v2025-10-27.q275; 123Salesforce.Certified-Business-Analyst.v2025-10-24.q293; 182Salesforce.B2C-Solution-Architect.v2025-10-23.q111