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 121–130 of 153

Q121

Which DAX function calculates the total for a filtered context?

  • A SUMX
  • B CALCULATE
  • C FILTER
  • D AVERAGE
Explanation CALCULATE modifies the context of evaluation, while others do not apply filtering directly.
Q122

A company needs to share data dashboards securely with external stakeholders. Which Power BI feature allows for this?

  • A Power BI Embedded
  • B Power BI Service
  • C Export to PDF
  • D Power BI Report Server
Explanation Power BI Embedded is designed for sharing dashboards with external users securely, while others serve different purposes.
Q123

You are configuring a scheduled refresh in Power BI. What happens if your data source credentials are not valid?

  • A Refresh will succeed with defaults.
  • B Refresh will fail, no data updated.
  • C Report remains unchanged for all users.
  • D Users receive alerts about changes.
Explanation A scheduled refresh fails if credentials are invalid, preventing data updates, while others do not accurately describe effects.
Q124

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

  • A Streaming Datasets
  • B Dataflows
  • C Power Query
  • D Objective Metrics
Explanation Streaming Datasets enable real-time data updates while others focus on data preparation or analysis.
Q125

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

  • A Data Gateway
  • B Dataflows
  • C Publish to Web
  • D Dashboards
Explanation Dataflows are specifically designed for combining data from various sources, unlike the others.
Q126

You are configuring security in Power BI. What happens if a user is in multiple roles with different permissions?

  • A All roles are merged automatically
  • B Least privileges are granted
  • C Highest privileges are granted
  • D Conflicts are resolved manually
Explanation The highest permissions from multiple roles are assigned, which overrides lower ones.
Q127

Which service is primarily used for data transformation in Power BI?

  • A Power Query
  • B Power Automate
  • C Azure Data Factory
  • D Power Apps
Explanation Power Query facilitates data transformation and cleansing within Power BI, while others serve different purposes.
Q128

A company needs to impose row-level security on a dataset. What should the analyst do?

  • A Create measures for users
  • B Use the 'Manage Roles' feature
  • C Set filters in Power Query
  • D Publish the report to different workspaces
Explanation The 'Manage Roles' feature effectively implements row-level security by setting user-based filters, while the other options do not fulfill this requirement.
Q129

What happens when you try to import a dataset larger than the 1 GB limit in Power BI Desktop?

  • A The import succeeds without issue
  • B The import fails with an error
  • C The dataset is automatically compressed
  • D You can publish it directly
Explanation Attempting to import a dataset larger than the 1 GB limit results in an import failure with an error message, while other options are not applicable.
Q130

Which Power BI feature allows users to create what-if scenarios?

  • A Data Insights
  • B What If Parameters
  • C Dataflow Management
  • D Quick Measures
Explanation What If Parameters enable scenario modeling, while the others do not directly support this functionality.