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 1–10 of 153

Q1

Which of the following is an Azure service for data integration?

  • A Azure Data Factory
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure Virtual Machines
Explanation Azure Data Factory is specifically designed for data integration, while others serve different purposes.
Q2

A company needs to analyze live streaming data from IoT devices. Which Azure service should they use?

  • A Azure Stream Analytics
  • B Azure Data Lake Storage
  • C Azure Analysis Services
  • D Azure SQL Database
Explanation Azure Stream Analytics is tailored for real-time analytics, unlike the others that focus on batch processing or storage.
Q3

What happens when you publish a Power BI report and do not configure data refresh?

  • A Report updates automatically.
  • B Report remains static.
  • C Data is deleted.
  • D Report becomes inaccessible.
Explanation The report remains with the initial data state if data refresh isn't configured, as it does not auto-update.
Q4

You are using Power Query to transform data. What can you do to remove duplicate rows?

  • A Use 'Remove Duplicates' feature
  • B Append queries with a filter
  • C Sort the dataset alphabetically
  • D Change data type to text
Explanation 'Remove Duplicates' effectively eliminates exact duplicates, while the other options do not accomplish this.
Q5

A company needs to set up row-level security in Power BI. What should they define first?

  • A Data model relationship links
  • B Roles and filters on tables
  • C Visual interactions for reports
  • D Data types for each field
Explanation Row-level security requires defining roles and filters to restrict data access, unlike the other options.
Q6

What happens when you publish a report with a DirectQuery mode connection in Power BI?

  • A Data is imported into Power BI
  • B Users can only view static data
  • C Live data connection remains active
  • D Data refresh requires manual updates
Explanation DirectQuery maintains a live connection to the source, enabling real-time data access, unlike the incorrect options.
Q7

Which service allows for data transformation in Power BI?

  • A Power Query
  • B Power Automate
  • C Azure Functions
  • D SQL Database
Explanation Power Query is designed for data transformation, while the others serve different purposes.
Q8

A company needs to share a report but wants to restrict data access. Which feature should they use?

  • A Data Refresh
  • B Row-Level Security
  • C Data Modelling
  • D Datasets
Explanation Row-Level Security restricts data access based on user roles, ensuring controlled sharing.
Q9

What happens when you change a measure in Power BI Desktop?

  • A The report refreshes automatically
  • B Visualizations linked to it update
  • C Data model gets deleted
  • D Performance slows immediately
Explanation Changing a measure updates visualizations that reference it, while the other options are incorrect outcomes.
Q10

Which service is primarily used for data warehousing in Azure?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure Data Lake
  • D Azure Functions
Explanation Azure Synapse Analytics is designed for data warehousing, while the others serve different data storage or processing needs.