Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 5 — Questions and Answers
Question 1: An analyst wants to prevent users from exporting data from a sensitive Power BI report. Where is this setting configured?
- In the report's RLS role definition
- In Power BI Desktop under Report Settings
- In Power BI Service under the report's Settings > Export data (Correct answer)
- In the workspace Admin Portal
Correct answer: In Power BI Service under the report's Settings > Export data
Export data restrictions can be set in Power BI Service on the individual report's Settings page, overriding tenant-wide defaults for that report.
Question 2: What is the role of a Power BI Gateway in an enterprise environment?
- It compresses data before loading it into Power BI Desktop
- It serves as a bridge to allow Power BI Service to access on-premises or private network data sources (Correct answer)
- It enforces row-level security for published datasets
- It caches report pages for faster loading in the browser
Correct answer: It serves as a bridge to allow Power BI Service to access on-premises or private network data sources
The Power BI On-premises Data Gateway enables secure data transfer between Power BI Service in the cloud and data sources inside a corporate network.
Question 3: In DAX, what does the ALL() function do when used as a CALCULATE() filter argument?
- Applies all active slicers simultaneously
- Removes filters from specified columns or tables, ignoring current context (Correct answer)
- Adds all rows from a table to the result
- Calculates over all date periods in the model
Correct answer: Removes filters from specified columns or tables, ignoring current context
ALL() removes existing filter context from specified columns or entire tables, allowing measures to calculate without slicer or report-level filters affecting them.
Question 4: A Power BI model has Import mode tables and a DirectQuery table combined in the same model. What is this configuration called?
- Hybrid model
- Composite model (Correct answer)
- Aggregation model
- Mixed storage model
Correct answer: Composite model
A Composite Model allows Power BI to combine Import and DirectQuery storage modes in a single dataset, optimizing both performance and data freshness.
Question 5: Which Azure Data Factory component is responsible for defining the step-by-step data movement and transformation logic?
- Linked Service
- Dataset
- Pipeline (Correct answer)
- Integration Runtime
Correct answer: Pipeline
A Pipeline in Azure Data Factory is a logical grouping of activities that together perform a data engineering task, such as copying and transforming data.
Question 6: An analyst needs to display a KPI that shows current month sales versus last month sales. Which DAX function correctly retrieves last month's date range?
- PREVIOUSMONTH()
- DATEADD(Dates[Date], -1, MONTH)
- PARALLELPERIOD(Dates[Date], -1, MONTH)
- All of the above return identical results (Correct answer)
Correct answer: All of the above return identical results
PREVIOUSMONTH(), DATEADD() with -1 MONTH, and PARALLELPERIOD() with -1 MONTH all return the same set of dates representing the prior month.
Question 7: When configuring incremental refresh in Power BI, what are the two mandatory parameters that must be defined in Power Query?
- StartDate and EndDate
- RangeStart and RangeEnd (Correct answer)
- FilterStart and FilterEnd
- DateFrom and DateTo
Correct answer: RangeStart and RangeEnd
Power BI's incremental refresh requires exactly two Date/Time parameters named RangeStart and RangeEnd (case-sensitive) to define the refresh window.
Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 5
An analyst wants to prevent users from exporting data from a sensitive Power BI report.
Where is this setting configured?