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 41–50 of 153

Q41

What will happen if a user refreshes a Power BI dataset not configured for direct query?

  • A Data will update in real-time
  • B Cached data will be refreshed
  • C All reports will error out
  • D User will receive an access error
Explanation A refresh in import mode updates the cached data obtained previously, while others state incorrect scenarios.
Q42

You are configuring row-level security in Power BI. What is a requirement for defining security roles?

  • A Data must be aggregated
  • B Use DAX expressions for filter
  • C Data must be in SQL database
  • D Roles can be configured post-deployment
Explanation Row-level security requires DAX for filters, while others are either incorrect requirements or outdated practices.
Q43

Which feature can be used to schedule data refresh in Power BI?

  • A Data Gateway
  • B Power Automate
  • C DirectQuery
  • D Power Query
Explanation Data Gateway enables scheduled refreshes, while others serve different functions.
Q44

A company needs to allow users to share reports while restricting editing permissions. What should they configure?

  • A User Licensing
  • B Row-Level Security
  • C Share Report Settings
  • D Power BI Apps
Explanation Share Report Settings allow report sharing without edit rights; other options don't apply.
Q45

What happens when you enable 'Auto Date/Time' for date fields in Power BI?

  • A Creates additional tables
  • B Improves performance
  • C Generates default date hierarchies
  • D Removes any existing date formats
Explanation 'Auto Date/Time' generates default hierarchies, improving time-based analytics; others do not accurately describe this feature.
Q46

Which function helps in removing duplicates from a table in Power BI?

  • A DISTINCT
  • B GROUPBY
  • C SUMMARIZE
  • D FILTER
Explanation DISTINCT specifically removes duplicate rows from a column, while the others serve different aggregation or filtering purposes.
Q47

A company needs to refresh its dataset every hour. Which feature should they enable in Power BI?

  • A Scheduled Refresh
  • B Data Alerts
  • C Row-Level Security
  • D Streaming Dataset
Explanation Scheduled Refresh allows datasets to refresh at set intervals, unlike the other options which serve different functions in Power BI.
Q48

You are configuring incremental refresh for a table. What is required for this feature to work?

  • A Set time-based filters
  • B Use Direct Query only
  • C Aggregate tables
  • D Have a large dataset
Explanation Incremental refresh requires time-based filters to enable efficient data refresh, unlike the other options that do not pertain to this feature directly.
Q49

Which visualization would best depict trends over time?

  • A Line chart
  • B Pie chart
  • C Scatter plot
  • D Table
Explanation Line charts effectively show trends; the others do not present time data accurately.
Q50

A company needs to restrict report access based on user roles. Which feature should they utilize?

  • A Row-level security
  • B Data alerts
  • C Data Gateway
  • D Scheduled refresh
Explanation Row-level security restricts data access per user roles, while others do not address access control specifically.