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

Question 51

You create a report by using Microsoft Power BI Desktop.
The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network.
You plan to publish the report to the Power BI Service.
What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

A.a subscription

B.a scheduled refresh of the dataset

C.an OData feed

D.an On-premises data gateway

Question 52

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_id], "MMM") & "" & FORMAT('Date'[year], "#")

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

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

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

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 51

Question 52

Download PDF File