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 61–70 of 153

Q61

Which service allows data transformation in Power BI?

  • A Power Query
  • B Azure Data Lake
  • C Power Apps
  • D Azure SQL Database
Explanation Power Query is specifically designed for data transformation; the others focus on storage or app creation.
Q62

A company needs to share reports securely with clients outside the organization. What should they use?

  • A Power BI Service sharing
  • B Export to Excel
  • C Email PDF reports
  • D Public URL access
Explanation Power BI Service sharing allows secure report access; the other options lack proper security controls.
Q63

What happens when you delete a dataset in Power BI Service?

  • A Reports using it are deleted too
  • B Data in Azure is erased
  • C Unused reports remain intact
  • D It automatically reinstalls the dataset
Explanation Reports linked to the deleted dataset remain, but cannot be refreshed; others will cause data loss or reinstatement, which is incorrect.
Q64

Which feature allows Power BI to display real-time data?

  • A DirectQuery
  • B Import Mode
  • C Dataflows
  • D Scheduled Refresh
Explanation DirectQuery connects directly to the data source for live data access, unlike the other options that either import data or operate on a schedule.
Q65

A company needs to control access to its Power BI reports based on user roles. Which solution should they implement?

  • A Row-level security
  • B Dashboard sharing
  • C Power BI Premium
  • D Email subscriptions
Explanation Row-level security limits data access based on user roles; the other options do not manage data visibility effectively.
Q66

What happens when you set a Power BI report page bookmark?

  • A Saves filters and selections
  • B Removes all visuals
  • C Changes dataset connections
  • D Exports data automatically
Explanation Bookmarks preserve the current state of filters and visuals, whereas the other options do not represent bookmarking behavior.
Q67

Which service allows the creation of real-time dashboards in Power BI?

  • A Power BI Service
  • B Power BI Desktop
  • C Azure Synapse
  • D Power Automate
Explanation The Power BI Service enables real-time dashboard creation, while the Desktop version focuses on report building.
Q68

A company needs to share reports securely with different user roles. Which feature should they use in Power BI?

  • A Row-level security
  • B Dataflows
  • C Paginated reports
  • D Scheduled refresh
Explanation Row-level security restricts data access based on user roles, ensuring secure report sharing.
Q69

What happens when a report is published in Power BI with unresolved dataset warnings?

  • A Report fails to publish
  • B Report publishes with limited data
  • C Warnings are ignored
  • D Report will succeed without issues
Explanation The report will publish, but users will see limited data due to unresolved warnings.
Q70

Which DAX function is used to calculate cumulative totals?

  • A TOTALYTD
  • B SUM
  • C FILTER
  • D CALCULATE
Explanation TOTALYTD calculates year-to-date values; SUM adds values only.