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 81–90 of 153

Q81

What happens when data refresh fails in Power BI scheduled refresh?

  • A Data is automatically fixed
  • B Nothing, refresh is retried
  • C Data remains unchanged
  • D Report returns error message
Explanation When refresh fails, the last successful data remains; the report does not update until a successful refresh.
Q82

Which DAX function calculates the cumulative total over a period?

  • A TOTALYTD
  • B SUM
  • C CALCULATE
  • D AVERAGE
Explanation TOTALYTD is specifically designed to compute cumulative totals year-to-date, while the others are basic aggregation functions.
Q83

A company needs to visualize monthly sales data in a dashboard. What should they use?

  • A Scatter Chart
  • B Line Chart
  • C Pie Chart
  • D Table
Explanation A Line Chart is suitable for showing trends over time, unlike the other options which serve different purposes.
Q84

You are configuring data refresh settings in Power BI. What happens if a refresh fails?

  • A Data refresh auto-succeeds
  • B Dataset becomes unusable
  • C You get a notification
  • D Reports are deleted
Explanation You receive a notification upon refresh failure to address the issue, while the other options are incorrect scenarios.
Q85

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

  • A DirectQuery
  • B Dataflow
  • C Import Mode
  • D Paginated Reports
Explanation DirectQuery connects to live data sources, enabling real-time updates, while others do not.
Q86

A company needs to segment its sales data by region and price range efficiently. What Power BI feature should they utilize?

  • A Dataflow
  • B Calculated Columns
  • C Row-Level Security
  • D Bookmarks
Explanation Calculated Columns allow for custom segmentation of data for visualizations, while others do not segment data effectively.
Q87

What happens when you apply a filter to a visual in Power BI?

  • A Only affects the entire report
  • B Excludes all visuals
  • C Limits data shown in that visual
  • D Resets other filters automatically
Explanation Applying a filter limits data shown only in that specific visual, while others misrepresent the filter functionality.
Q88

Which Power BI feature allows team collaboration on reports?

  • A Workspaces
  • B Dataflows
  • C Bookmarks
  • D Dashboards
Explanation Workspaces provide a shared environment for collaboration; others serve different purposes.
Q89

A company needs to analyze customer data stored in Azure SQL Database using Power BI. What must be configured first?

  • A Develop reports in Power BI Service
  • B Enable DirectQuery in Power BI
  • C Create an Azure Storage account
  • D Create an RDL file
Explanation DirectQuery allows real-time data access from Azure SQL; others are irrelevant.
Q90

What happens when you set a Power BI report onSchedule refresh?

  • A Data is downloaded locally
  • B Data is updated without user intervention
  • C Reports are deleted
  • D Users receive email notifications
Explanation Scheduled refresh automatically updates data in reports; others are incorrect actions.