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 31–40 of 153

Q31

Which service provides real-time analytics on streaming data?

  • A Azure Stream Analytics
  • B Azure Data Lake
  • C Azure Blob Storage
  • D Azure SQL Database
Explanation Azure Stream Analytics is specifically designed for real-time analytics; the others are for storage or databases.
Q32

A company needs to create a dashboard with data from multiple sources. What should they use?

  • A Power BI Dataflows
  • B Excel Pivot Table
  • C Azure SQL Database
  • D PowerApps
Explanation Power BI Dataflows can integrate data from multiple sources, while the others are not designed for this purpose.
Q33

You are configuring a Power BI report. What happens when you enable 'Data Refresh'?

  • A Data updates automatically.
  • B Data upload speeds increase.
  • C Visuals render faster.
  • D Reports become public.
Explanation Enabling 'Data Refresh' allows datasets to update automatically; the other options are unrelated effects.
Q34

Which Power BI feature allows real-time data streaming?

  • A Power BI Dataflows
  • B DirectQuery
  • C Streaming Datasets
  • D Scheduled Refresh
Explanation Streaming Datasets are specifically designed for real-time data; others do not provide real-time capabilities.
Q35

A company needs to analyze user engagement across multiple datasets. What should you use?

  • A Power Query
  • B Dataflows
  • C Azure Synapse
  • D Composite Models
Explanation Composite Models allow integration of data from different sources; others do not offer this flexibility.
Q36

What happens when your workspace limits are exceeded in Power BI?

  • A You cannot publish new reports.
  • B Old data is deleted automatically.
  • C All data refreshes are halted.
  • D Power BI will notify you via email.
Explanation Exceeding workspace limits prevents publishing; others are not correct as data limits do not auto-delete or halt refreshes without a notification.
Q37

Which Power BI service allows for automatic data refreshes?

  • A Power BI Service
  • B Power BI Desktop
  • C Power Apps
  • D Azure Synapse
Explanation Power BI Service supports scheduled data refreshes, while the other options do not.
Q38

A company needs to enhance its report sharing capabilities. What should they use?

  • A Publish to web
  • B Power BI Desktop
  • C Embed report
  • D SharePoint integration
Explanation Embedding reports allows dynamic sharing, unlike basic sharing methods.
Q39

What happens when data is filtered at the report level in Power BI?

  • A Reduces dataset size
  • B Affects all pages of report
  • C Only impacts visual on page
  • D Filters data source directly
Explanation Report-level filters affect all pages of the report, unlike other filter types.
Q40

A company needs to analyze sales data stored in Excel. Which Power BI feature should they use to import the data?

  • A Get Data from File
  • B Connect to Live Data
  • C Clean Data Transformations
  • D Report Sharing
Explanation Get Data from File allows importing Excel data, while others do not directly address the import process.