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 141–150 of 153

Q141

What happens when you share a Power BI report with a user who does not have permission to access the underlying data?

  • A They see the report without data
  • B They get prompted for credentials
  • C They cannot access the report
  • D Only visuals without data are shown
Explanation If a user lacks access to the underlying data, they cannot view the report at all.
Q142

A company needs real-time analytics for streaming data. Which Azure service should they use?

  • A Azure Stream Analytics
  • B Azure SQL Database
  • C Azure Data Lake
  • D Azure Blob Storage
Explanation Azure Stream Analytics is specifically designed for real-time analytics, while the others serve different purposes.
Q143

What happens when a Power BI dataset is refreshed?

  • A Refreshes data only for visuals
  • B Updates and replaces existing data
  • C Increases report load time
  • D Saves previous data versions
Explanation Refreshing a dataset updates it with the latest data, replacing the existing data in the model.
Q144

You are configuring row-level security in Power BI. What must you ensure?

  • A Users have access to the model
  • B Only one role is defined
  • C All data sources are the same
  • D RLS is applied after publishing
Explanation Users must have access to the dataset to enforce row-level security effectively, while the others are incorrect requirements.
Q145

Which of the following is a valid DAX function for calculating year-to-date values?

  • A TOTALYTD
  • B YEARTODATE
  • C DATEVALUE
  • D YEARFRAC
Explanation TOTALYTD correctly calculates year-to-date; others are invalid or unrelated functions.
Q146

A company needs to analyze sales data segmented by region, which Power BI feature should they use?

  • A Calculated Columns
  • B Dataflows
  • C Row-Level Security
  • D Power Query Transformations
Explanation Power Query Transformations can segment the data effectively; others do not specifically provide segmentation.
Q147

What happens when you configure a Power BI report with DirectQuery against a large dataset?

  • A All data is stored in Power BI
  • B Performance improvements during report loading
  • C Real-time data queries on-demand
  • D Data refresh requires manual intervention
Explanation DirectQuery allows real-time queries; the others misrepresent the characteristics of DirectQuery.
Q148

Which chart type is best for showing transitions over time?

  • A Line chart
  • B Pie chart
  • C Bar chart
  • D Map chart
Explanation Line charts effectively visualize trends over time, while others do not.
Q149

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

  • A Publish to web
  • B Power BI service sharing
  • C Export to PDF
  • D Embed in a web app
Explanation Sharing via the Power BI service allows secure access for external users.
Q150

You are configuring data refresh in Power BI. What happens if the Gateway goes offline during the refresh?

  • A Refresh continues without interruption
  • B Refresh fails and retries later
  • C Dashboards will display old data
  • D Data model corrupts
Explanation If the Gateway is offline, the refresh fails but can retry when back online.