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 21–30 of 153

Q21

What happens when you publish a Power BI report with unsaved changes?

  • A Only saved changes are published
  • B Published report is deleted
  • C All changes are saved automatically
  • D Report fails to publish
Explanation Only saved changes will be published; unsaved changes remain locally on your machine.
Q22

Which Power BI feature allows for automatic data updates?

  • A Dataflows
  • B DirectQuery
  • C Scheduled Refresh
  • D Quick Insights
Explanation Scheduled Refresh automatically updates data at set times; others do not automate refresh.
Q23

A company wants to share dashboards securely with partners. Which method should they use?

  • A Publish to Web
  • B Export to PDF
  • C Power BI Apps
  • D Embed in SharePoint
Explanation Power BI Apps provide secure sharing options; others lack adequate security.
Q24

You are configuring row-level security in Power BI. What happens if a user tries to access restricted data?

  • A They see an error message.
  • B Data appears blank for them.
  • C Access is fully denied.
  • D Data is encrypted for security.
Explanation Row-level security makes restricted data appear blank; others suggest incorrect access behavior.
Q25

Which data transformation tool is directly integrated within Power BI?

  • A Power Query
  • B Data Factory
  • C Synapse Analytics
  • D Azure Analysis Services
Explanation Power Query is the embedded ETL tool in Power BI, others are separate services.
Q26

A company wants to refresh its Power BI dataset every hour. What is the best approach?

  • A Use DirectQuery mode
  • B Manual refresh only
  • C Scheduled refresh in service
  • D Use Import mode only
Explanation Scheduled refresh allows automated updates, whereas others do not support hourly refreshes.
Q27

What happens when you delete a calculated column in Power BI?

  • A All visuals using it break
  • B Only the column gets deleted
  • C Dashboard becomes unresponsive
  • D The model refresh is affected
Explanation Deleting a calculated column will break any visuals dependent on it, while others are incorrect in describing consequences of deletion.
Q28

Which service is primarily used for data visualization in Azure?

  • A Power BI
  • B Azure Data Lake
  • C Azure SQL Database
  • D Azure Cognitive Services
Explanation Power BI is specifically designed for data visualization, while the others serve different data management functions.
Q29

A company needs to analyze their sales data over the past year using Power BI. What feature should they use to view trends over time?

  • A Card visuals
  • B Line charts
  • C Tables
  • D Slicers
Explanation Line charts are best for showing trends over time, while the others do not visualize time series data effectively.
Q30

You are configuring relationships in Power BI data models. What happens if you create a many-to-many relationship?

  • A It will always duplicate records.
  • B It can lead to ambiguous results.
  • C It is not allowed in Power BI.
  • D It simplifies data modeling.
Explanation Many-to-many relationships can cause ambiguity in data connections, while others do not accurately describe the implications.