Microsoft Azure

Microsoft Power BI Data Analyst

PL-300
Popular

Validate your skills as a Microsoft Power BI Data Analyst with the PL-300 exam.

153 questions 0 views Free
Start Mock Test Timed · Full-length · Scored

Questions 131–140 of 153

Q131

A company needs to schedule an automated data refresh in Power BI. What is the best approach?

  • A Power Automate Flows
  • B Gateway Configuration
  • C Embed API Calls
  • D Manual Refresh Only
Explanation Gateway Configuration enables scheduled refreshes, whereas the other options are not suitable for this purpose.
Q132

What happens when a Power BI report reaches the dataset size limit?

  • A Refresh fails without notification
  • B Data is truncated and report works
  • C Report loads but with incomplete data
  • D Report is not viewable or usable
Explanation When the dataset size limit is reached, the report cannot be used, making option D the correct answer.
Q133

Which service enables automatic data refresh in Power BI for reports?

  • A Power BI Gateway
  • B Azure Synapse
  • C Dataflows
  • D Power Automate
Explanation Power BI Gateway allows scheduled data refresh, while others serve different purposes.
Q134

A company needs to share reports with external partners. What should they use?

  • A Power BI Service
  • B Power BI Desktop
  • C DirectQuery
  • D Paginated Reports
Explanation Power BI Service supports report sharing, whereas Desktop is for design only.
Q135

You are configuring row-level security in Power BI. What happens if a user is not assigned to any role?

  • A Access denied to all data
  • B User sees all data
  • C Partial data access granted
  • D User must create their own role
Explanation Users without roles are denied access to all data due to security settings.
Q136

Which function is used to create a calculated column in Power BI?

  • A CALCULATE
  • B CREATECOLUMN
  • C ADDCOLUMN
  • D DAX
Explanation CALCULATE is the correct function for creating calculated columns, while others do not exist or apply to other contexts.
Q137

A company needs to share a Power BI report with external users. What should they use?

  • A Power BI Desktop
  • B Publish to Web
  • C Export as PDF
  • D Share Link
Explanation Publish to Web creates accessible links for external sharing, while the other options lack this capability.
Q138

What happens when a DAX measure references a column from a different table?

  • A It causes an error
  • B It performs cross-join automatically
  • C It aggregates data correctly
  • D It retrieves one random value
Explanation DAX evaluates measures against related tables correctly, whereas the other options reflect misconceptions about DAX relationships.
Q139

Which service can be used to automatically refresh Power BI datasets?

  • A Power BI Service
  • B Azure Functions
  • C Logic Apps
  • D Data Factory
Explanation The Power BI Service provides built-in refreshing capabilities for datasets, while the others do not.
Q140

A company needs to analyze clickstream data in real time. Which Power BI feature is best suited for this scenario?

  • A Power BI Desktop
  • B Dataflows
  • C Paginated Reports
  • D Streaming Datasets
Explanation Streaming Datasets allows for real-time data analysis, unlike the other options.