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 91–100 of 153

Q91

Which feature allows for real-time data visualization updates in Power BI?

  • A Real-time dashboards
  • B Scheduled refresh
  • C Static reports
  • D Manual data import
Explanation Real-time dashboards update immediately as data changes, while others do not.
Q92

A company needs to connect Power BI to their on-premises SQL Server. What should they use?

  • A Azure SQL Database
  • B On-premises data gateway
  • C Power BI Desktop only
  • D DirectQuery exclusively
Explanation An on-premises data gateway is essential for this connection, while others aren't for on-prem SQL Server.
Q93

What happens when you publish a Power BI report with a dataset containing R or Python visuals?

  • A Only visuals display correctly
  • B Report fails to publish
  • C Visuals become static images
  • D Unsupported visuals are removed
Explanation R or Python visuals convert to static images upon publish because server execution is not supported.
Q94

Which service is primarily used for data visualization in Azure?

  • A Power BI
  • B Azure Functions
  • C Azure VMs
  • D Azure Blob Storage
Explanation Power BI is specifically designed for data visualization, while the others serve different purposes.
Q95

A company needs to automate the refresh of Power BI datasets. What should they use?

  • A Dataflows
  • B Scheduled Refresh
  • C DirectQuery
  • D Import Mode
Explanation Scheduled Refresh allows automated dataset updates, unlike the other options which handle data differently.
Q96

You are configuring a Power BI report with multiple data sources. What happens if one source is unavailable?

  • A Entire report fails to load
  • B Other sources still load
  • C Data is cached
  • D Source gets retried automatically
Explanation Power BI allows independent loading of sources; others are either too absolute or not applicable.
Q97

Which service is best for real-time data analytics in Power BI?

  • A Azure Stream Analytics
  • B SQL Database
  • C Azure Blob Storage
  • D Power BI Service
Explanation Azure Stream Analytics is designed for real-time data processing, while others serve different purposes.
Q98

A company needs to combine data from multiple sources in Power BI. What should they utilize?

  • A Dataflows
  • B Datasets
  • C Data gateways
  • D Dashboards
Explanation Dataflows allow combining and transforming data from various sources, whereas datasets and dashboards serve other functions.
Q99

You are configuring row-level security (RLS) in Power BI. What happens if no RLS roles are defined?

  • A No data is visible
  • B Everyone sees all data
  • C Roles are auto-generated
  • D Data is filtered by region
Explanation Without defined RLS roles, all users have full data access; other options misinterpret RLS behavior.
Q100

Which service is primarily used for data visualization in Azure?

  • A Power BI
  • B Azure Functions
  • C Azure Blob Storage
  • D Azure Logic Apps
Explanation Power BI is specifically designed for data visualization, while the others serve different functions.