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 101–110 of 153

Q101

A company needs to share a dashboard with specific users while maintaining data security. Which feature should they use in Power BI?

  • A Publish to Web
  • B Share with Users
  • C Embed in Website
  • D Export to Excel
Explanation Sharing with specific users allows controlled access, while the other options may expose data to unintended parties.
Q102

You are configuring a data model in Power BI. What happens if you create a many-to-many relationship between two tables?

  • A Data integrity is improved
  • B Performance is optimized
  • C Ambiguities in data analysis arise
  • D Data refresh speeds up
Explanation Many-to-many relationships can lead to ambiguities, unlike the improvements or optimizations suggested by the other options.
Q103

Which feature allows report consumers to engage with data more interactively in Power BI?

  • A Drillthrough
  • B Column Formatting
  • C Dashboard
  • D Dataflows
Explanation Drillthrough allows detailed data exploration, whereas the other options do not enhance interactivity in the same way.
Q104

A company needs to automate report generation without manual intervention. Which feature should they utilize in Power BI?

  • A Publish to Web
  • B Paginated Reports
  • C Data Refresh Schedule
  • D Personal Dashboards
Explanation A Data Refresh Schedule automates report updates; the other options are not automation solutions.
Q105

You are configuring a new data source in Power BI. What happens if the credentials are incorrect?

  • A Data is imported successfully
  • B Error message displayed
  • C Power BI auto-corrects credentials
  • D Data source becomes disabled
Explanation An error message is displayed for incorrect credentials; the other options do not accurately describe the behavior.
Q106

Which DAX function calculates the total over a period?

  • A TOTALYTD
  • B ROLLUP
  • C SUMX
  • D CALCULATE
Explanation TOTALYTD sums values over a year; the others serve different functions.
Q107

A company needs to securely share reports with external stakeholders. What should they use?

  • A Power BI Desktop
  • B Publish to Web
  • C Power BI Service
  • D Export to PDF
Explanation Power BI Service allows secure sharing; the others do not provide security.
Q108

You are configuring a Power Query transformation. What happens if you rename a column in Query Editor?

  • A All references to this column are updated
  • B References to the old name remain active
  • C The data source is modified automatically
  • D Transformation history is deleted
Explanation Renaming updates all references; the others are incorrect changes or outcomes.
Q109

Which function would you use to filter rows in DAX?

  • A FILTER
  • B SELECT
  • C WHERE
  • D SUM
Explanation FILTER is the correct function for row filtering in DAX; SELECT and WHERE are not valid in DAX syntax, and SUM is used for aggregation only.
Q110

A company needs to create a report showing sales by region. What is the best way to visualize this data?

  • A Line chart
  • B Pie chart
  • C Map visual
  • D Table
Explanation A Map visual is optimal for geographical data like sales by region; line and pie charts do not effectively represent regional distribution, and tables lack visual clarity.