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 51–60 of 153

Q51

You are configuring a Power BI dataset. What happens when you set a column as a 'date' data type?

  • A It can store text values.
  • B Invalid dates will be discarded.
  • C It enables time intelligence functions.
  • D Data refresh will be disabled.
Explanation Setting a column as 'date' enables time intelligence; the others relate incorrectly to data type functions.
Q52

Which feature in Power BI is used to perform custom calculations in reports?

  • A Calculated Columns
  • B Data Refresh
  • C Quick Measures
  • D Data Types
Explanation Calculated Columns allow custom calculations on a row level, unlike their alternatives which serve different purposes.
Q53

A company needs to ensure that their Power BI reports only display data relevant to the user. What feature should they implement?

  • A Row-Level Security
  • B Data Source Filtering
  • C Traffic Segmentation
  • D Usage Metrics
Explanation Row-Level Security restricts data access based on user roles, while the others are not focused on user-specific data visibility.
Q54

What happens when a Power BI dataset refresh fails due to a data source connection error?

  • A The dataset becomes deleted
  • B The dataset remains unchanged
  • C The dataset auto-resolves the issue
  • D Error logs are auto-sent to Microsoft
Explanation The dataset will remain unchanged and retain its last successful refresh, unlike the other options which are incorrect actions.
Q55

Which Power BI feature allows users to explore data visually?

  • A Report View
  • B Data Model
  • C DAX Calculations
  • D Data Sources
Explanation Report View provides interactive visuals for data exploration, while the others serve different purposes.
Q56

A company needs to track user interactions on Power BI reports. What should they enable?

  • A Usage Metrics
  • B Row-Level Security
  • C Scheduled Refresh
  • D Dataflows
Explanation Usage Metrics provides insights into user interactions while the other options refer to different functionalities.
Q57

You are configuring a Power BI dataset. What happens when you enable 'DirectQuery' mode?

  • A Data is imported and cached
  • B Data is queried in real-time
  • C Report performance decreases
  • D Importing is mandatory
Explanation DirectQuery allows for real-time data queries, unlike imported data which is cached.
Q58

Which service is primarily used for real-time analytics in Azure?

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

A company needs to limit access based on geographic location for its Power BI reports. What should they configure?

  • A Row-level security
  • B Gateway connection
  • C User roles
  • D Geo-blocking policies
Explanation Geo-blocking policies restrict access based on location, while the other options pertain to different security aspects.
Q60

You are configuring a data model in Power BI. What happens when you set the relationship as 'Many to One'?

  • A Duplicates are removed
  • B One table can have duplicates
  • C Data import fails
  • D Only one table has unique keys
Explanation 'Many to One' allows the 'many' side to have duplicates, whereas the 'one' side must have unique keys.