Microsoft Power BI Data Analyst Associate (PL-300) Practice Test – 213 Free Exam Questions with Answers

Correct answer: C. YoY Growth = DIVIDE(SUM(Sales[SalesAmount]) – CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(Date[Date])), CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(Date[Date])))

This formula correctly calculates year-over-year growth by subtracting last year's sales from current sales, then dividing by last year's sales. Using the DIVIDE function safely handles potential divide-by-zero errors, making it superior to standard division.

Correct answer: C. Rules

Rules-based conditional formatting lets you define explicit thresholds and assign specific font colors directly. Color scales are better for gradual transitions, while field values require extra measures, making rules the least complex approach here.

Correct answer: B. Enable Microsoft Purview Information Protection sensitivity labels in Power BI

Enabling Microsoft Purview Information Protection sensitivity labels allows administrators to classify reports and persist those labels during exports to Excel or PDF. Row-level security restricts row access but does not apply persistent external data classification tags.

Correct answer: B. Go to Format → Edit Interactions, click the Bar Chart, and set the interaction with the Pie Chart to "Filter" and the interaction with the Table to "None".

Using Edit Interactions lets you set the Bar Chart to Filter the Pie Chart and None for the Table. Highlight only shades portions of visuals without removing data, and Sync Slicers manages slicer pane items.

Correct answer: D. YTD Sales = CALCULATE(SUM(Sales[SalesAmount]), DATESYTD(Date[Date]))

CALCULATE with DATESYTD aggregates sales from the start of the year to the current filter context date. SAMEPERIODLASTYEAR computes prior-year data, while DATESINPERIOD forces a rolling 12-month period backwards.

Correct answer: B. Create a fact table with sales transactions and dimension tables for products and customers, linked by ProductID and CustomerID in a star schema.

A star schema centers on a sales fact table connected directly to products and customers dimension tables. Flattening tables into a single model degrades performance and scalability, while ignoring relationships prevents filtering.

Correct answer: D. Line chart with forecasting enabled

A line chart is designed for visualizing trends over time. The built-in forecasting feature allows you to predict future data points, making it the best choice here. Other visuals like waterfall or bar charts lack native time-series forecasting.

Correct answer: B. Set the Privacy Level of both data sources to "Organizational" in the Privacy Level settings.

Setting both data sources to the Organizational privacy level allows Power BI to combine the data securely while respecting privacy boundaries. Setting mismatched levels or marking internal business data as Public can trigger firewall errors or create security risks.

Correct answer: C. Line chart

A line chart is the most effective visualization for comparing metrics across time because it clearly represents trends and patterns. While bar charts show comparisons, line charts are the standard Power BI visual for continuous time-based data like months.

Correct answer: B. Query Editor > Data Profiling View

The Data Profiling feature in Power Query Editor provides an in-depth analysis of column properties, including value distributions and missing values. This tool is essential for data quality assessment before report creation, unlike slicers or dataset settings.

Correct answer: B. Create an active relationship and enable "Apply security filter in both directions" for the relationship.

Enabling Apply security filter in both directions ensures that row-level security filters propagate correctly across the relationship. Standard cross-filtering handles general data filtering, but the specific security checkbox is required to guarantee RLS rules apply bidirectionally.

Correct answer: B. Use a native SQL query with a WHERE clause or TOP statement in Power Query

Writing a native SQL query with a WHERE clause or TOP statement pushes data reduction back to the source server, ensuring only a sample is imported. Applying filters after loading data into Power Query or DAX still attempts to pull the full dataset initially.

Correct answer: D. Use the Web connector to pull data from the API.

The Web connector is the correct choice to retrieve data from a REST API endpoint. The OData connector fails because it only works with APIs compliant with the OData protocol, and the JSON connector only reads static files.

Correct answer: C. CALCULATE([Revenue], SAMEPERIODLASTYEAR(Date[Date]))

The SAMEPERIODLASTYEAR function shifts the filter context back exactly one year to evaluate the measure. PARALLELPERIOD is a strong distractor but operates at the level of the entire year rather than matching the exact granular date range.

Correct answer: A. Left Outer join with Employee table as the left table

A Left Outer join ensures every row from the primary Employee table is preserved in the merged output. An Inner join would incorrectly drop employees lacking matching department records, violating the core requirement.

Correct answer: B. Create a calculated column using DAX in the Sales table

Creating a calculated column using DAX evaluates the subtraction expression row by row to store the profit directly in the table. A measure aggregates data on the fly and does not create a new physical column for each row.

Correct answer: D. Create a role with a DAX filter on the Regions table that restricts data based on the user's email address.

Creating a DAX role that filters by USERPRINCIPALNAME() correctly restricts access based on the logged-in user. Filtering visuals manually or removing rows in Power Query will not dynamically adapt per user and breaks the dynamic security model required for shared datasets.

Correct answer: B. Use Power Query to load both tables, merge them with a Left Outer join on ProductID, and configure a daily refresh in Power BI Service.

A Left Outer join on ProductID ensures every Sales record is preserved regardless of matches, satisfying the inclusion requirement. Inner joins drop unmatched rows, while mixed or Full Outer joins add complexity and unneeded data.

Correct answer: D. Use sensitivity labels to classify and protect sensitive data in reports and datasets.

Sensitivity labels classify and protect reports and datasets by enforcing encryption and access policies. Isolating secure workspaces or giving broad Build permissions fails to provide systematic, organization-wide data protection.

Correct answer: D. Install the Power BI Desktop application and use the Dataverse connector

Using the native Dataverse connector in Power BI Desktop provides direct, secure access to tables for modeling and reporting. SQL or custom API connections are not recommended, and Excel exports create static snapshots.

Correct answer: D. Pin the report page as a live tile on the dashboard.

Pinning the entire report page as a live tile preserves cross-filtering and interactivity directly within the dashboard. Exporting to PDF or images creates static snapshots, and sharing a report link bypasses the dashboard entirely.

Correct answer: A. Import mode

Import mode provides the fastest performance for moderate datasets by caching data in memory, with scheduled refreshes meeting the currency needs. DirectQuery slows visuals down, and Live Connection targets Analysis Services.

Correct answer: C. Key influencers

The Key Influencers visual uses machine learning to analyze data and automatically identifies the factors driving a specific metric. A decomposition tree requires manual exploration, while standard charts lack automated ranking capabilities. Rely on Key Influencers for quick statistical insights.

Correct answer: B. Merge the Orders table with the Customers table using a Left Outer join

Merging the Orders table with the Customers table using a Left Outer join retains all rows from the left table regardless of matches. An inner join drops unmatched orders, while appending stacks tables vertically instead of combining them by matching keys. Always rely on left outer joins to preserve base records.

Correct answer: A. Use the Folder connector in Power Query to import all CSV files from the folder, combine them into a single table, and enable data refresh.

The Folder connector in Power Query automatically combines all files within a directory and captures new files added later during scheduled refreshes. Manually importing and appending individual files creates maintenance overhead. For the exam, always choose the Folder connector when combining files.

Correct answer: D. The table must have a column with unique and contiguous dates.

A designated date table must contain a column of unique, contiguous dates to serve as the primary key for relationships. This contiguous range is mandatory for time intelligence functions to work correctly and prevents gaps in date filtering.

Correct answer: D. Enable the Anomaly Detection feature in the line chart, configure the Sensitivity setting, and review the automatically generated explanations.

The built-in Anomaly Detection feature on line charts uses machine learning to automatically find outliers and provides explanations. Configuring the sensitivity slider adjusts the detection threshold without requiring custom DAX. This native tool precisely meets the automated analysis requirements.

Correct answer: C. Create separate drillthrough pages for Product Category and Customer Name and configure each with the appropriate field in the "Drillthrough" section.

Creating separate drillthrough pages allows you to define specific filter fields in the Drillthrough pane for each destination. Combining them on one page would force users to pass both filters simultaneously. This ensures the drillthrough targets match the intended visual context.

Correct answer: A. Use the Folder connector, filter to CSV files, select metadata columns (Name, Date Created), and add a custom column to count rows without loading content.

Using the Folder connector and extracting metadata without loading the binary content is the correct approach to summarize file properties. This approach uses query folding to keep the dataset lightweight. Loading the actual data would violate the requirement and degrade performance.

Correct answer: D. Connect to the Azure SQL Database using Import mode, create the report in Power BI Desktop, publish to the Power BI Service, and configure a daily refresh with SQL Server credentials.

Import mode with a scheduled refresh in the Power BI Service provides the best balance of performance and secure data access. While DirectQuery offers real-time data, it introduces setup complexity. Sharing a local file via email bypasses central governance and secure credential management.

Correct answer: B. Change the SaleDate column type to Date, then mark it as a Date Table and create a date hierarchy in Power BI Desktop.

Changing the data type to Date properly converts the text into recognizable dates for temporal analysis. Marking the table as a date table activates time intelligence functions and enables reliable drill-down hierarchies, whereas extracting text strings breaks chronological sorting.

Correct answer: A. Use the Change Type Using Locale option in the Transform tab, selecting a locale that matches the source data format.

Using the Change Type Using Locale option correctly interprets ambiguous dates by applying the specific regional formatting of the source data. Manually changing the type to Date assumes local system settings, which can silently misinterpret days and months.

Correct answer: B. Certified reports meet specific organizational criteria for trust and quality.

A Certified dataset indicates the content has passed a formal review against organizational standards for quality and trust. Promoted simply means an end user found it useful enough to highlight, offering no official validation of the underlying data.

Correct answer: B. Rules

Rules-based formatting directly assigns discrete colors based on strict numeric boundaries, perfectly matching the threshold requirement. Color scales apply gradients across ranges and cannot isolate a single exact cutoff efficiently.

Correct answer: A. A paginated report (.rdl file)

Paginated reports are designed specifically for highly formatted, print-ready layouts with precise page breaks. A standard Power BI report is optimized for interactive on-screen exploration rather than generating perfectly formatted invoices meant for printing or PDF export.

Correct answer: B. To allow filters applied to either table to propagate to the other table.

Setting cross-filter direction to Both propagates filters from either table across the relationship. However, for Date and Sales tables, Single direction is generally recommended to avoid ambiguity, making this an edge-case design.

Correct answer: B. Use Composite mode with DirectQuery for recent data and Import mode for historical data

Composite mode lets you mix storage types by using DirectQuery for recent data and Import mode for historical data. Using DirectQuery exclusively ensures real-time updates but causes poor performance on large datasets. Composite models deliver the best balance of speed and fresh data.

Correct answer: D. DirectQuery

DirectQuery queries the underlying SQL database live, satisfying the requirement for near real-time data without scheduled import refreshes. For the exam, remember that Import mode provides the fastest performance, but DirectQuery is required when data must be up to the minute.

Correct answer: C. Publish the report to the Power BI Service, configure a gateway for both SQL Server and SharePoint data, set a daily refresh, and share the report using Azure AD B2B guest access.

Configuring an enterprise gateway allows secure automated refreshes for both cloud and on-premises data sources. Azure Active Directory B2B guest access provides secure external sharing, whereas public links bypass standard security protocols and do not require user authentication.

Correct answer: B. Create a master Date table, link it to the report, and use DAX measures to filter the three role-playing date tables.

Creating an unrelated master Date table connected to a slicer allows a single selection to drive multiple calculations. DAX measures use functions like USERELATIONSHIP to filter the specific role-playing date columns dynamically, avoiding the confusion of multiple independent slicers.

Correct answer: A. T-SQL

T-SQL is the standard query language used to extract and manage data from SQL Server databases. DAX is used for calculations within the semantic model, while MDX queries multidimensional cubes. Use T-SQL when writing native database queries during Power BI data extraction.

Correct answer: A. Filter and transform the data directly in the SQL query to reduce data load in Power BI.

Filtering and transforming data at the source using a native SQL query reduces the volume of data transferred to Power BI. Pushing query folding steps back to the source system improves refresh performance and conserves memory.

Correct answer: B. Use the measure in a visualization.

After creating a measure to count distinct products, you simply drag it into a visualization to display the results. The measure itself handles the underlying logic using distinct counts, so you only need to use it directly in your report visuals.

Correct answer: F. Customers who are in both HighSpenders and RecentBuyers.

The INTERSECT function returns only the rows that are common to both input tables. Therefore, it retrieves customers appearing in both the HighSpenders and RecentBuyers lists. Remember that UNION combines all rows, while EXCEPT returns rows only present in the first table.

Correct answer: E. Assign the user the Member role in the workspace.

Assigning the Member role allows the user to edit content and manage workspace membership without granting full administrative control. Contributors can edit content but cannot add members, whereas Admins have unnecessary permissions like deleting the workspace. This approach successfully adheres to the principle of least privilege.

Correct answer: E. Use the Analytics pane to add an average line.

The Analytics pane in Power BI Desktop allows you to seamlessly add a dynamic average line to a visual. This line adjusts automatically when filters change, unlike a static constant line. Use the Analytics pane instead of writing complex DAX for simple reference lines.

Correct answer: B. Tooltip

Adding a measure to the Tooltip well ensures that the value appears when users hover over a data point in the visual. Placing the field on the y-axis or legend alters the core visual structure rather than providing contextual hover details. Tooltips enhance charts without adding clutter.

Correct answer: C. Create a data alert in the Power BI service for the revenue KPI tile, set the threshold to $500,000, and specify email notifications for the team.

Data alerts in the Power BI service can be set on dashboard tiles to trigger notifications when values exceed defined thresholds. Alerts must be created in the service rather than Power BI Desktop, and they do not apply to visual-level filters or subscriptions.

Correct answer: A. The rows from both tables will be added to a single table.

Appending queries stacks the rows from both tables vertically into a single result set. Merge queries combines columns horizontally based on a matching key, whereas appending does not remove duplicates.

Correct answer: C. Viewer

The Viewer role restricts users to viewing and interacting with published content without allowing edits. Contributor and Member provide edit permissions, while Admin grants full workspace management rights.

Correct answer: D. Implement RLS with dynamic filtering based on USERPRINCIPALNAME(), assign users to roles in the Power BI service, and share the report via a workspace with Viewer permissions.

Using Row-Level Security with dynamic filtering via USERPRINCIPALNAME restricts data access based on the user's login. Sharing via a workspace with Viewer permissions ensures users can consume reports without modifying them. Static filters are harder to maintain than dynamic RLS.

Correct answer: B. Contributor

The Contributor role allows users to create, edit, and publish reports within a workspace. It restricts critical administrative tasks like modifying workspace settings or deleting the workspace. The Member role grants unnecessary elevated permissions for these requirements.

Correct answer: B. Publish the dashboard to Power BI Service and share access links.

Publishing to the Power BI Service enables scheduled refreshes to keep data current without manual intervention. Sharing via access links maintains interactivity and manages security efficiently. Emailing static files removes interactivity and fails to scale.

Correct answer: C. Columns with different names will appear as separate columns in the appended table.

Power Query relies on exact column name matching to align data vertically during an append operation. Mismatched names result in separate columns populated with nulls where data is missing. The tool does not automatically map or merge differently named columns.

Correct answer: A. Split the Products table into separate tables for Category and Subcategory.

Normalization involves splitting hierarchical attributes into separate tables to eliminate redundant data. For the PL-300 exam, remember that standard Power BI star schema modeling often favors denormalized dimensions, but this scenario explicitly requires normalization.

Correct answer: D. Create a DAX measure to calculate the length of descriptions

Creating a DAX measure calculates values dynamically at query time without permanently storing data in the model. Calculated columns or Power Query columns consume memory because they are evaluated and stored during data refresh.

Correct answer: C. Join the Claims table with the StateCode table to look up and fill in missing StateName values

Joining tables in Power Query populates missing data accurately by referencing a reliable lookup table. Excluding rows reduces dataset completeness, and manual entry or visual flags do not resolve the underlying data quality issues.

Correct answer: B. Publish the dashboard and reports to a workspace, create an app, and share the app with the entire organization, granting Viewer permission.

Publishing to a workspace and bundling content into an app lets large audiences securely consume read-only datasets. Granting Build permissions allows users to create new reports, while public links bypass enterprise security and governance.

Correct answer: C. Use the Edit Interactions option to configure interactions between visuals.

The Edit Interactions feature precisely controls how selecting a visual filters other report elements. Drill-through navigates to a separate report page, while slicers require users to manually select values from an independent drop-down menu.

Correct answer: D. Use one-to-many relationships between Customers and Orders and between Products and Orders.

Standard star schema design dictates single-direction one-to-many relationships from dimension tables to the fact table. Bridge tables are reserved for many-to-many cardinalities, which do not apply to this straightforward transactional data model.

Correct answer: D. Set the relationship direction to Single and the Cardinality to One-to-Many (1:*).

A single direction one-to-many relationship is optimal because one department connects to many employees. Single direction filtering provides the best performance and avoids ambiguous filter paths that complicate DAX calculations.

Correct answer: D. Click the Pin visual icon on the visual.

Clicking the pin visual icon is the direct way to add a report visual to a Power BI service dashboard. Dashboards are exclusively built from pinned visuals, so editing options or exporting to Excel are invalid workflows.

Correct answer: D. Select the Category Name field, click "New Hierarchy," and add SubCategory Name to it.

Creating a hierarchy explicitly defines the parent-child relationship, enabling seamless drill-down navigation in visuals. Dragging separate fields onto an axis creates a flat cross-product display instead of a true drillable structure.

Correct answer: B. Change the ProductID column in the Sales table to whole number in Power Query and create a many-to-one relationship to the Product table.

Relationships require matching data types, so changing the Sales ProductID to whole number in Power Query enables the many-to-one connection. Calculated columns or many-to-many relationships introduce unnecessary model complexity.

Correct answer: D. There are duplicate entries in the ProductName column.

When distinct values exceed unique values, some items appear multiple times. Distinct counts all different values, while unique counts only items appearing exactly once, proving duplicates exist.

Correct answer: A. In Power Query Editor, group by Email and count rows to identify emails with count greater than 1

Using Power Query to group by the Email column and count rows efficiently identifies duplicates. Grouping in data preparation is faster and cleaner than writing complex DAX or manually inspecting rows.

Correct answer: A. CALCULATE

CALCULATE modifies the filter context, making it essential for manual cumulative calculations. While ALL removes filters, it relies on CALCULATE to apply the modified context to the base aggregation.

Correct answer: B. Total Sales = SUM(Sales[SalesAmount])

The SUM function correctly aggregates the values in the SalesAmount column to compute total sales. While CALCULATE could also work, SUM is the direct and most efficient choice for simple aggregation. Other options either calculate an average or sum the wrong column.

Correct answer: B. To copy the DAX query so it can be edited in an external tool like DAX Studio.

The Copy query feature in Performance Analyzer extracts the exact DAX query generated by a visual. This allows developers to paste and analyze it in external tools like DAX Studio for performance tuning. It does not copy the visual itself or export data results.

Correct answer: A. Use a live connection to the semantic model and import inventory data into Power BI Desktop.

A DirectQuery or live connection can be combined with imported data using composite models in Power BI Desktop. Using Excel exports defeats the purpose of dynamic reporting, while separate linked dashboards do not provide a unified visual experience.

Correct answer: C. Use the "Clustering" feature in the Analytics pane for the visual displaying customer purchasing data.

The built-in clustering feature in the Analytics pane automatically groups scatter chart data points based on selected metrics. Manually creating groups or building complex calculated tables is unnecessarily rigid and misses native automated detection.

Correct answer: C. Reduce the data model size by removing unnecessary columns and rows.

Trimming the data model by removing unused columns and historical rows directly improves processing speed for both rendering and filtering. Changing refresh frequencies or swapping slicers for filters does not reduce the underlying memory footprint.

Correct answer: D. IsDuplicate = IF(COUNTROWS(FILTER(Customer, Customer[Email] = EARLIER(Customer[Email]))) > 1, "Duplicate", "Unique")

Using EARLIER inside a FILTER function correctly compares the current row's email against all other rows to find matches. Simple aggregations like COUNT evaluate the entire column rather than analyzing data row by row for duplicates.

Correct answer: A. The workspace is part of a Power BI Premium capacity.

The diamond icon indicates the workspace is backed by a Premium or Fabric capacity. This allows free-license users to consume content in that specific workspace. Certified datasets are marked with a badge, not a workspace diamond.

Correct answer: A. Create a column chart with ProductCategory on the axis and Sum of Profit as the value.

A column chart provides the clearest visual comparison of categorical data like product classes against aggregated profit. Line charts are reserved for continuous dates, while scatter charts plot correlations between numeric measures.

Correct answer: C. Users with free Power BI licenses can view reports in Premium capacity workspaces

Assigning a workspace to Premium capacity allows users with free licenses to view and interact with its reports. While performance can improve, the primary licensing benefit is broad distribution without requiring per-user Pro licenses.

Correct answer: C. Use the Share button in the Power BI service to grant access to specific users

The Share button grants explicit row-level security aware permissions directly within the Power BI service environment. Simply copying the URL fails because recipients will hit an access denied error without underlying workspace permissions.

Correct answer: C. Use Replace Values to remove '$' and ',' then change the data type to Decimal Number.

Replacing special formatting characters ensures the underlying digits can be cleanly parsed into a decimal number type. Changing the data type directly first will throw conversion errors because Power Query cannot process currency symbols.

Correct answer: A. Open the Power BI Desktop file, go to "Transform Data," and update the credentials in "Data Source Settings."

Updating credentials through the data source settings menu safely re-establishes the connection without altering the underlying queries. You should avoid editing the connection string manually to prevent breaking the applied model steps.

Correct answer: C. In Power Query Editor, update the Source step of the query to point to the production SQL Server database and refresh the data.

Updating the Source step in Power Query Editor changes the connection with minimal effort because downstream transformations remain intact when structures match. For the exam, remember that DAX calculated tables cannot directly query external databases like SQL Server.

Correct answer: B. In Excel, go to Data tab → Get Data → From Power BI and select the published dataset

Using Excel's Get Data from Power BI feature establishes a live connection that automatically respects row-level security. Exporting to CSV or downloading the PBIX file breaks live connectivity and compromises governance.

Correct answer: C. New Column

New Column creates a calculated column, which evaluates row by row in the data model. New Measure creates dynamic aggregations, which do not produce a value for each row in the visual table.

Correct answer: B. Update the file path in Power Query to use a fully qualified UNC path instead of a mapped drive letter.

Using a fully qualified UNC path ensures the on-premises data gateway can reliably locate the network file during cloud refresh. Mapped drive letters rely on local user profiles and are invisible to the Power BI service background processes.

Correct answer: C. A vertical orientation allows for better readability of product names when space is limited.

A vertical orientation maximizes screen width, allowing for better readability of product names when space is limited. Horizontal orientations cannot automatically adjust fonts, and both chart types support percentages.

Correct answer: B. Paginated Report

Paginated reports are designed to display detailed row-level data and perfectly preserve layout formatting across multiple pages when exported to PDF. Interactive Power BI reports have display limits that truncate large transactional extracts.

Correct answer: A. Ensure the gateway is running and the data source credentials are updated.

Verifying gateway status and data source credentials resolves the most common scheduled refresh authentication failures. Increasing refresh frequency or enabling row-level security does not fix credential validation errors.

Correct answer: B. Use a single-page dashboard with cards for totals, a bar chart for state claims, and a line chart for trends.

A single-page dashboard using cards for key totals and charts for categorical and temporal data provides a comprehensive overview. This layout balances high-level metrics with actionable trends. Separating metrics across pages reduces analytical effectiveness.

Correct answer: C. Instruct the manager to use "Analyze in Excel" from the Power BI service, which will automatically apply RLS

Analyze in Excel connects directly to the published Power BI dataset, so the established row-level security filters automatically apply to the PivotTable. Granting admin permissions or exporting raw data bypasses security and poses a significant data governance risk.

Correct answer: D. Apply a Power Query filter to remove old data before loading it into Power BI.

Filtering the date column in Power Query removes unnecessary rows before they ever load into the memory model, drastically reducing dataset size and improving performance. A DAX filter only hides the old data at runtime, leaving the unused data still loaded in memory.

Correct answer: C. Grant the contractor Direct Access with Build permission for the dataset.

Granting Build permission via Direct Access allows the contractor to connect to the dataset and author new reports without elevating their workspace rights. Adding the user directly to the workspace as a Member or Admin gives excessive control and poses a security risk.

Correct answer: C. The visual contains a complex DAX measure that is slowing down the query.

A high duration in the DAX Query category means the engine is taking a long time to evaluate the measure for that visual. Formatting and network latency appear elsewhere in the analyzer, so focus on tuning the DAX.

Correct answer: B. Use the SQL Server connector for the database and the Excel connector for the OneDrive file

Power BI Desktop supports multiple data sources in a single model, so using the native SQL Server and Excel connectors is the correct approach. Manual exports or the generic web connector lose native functionality and can break scheduled refreshes.

Correct answer: A. Use a slicer visual connected to the Regions column.

A slicer visual connected to the Regions column provides the required interactive dropdown experience. Row-level security is for securing data per user, while calculated columns are static and lack the interactivity users need.

Correct answer: B. Total Electronics Sales = CALCULATE(SUM(Sales[SalesAmount]), Products[Category] = "Electronics")

Using CALCULATE with a filter on the Products table correctly evaluates the total sales for the Electronics category across the existing relationship. The FILTER function requires an iterator like SUMX to work properly over the related Sales table.

Correct answer: C. Create a scatter chart with Unit Price on the x-axis and Quantity Ordered on the y-axis.

A scatter chart perfectly plots two continuous variables, revealing patterns across individual records. Pie charts or column charts aggregate data, hiding the granular correlation needed for this analysis.

Correct answer: D. A continuous range of dates with calculated columns for Year, Quarter, and Month

Date tables require a contiguous date range and calculated columns to support reliable time intelligence. Limiting the table to existing sales dates breaks time intelligence functions and creates gaps in visual timelines.

Correct answer: D. Create a DAX expression in the RLS role: Users[EmailAddress] = USERNAME().

Using USERNAME in an RLS role dynamically captures the current user's email to filter the Users table. A calculated column fails because RLS security requires strict table filters, not visual logic.

Correct answer: D. Use the "Column Quality" and "Column Distribution" options in the Query Editor.

Column quality and column distribution provide immediate visual summaries of valid values and anomalies directly within the editor. Fixing errors after loading data using DAX consumes unnecessary memory and ignores source-level optimization.

Correct answer: D. Create two parameters (StartDate and EndDate) and apply them in the SQL query's WHERE clause.

Applying parameters directly inside the SQL WHERE clause pushes the filtering back to the source server through query folding. Using DAX or slicers only filters the data after it has already been fully loaded into memory.

Correct answer: B. Use the "Use First Row as Headers" option in Power Query.

The Use First Row as Headers option promotes the initial row into column names, setting up a proper table schema. Manually removing rows and renaming columns is inefficient and ignores built-in transformation tools.

Correct answer: E. Replace calculated columns with measures where possible, optimize DAX expressions to reduce complexity, and remove unused columns from the data model.

Measures compute dynamically at query time and consume no memory storage, unlike calculated columns which bloat the model size and degrade performance. Removing unused columns further shrinks the VertiPaq cache, making this the optimal strategy for optimizing large, slow datasets.

Correct answer: C. Create a DAX measure using IF statements to return "Green," "Yellow," or "Red," then apply it as a conditional formatting rule in a KPI visual.

Creating a DAX measure with IF statements allows you to return a specific color name or hex code based on dynamic threshold logic. You then apply this measure via conditional formatting so the visual updates its colors automatically as the underlying sales numbers change.

Correct answer: C. Import

Import mode is the best choice for small datasets because it caches data in memory for maximum query performance. DirectQuery or live connections are intended for massive datasets or real-time requirements, not small local files.

Correct answer: C. Total Electronics Quantity = CALCULATE(SUM(Sales[Quantity]), Products[Category] = "Electronics")

The CALCULATE function modifies the filter context, allowing the filter on the Products table to propagate down to the Sales table. The SUMX option fails because it attempts to iterate over Products while aggregating an unrelated Sales column.

Correct answer: B. Replace blank values with "Unknown Customer" in Power Query

Replacing blanks with a descriptive placeholder in Power Query resolves the data quality issue without losing entire transactions. Deleting rows with blanks would permanently remove valuable sales records, skewing your aggregate totals.

Correct answer: A. Disable the "Export data" option for the report in the Power BI service and share the report via the app with Viewer permission.

Disabling the export data option combined with Viewer permission in the app prevents users from extracting the underlying records. Build permission or enabling data export would defeat the goal of minimizing data exfiltration risks.

Correct answer: B. Create a new security role and configure the DAX filter: [Region] == "East" && [Group] == "B".

Creating a new security role with the specified DAX filter cleanly isolates the East region permissions without altering existing roles. Modifying the existing role would accidentally overwrite or broaden the current security boundaries.

Correct answer: B. Update the credentials in the dataset settings in Power BI Service.

Updating data source credentials directly in the dataset settings re-establishes the connection without requiring report republishing. Reconnecting via Power BI Desktop is unnecessary and will not fix scheduled refreshes already configured in the service.

Correct answer: C. Create a date table using CALENDAR or CALENDARAUTO function and mark it as a date table

Standard DAX time intelligence functions require a dedicated date table marked as such to establish proper filter context. Relying on Auto Date/Time creates hidden tables that harm performance and limit control over your calculations.

Correct answer: A. Column Quality

Column Quality explicitly shows the percentage of valid, error, and empty values. Column distribution counts distinct values, and column profile provides overall statistics, but neither isolates nulls as clearly.

Correct answer: A. Add a quick measure to calculate the month-over-month change for SalesAmount.

Quick measures generate the underlying DAX for standard time intelligence calculations like month-over-month change. Creating a custom column in Power Query fails because it cannot dynamically adapt to user filter context.

Correct answer: C. Build permission on the dataset

Build permission allows users to create new reports connected to the dataset without modifying the data model. Contributor rights would give excessive access, allowing unwanted changes to the dataset structure.

Correct answer: B. Viewer

The Viewer role lets business users consume reports and pin visuals to their dashboards without editing rights. Contributor or Member roles would grant unwanted modification access to the underlying reports.

Correct answer: B. Define a DAX filter in the Manage roles settings to filter SalesData by region.

Row-level security requires defining a DAX filter within the Manage Roles settings. A report slicer fails this requirement because users can simply change the filter and view unauthorized regions.

Correct answer: C. Request the report author to enable the "Underlying data" option for this report.

Exporting underlying data is a tenant and report-level setting controlled by the author. If disabled, report consumers cannot extract raw row-level data, only summarized data depending on tenant limits.

Correct answer: B. Modify the parameter value directly in the Power BI Service under the dataset settings.

Power BI Service allows direct updates to configured dataset parameters for quick adjustments. Alternatively, updating and republishing from Power BI Desktop is also technically valid and often preferred for structural source control.

Correct answer: C. Use the "Remove Errors" option in Power Query to skip rows with invalid date values and load the valid data.

Using the Remove Errors option in Power Query removes only the rows containing data type errors, which preserves the rest of the valid dataset. While replacing errors is another valid cleaning technique, it alters the data rather than simply removing the broken rows.

Correct answer: A. Keyboard navigation

Keyboard navigation allows users to move through and interact with report visuals using standard keystrokes. High contrast modes and focus mode change visual displays but do not provide the underlying tabbing required for full activation.

Correct answer: A. Use Power Query to connect to the CSV file, enable query folding by filtering rows and removing unnecessary columns before loading, and disable "Enable load" for intermediate queries.

Filtering rows and removing columns early in Power Query reduces the data volume loaded into the model. Disabling the enable load setting for intermediate queries prevents unnecessary staging tables from consuming memory.

Correct answer: A. Applying sensitivity labels to the report

Applying sensitivity labels from Microsoft Purview Information Protection classifies data and applies protection settings. Changing report permissions limits who can see the report but does not classify the data's confidentiality level.

Correct answer: C. Use a report page tooltip with a small custom visual layout.

A report page tooltip allows you to design a custom canvas of visuals that appear when hovering over a data point. Drill-through pages require a click to navigate to a completely separate report page rather than showing a hover tooltip.

Correct answer: A. Use Power Query's "Expand Record" feature to flatten the JSON response and extract necessary fields.

The Expand Record feature in Power Query flattens nested JSON structures into standard tabular columns for easy integration. DAX cannot directly parse or extract raw nested JSON fields from an API response.

Correct answer: C. CALCULATE(SUM(Sales[SalesAmount]), DATESINPERIOD(Date[Date], TODAY(), -7, DAY))

DATESINPERIOD returns a continuous list of dates moving backward or forward from a start date, which correctly calculates a rolling 7-day total. DATESBETWEEN is also technically correct here for a literal 7-day range, making the question slightly ambiguous, but DATESINPERIOD is the standard DAX pattern.

Correct answer: C. Apply a dark theme that only targets report layout elements (e.g., background, fonts) by using a custom JSON file, so that the visuals retain their assigned colors

Custom theme JSON files provide precise control, allowing you to target page backgrounds and fonts without overriding manually assigned data colors. Applying a built-in dark theme globally would reset your visual colors, forcing you to reapply them manually.

Correct answer: C. Change the data type of the OrderDate column to "Date" in the Query Editor.

Changing the column data type to Date in Power Query standardizes how the engine interprets the underlying values. Using a calculated column in DAX is less efficient for cleaning than using Power Query, which handles structural transformation.

Correct answer: B. Highly Confidential

The Highly Confidential label applies the strictest sharing and protection controls, matching the policy for sensitive financial forecasts. Confidential might seem plausible, but it is a lower tier of sensitivity than the scenario demands.

Correct answer: C. Create a data alert on a dashboard tile displaying the temperature metric, set the threshold to 30°C, and configure email notifications.

Data alerts in the Power BI service are attached directly to dashboard tiles like gauges or cards to trigger email notifications when thresholds are met. Subscriptions only send scheduled snapshots and cannot trigger conditionally based on specific data values.

Correct answer: B. Define an RLS role in Power BI using a DAX filter that restricts data based on UserPrincipalName() and the Stores table.

Defining a dynamic RLS role using the UserPrincipalName function ensures managers only see their assigned store data securely. Page-level filters are insecure because end users can easily modify or clear them within the report view.

Correct answer: B. A calculated table in Power BI

A calculated table uses DAX to aggregate data and creates a new standalone table visible in the model. Measures only calculate values dynamically in visuals, while calculated columns just add fields to an existing table.

Correct answer: A. The data source query returns a large amount of unnecessary data.

High duration in the Performance Analyzer's Data Retrieval section means the underlying source query or model is slow to return data. A computationally expensive DAX measure would instead inflate the DAX query duration, while visual rendering delays spike the Visual Display metric.

Correct answer: B. Hide the unused columns in the Power BI model so they don't appear in report fields

Hiding unused columns keeps them in the semantic model for future use while decluttering the reporting interface. Deleting them from the data source would require a complete data refresh and model update to restore later.

Correct answer: C. Create two bookmarks, one for the line chart and one for the bar chart, and add buttons to toggle between the bookmarks.

Bookmarks capture the visibility state of visuals, letting you hide the bar chart and show the line chart, then assign a button to navigate between those saved states. Slicers filter data but cannot swap or hide visuals directly on a single report page.

Correct answer: C. A clustered column chart with months on the x-axis and categories as separate columns.

Option C is correct because placing columns side-by-side within each month provides the clearest direct comparison between the three product categories. A pie chart fails because it aggregates all months, completely losing the intended month-by-month breakdown analysis.

Correct answer: D. Filters pane

Option D is correct because the Filters pane centralizes management for visual, page, and report-level filtering. The Fields pane only lists tables and columns for selection, while the Visualizations pane formats charts rather than directly managing the applied filters.

Correct answer: C. Use the "Format" option in Power Query to apply Title Case to the Comments column.

Option C is correct because the built-in Format option within Power Query provides a direct way to apply capitalization changes cleanly. Option E fails because DAX lacks a native title case function, and data transformation should always occur before loading the model.

Correct answer: D. Use the "Conditional Column" feature in Power Query to define the High, Medium, and Low categories based on SalesAmount.

Using the Conditional Column feature in Power Query provides a user-friendly interface to define rules for categorizing data based on specified ranges. Writing a complex custom M formula is incorrect because it requires unnecessary manual coding when a built-in interface exists.

Correct answer: A. Configure a scheduled refresh in the Power BI Service for the dataset, setting it to run daily at 8 AM using the on-premises data gateway.

Configuring a scheduled refresh in the Power BI Service uses the on-premises data gateway to connect to the SQL Server, ensuring automatic daily updates. Option B fails because bypassing the gateway prevents the Power BI Service from accessing the secure on-premises database.

Correct answer: D. Conditional formatting with background color rules

Applying conditional formatting with background color rules dynamically highlights specific rows based on their underlying numerical values. This approach draws immediate attention to outliers without manually filtering out the data.

Correct answer: B. Create two bookmarks: one for "Before Campaign" and one for "After Campaign."

Bookmarks capture the current state of selected visuals, filters, and properties without altering the base report layout. Slicers are a strong distractor, but bookmarks efficiently swap data contexts while maintaining identical canvas positions.

Correct answer: A. Error handling in Power BI allows you to define custom actions when encountering errors during data transformation or query execution.

Option A is correct because Power Query provides specific transformations to handle data quality issues. Option B fails because Power BI provides built-in options like Remove Errors or Replace Values rather than just displaying messages.

Correct answer: C. Aggregation Method

Option C is correct because configuring bins relies on setting size or range boundaries, not applying math functions. Aggregations like Sum or Average are handled later in DAX measures or visual calculations rather than during the grouping step.

Correct answer: A. To change the cross-filter direction between two tables while maintaining the original settings.

Option A is correct because CROSSFILTER modifies how filters propagate between tables for a specific calculation without permanently altering the model relationship. Option B fails because relationships must be created in the model view rather than via DAX.

Correct answer: A. Use bookmarks to capture the state of the report with bar and pie charts and link buttons to these bookmarks.

Option A is correct because bookmarks save the visibility and state of visuals, which can then be triggered by buttons. Field parameters cannot switch core visual types, making option C an impossible workaround for dynamically changing native chart formats.

Correct answer: B. The running total will recalculate and show cumulative sales only for the selected year.

Option B is correct because the DAX measure evaluates within the current filter context, resetting the cumulative sum for the selected year. Option A fails because CALCULATE respects visual filters unless explicitly overridden with functions like REMOVEFILTERS.

Correct answer: B. Total Revenue = SUMX(Sales, Sales[Quantity] * Sales[UnitPrice] * (1 – Sales[Discount]))

SUMX is an iterator function that evaluates the row-level expression first, then sums the results. Standard SUM cannot evaluate multiple row-level columns multiplied together without an iterator.

Correct answer: B. Closing Stock = CALCULATE(SUM(Inventory[StockQuantity]), LASTDATE(Inventory[Date]))

CALCULATE modifies the filter context to evaluate the sum of stock quantities specifically for the final date in the current context. LASTDATE returns that latest visible date, making option B the correct DAX pattern. Other options fail to filter by date correctly.

Correct answer: B. Apply the "Remove Duplicates" feature on the CustomerID column in Power Query.

Applying Remove Duplicates directly on the CustomerID column in Power Query efficiently drops duplicated rows during data preparation. This ensures data cleanliness before loading the model. Creating DAX calculated columns to handle duplicates is inefficient and skipped during data prep.

Correct answer: C. Cross-filtering hides unrelated data, while cross-highlighting dims them.

Cross-filtering removes unrelated data from the visual entirely, showing only the filtered results. Cross-highlighting retains all data points but dims the unrelated ones, allowing users to compare the highlighted selection against the total context within the visual.

Correct answer: C. Filter and reduce data early in the transformation process.

Filtering and removing unnecessary columns or rows early in Power Query reduces the memory footprint of the imported dataset. Performing expensive operations before filtering wastes compute resources. Query folding also performs better when you apply filters early.

Correct answer: E. Add a slicer visual, select the Year column from the Date table, and set it to dropdown mode.

Adding a slicer visual with the Year column from the Date table allows users to dynamically filter the table, leveraging the existing relationship for accurate filtering. Option A fails because filtering directly on the fact table bypasses the optimized date relationship.

Correct answer: C. Share the report by granting the team Viewer access to the workspace in the Power BI Service.

Granting the team Viewer access to the workspace in the Power BI Service allows authorized colleagues to view the report securely online without needing Power BI Desktop. Saving and sharing the .pbix file via a shared drive is incorrect because it exposes the underlying data and requires the desktop application.

Correct answer: A. Apply filters in Power Query to select only the Electronics category and SaleDate within the last two years before loading.

Applying filters directly in Power Query before loading reduces the dataset size, which improves performance by minimizing memory usage and query execution time. Option C fails because loading the entire dataset into the model defeats the purpose of optimization and consumes unnecessary memory.

Correct answer: D. Adjust the Canvas Settings to a 16:9 layout.

Adjusting the Canvas Settings to a 16:9 layout changes the report page dimensions to match modern widescreen displays without distortion. The 4:3 layout is incorrect because it represents older square monitor ratios, leaving unused space on modern screens.

Correct answer: A. Contains descriptive attributes such as names and categories.

Dimension tables contain descriptive attributes like names and categories, providing the necessary context to slice and filter fact data. Option B is incorrect because transactional data such as sales amounts and quantities belongs in a fact table, not a dimension table.

Correct answer: C. They work together using AND logic (all conditions must be true)

In DAX, multiple filter arguments targeting different columns inside the CALCULATE function combine using AND logic, requiring all conditions to be met. Remember that multiple filters applied to the exact same column use OR logic instead.

Correct answer: A. Use the "View as" feature in Power BI Service to test different roles

The Test as role feature in the Power BI service lets analysts simulate dynamic security groups without needing actual user credentials. This validates exact data restrictions quickly compared to asking users to verify.

Correct answer: B. Add alt text descriptions to the visual that include key data insights

Adding alternative text to visual properties provides screen readers a textual summary of the data, ensuring accessibility for visually impaired users. Do not rely on interactive hover elements alone for critical report insights.

Correct answer: B. The range of values included in each bin

The Bin Size parameter determines the numerical interval width distributed across each discrete grouping, such as ten years per age bucket. The alternative option simply sets the total quantity of groups instead.

Correct answer: D. Enable guest access in the Power BI Admin portal and invite the external users.

External collaboration requires enabling Azure Active Directory B2B guest access inside the tenant settings before sending secure workspace invitations. Simply dropping users into a member role fails without proper identity provisioning.

Correct answer: B. Line and stacked column charts display total and individual contributions across a series.

Option B is correct because stacking visually represents the total height while showing how each segment contributes to that whole. Clustered columns place metrics side-by-side, making it harder to see the combined total at a glance.

Correct answer: A. Set up a scheduled refresh in the Power BI Service and configure it to run every two hours.

Scheduled refresh in the Power BI Service allows you to automate dataset updates at specific intervals. For cloud data sources like SQL Database, this handles the requirement without a gateway, unlike external automation flows.

Correct answer: D. Adjust the X-axis formatting options such as text size, orientation, or label density

Adjusting X-axis formatting options resolves cluttered labels without modifying the underlying data or hiding visual elements. The other options remove valuable historical context or alter the visual type entirely.

Correct answer: D. Line and clustered column chart

A line and clustered column chart combines two chart types, allowing you to plot trends using a line and categories using columns. This makes it perfect for showing actual versus target values.

Correct answer: A. Grouping allows manual separation of data points into specific categories while binning automatically separates them into equal intervals.

Grouping manually combines selected categorical data points into custom categories, while binning automatically divides numerical fields into equal-sized intervals. Binning is ideal for continuous numbers like ages, whereas grouping targets discrete categories or specific dimensional values.

Correct answer: A. Configure the gateway connection for the dataset and schedule a refresh in the Power BI Service.

On-premises data sources require an on-premises data gateway to bridge the connection. Once the gateway is configured, you schedule the refresh in the Power BI Service dataset settings. Power BI Desktop does not support automated scheduling or unattended background refreshes.

Correct answer: A. It leads to data redundancy and inconsistency.

A flat schema suffers from data redundancy and update inconsistencies because it lacks separate dimension tables. Power BI strongly recommends using a star schema to ensure data integrity, improve performance, and avoid duplicating dimensional data across large fact tables.

Correct answer: C. They condense information into pop-up boxes that appear upon hovering over a data point.

Tooltips reduce visual clutter by hiding contextual details inside interactive pop-ups that appear when users hover over a data point. They do not replace base visual descriptions; instead, they supplement the existing report layout.

Correct answer: A. Navigating from a main report or visualization to a detailed, focused report page

Drillthrough creates a target page filtered to the specific context of a data point. It is not cross-filtering, which interacts with visuals on the same page.

Correct answer: A. In the Power BI Admin portal, assign the workspace to Premium capacity.

Workspaces are assigned to Premium capacity through the workspace settings or the Power BI Admin portal. This enables larger datasets and increased refresh limits. Row-level security and dataset certifications do not dictate capacity assignment or workspace compute resources.

Correct answer: A. It determines how effectively and efficiently data can be stored, managed, and analyzed.

Choosing the right schema is foundational because it directly affects storage efficiency, data integrity, and query performance, ensuring data can be managed and analyzed effectively. Option B is too narrow because schema design optimizes retrieval and analysis, not the initial collection speed.

Correct answer: G. I, II, III, IV, V

Unpivoting columns in Power Query requires selecting the target columns, applying the unpivot transformation, and then renaming the generated attribute and value pairs. Option G lists this exact logical sequence.

Correct answer: B. Sales Data, because it contains transactional details used for calculations and aggregations.

The Sales Data table is the fact table because it contains transactional metrics like Quantity and Total Sales used for aggregations. The other tables are dimensions, which provide descriptive context for filtering and grouping the numerical facts.

Correct answer: C. LateOrderPct = DIVIDE(COUNTROWS(FILTER(Sales, Sales[ShipDate] > Sales[ExpectedShipDate])), COUNTROWS(Sales), 0)

The correct DAX expression filters the table for late orders, counts those rows, and safely divides by the total row count. Options using basic division without DIVIDE risk errors from zero denominators, and CALCULATE cannot directly accept a boolean filter expression like this.

Correct answer: D. Use the Excel Workbook connector and select the "SalesData" sheet.

Using the Excel Workbook connector opens the Navigator window, letting you select exactly which sheet to load. The Folder and Web connectors are for different data sources, while importing the entire workbook wastes system resources and requires unnecessary transformations.

Correct answer: A. A line chart with SaleDate (Month) on the x-axis and SalesAmount on the y-axis.

A line chart is the standard visual for displaying continuous data trends over time, effectively highlighting patterns and changes across months. Bar and pie charts are better for categorical comparisons, while tables lack immediate visual trend clarity.

Correct answer: C. Import mode, because it allows for faster report performance and complex data modeling.

Import mode copies the data into memory, providing the fastest report rendering and allowing complex DAX calculations and relationships. DirectQuery is reserved for near real-time needs, whereas Import mode relies on scheduled refreshes rather than providing live insights.

Correct answer: A. Top Segments

Switching to the Top Segments tab groups the data into clusters that share similar characteristics and display the target metric prominently. The primary Key Influencers tab isolates individual factors that drive the metric higher or lower, rather than grouping data points.

Correct answer: C. Set the storage mode to DirectQuery for the dataset

Setting the storage mode to DirectQuery sends queries to the underlying Azure SQL database in real time, fetching the most current data upon interaction. Import mode and scheduled refreshes rely on cached data, meaning users might see outdated information.

Correct answer: C. Install the Power BI app in Teams and create a new report using the Dataverse connector

Installing the Power BI app within Microsoft Teams and utilizing the native Dataverse connector provides direct, seamless access to the project data. Exporting to CSV or relying on SharePoint connectors creates unnecessary friction and bypasses the built-in integration features.

Correct answer: B. To streamline the deployment of datasets, reports, and dashboards across Development, Test, and Production environments.

Deployment pipelines streamline moving datasets, reports, and dashboards across development, test, and production stages. This managed lifecycle ensures content is thoroughly validated before reaching business users, whereas other options describe unrelated administrative tasks.

Correct answer: D. Select "Percentage of grand total" for SalesAmount with Product as the base field.

The percentage of grand total quick measure divides each product's sales by the overall total sales amount. This efficiently calculates the requested contribution without writing manual DAX, unlike rolling averages or running totals which track cumulative time data.

Correct answer: A. Scatter chart

A scatter chart plots two numerical values against each other, making it ideal for identifying correlations and outliers. Pie charts and tables fail to highlight unusual combinations effectively, such as short recovery times paired with low satisfaction scores.

Correct answer: A. Create a reference of the Sales query.

Creating a reference outputs a new query linked to the original, so upstream changes flow downstream automatically. Duplicating creates a disconnected static copy, meaning any future updates to the original query will not be inherited.

Correct answer: B. Line Chart with Multiple Lines

A line chart with multiple lines easily compares continuous trends across several categories side-by-side over time. Bar charts are better for independent snapshots, while pie charts obscure continuous historical patterns across multiple factories.

Correct answer: C. Configure row-level security (RLS) in Power BI Desktop by defining roles based on the Region column.

Configuring row-level security filters data at the database level, restricting regional managers from viewing unauthorized records. Unlike visual filters or slicers, RLS cannot be easily bypassed by users in the service, providing true dynamic data governance based on the logged-in user.

Correct answer: E. Create a many-to-one relationship from Sales[CustomerID] to Customers[CustomerID].

Creating a many-to-one relationship from the Sales table to the Customers table ensures filter context correctly propagates downwards. This native model design keeps the dataset efficient and interactive, bypassing the performance penalties of DAX lookups or merged tables.

Correct answer: E. Create a star schema with the Sales table as the fact table, Products, Customers, and Dates as dimension tables, and use a DateKey column to link Sales to Dates.

A star schema with Sales as the central fact table surrounded by dimension tables optimizes in-memory processing and simplifies DAX calculations. Establishing a dedicated Date table ensures native support for time intelligence functions and accurate filtering.

Correct answer: D. Create a calculated column to calculate the delivery duration and a calculated table to summarize the total shipment cost per country.

Creating a calculated column computes row-level values for each shipment, such as the duration between two dates. Generating a calculated table evaluates DAX to output a summarized grouping, which is perfect for aggregating total cost by country.

Correct answer: E. Apply Row-Level Security (RLS) with roles for each region and a role for global executives, assigning users in the Power BI Service, and disable dataset sharing.

Row-Level Security restricts data access at the model level, preventing external tools from bypassing report filters. Creating distinct roles for regions and executives is maintainable, while disabling sharing strictly enforces the intended governance.

Correct answer: C. Use the Publish button in Power BI Desktop to publish the report to the desired workspace in Power BI Service

Using the Publish button in Power BI Desktop directly uploads the report and dataset to the specified workspace in the service. While uploading a file works, the built-in publish button is the most efficient and standard method.

Correct answer: B. Use the "SharePoint folder" connector, select the combine option, apply necessary transformations, and load the data into Power BI.

Using the SharePoint folder connector points Power BI directly to the online directory and natively combines the files through a single click. The generic Folder connector requires complex local gateway setups for SharePoint, and manual appends fail to capture newly added files dynamically.

Correct answer: B. The "Report Performance" tab measures report load times, while the "Report Usage" tab tracks viewer interactions.

The Report Performance tab tracks how long reports take to open and render, helping identify bottlenecks frustrating users. Conversely, the Report Usage tab monitors viewer statistics like who accessed the report and how often, rather than technical load metrics.

Correct answer: A. Make changes to the data model in Power BI Desktop, then use the Publish button to overwrite the existing report in Power BI Service

Updating the data model in Power BI Desktop and republishing overwrites the existing dataset and report, seamlessly applying changes. Deleting the report manually is unnecessary and would break existing permissions or subscriptions, making it inefficient.

Correct answer: B. YTD Sales := CALCULATE(SUM(Sales[Sales Amount]), DATESYTD('Sales'[Order Date]))

Using CALCULATE with DATESYTD correctly aggregates the sales amount from the beginning of the year to the latest filtered date. Option C is technically valid but Option B provides the cleaner, more standard DAX pattern without hardcoding dates.

Correct answer: B. Verify that visual interactions are enabled and the card is set to be filtered by the bar chart

Enabling visual interactions allows for the filtering of one visual based on selections made in another. By verifying that visual interactions are enabled and setting the card visual to be filtered by the bar chart, selecting a region in the bar chart will update the card visual accordingly.

Correct answer: B. Install and configure an on-premises data gateway, then set up scheduled refresh in Power BI Service

An on-premises data gateway securely bridges Power BI Service to local data sources like SQL Server. Once configured, you can define the 4-hour scheduled refresh intervals natively within the service settings. Cloud migration isn't required, and manual desktop refreshes don't automate enterprise reporting.

Correct answer: C. Use the SharePoint Folder connector and configure a scheduled refresh in Power BI Service

The SharePoint Folder connector natively combines multiple CSV files into a single table within Power Query. Because SharePoint Online is a cloud source, you only need to configure a standard scheduled refresh in the service without relying on a gateway.

Correct answer: B. Use the "Conditional Column" feature in the Query Editor.

Using the Conditional Column feature in the Query Editor provides a visual interface for building nested if-then logic without writing code. This pushes the transformation back to the source, optimizing the model compared to adding a DAX calculated column.

Correct answer: D. Grant the Finance team Build permission on the semantic model and the Sales team Read permission.

Build permission grants users the ability to connect to a published semantic model and create new reports. Read permission limits users to viewing existing reports, preventing them from modifying or building from the model.

Correct answer: D. Alerts

Data alerts in the Power BI service monitor dashboard tiles and trigger email notifications when metric thresholds are met. Subscriptions only send scheduled snapshots, while filters and bookmarks are interactive reporting tools that do not send alerts.

Correct answer: C. Use the SharePoint Folder connector to combine the files into a single table

The SharePoint Folder connector accurately targets files stored in SharePoint Online and natively combines them into a single table. The standard Folder connector is practically identical for SharePoint, making option B an equally defensible choice.

Correct answer: B. DirectQuery mode, because it supports real-time data updates directly from the source.

DirectQuery is correct because it queries the underlying source live, meeting the up-to-the-minute requirement without importing sensitive data into memory. For the exam, remember Import mode is faster but requires scheduled refreshes and stores data locally.

Correct answer: C. Member

The Member role is correct because it permits managing workspace membership without granting the broad administrative control or content publishing rights. Remember that Contributors can edit content but cannot manage members.

Correct answer: B. Assign users or security groups to the appropriate RLS roles in the dataset security settings

Assigning users to roles in the dataset security settings enforces row-level security dynamically based on the user viewing the report. Workspace roles are incorrect because they control environment access, not data filtering.

Correct answer: C. Use the Azure SQL Database connector in DirectQuery mode, create measures for anomaly detection, and publish the report to the Power BI service.

Using DirectQuery with Azure SQL provides the real-time data access needed to monitor immediate transaction anomalies. Importing data or using scheduled refreshes is incorrect because the resulting latency prevents the required live detection.

Correct answer: C. Publish the dataset to Power BI Service, then certify the dataset and share it to Excel as an organizational data type.

Publishing and certifying the dataset promotes it as a trusted source, which can then be exposed as an organizational data type. Simply endorsing the dataset is incorrect because it misses the explicit step of sharing it to Excel.

Correct answer: B. Grant the manager Contributor role in the workspace and instruct them to create a dashboard using the report's visuals.

Granting the Contributor role lets the manager pin visuals to a new dashboard without altering the source dataset. Option E changes the user's workspace context unnecessarily, whereas Contributor natively supports creating personal dashboards directly from existing workspace reports.

Correct answer: A. Only the lower Error Bar will be displayed, extending downward by 20%.

Setting the upper bound to 0% effectively hides the upper error bar, while the 20% lower bound draws it downward. This visually represents the potential variability below the data points. The configuration is perfectly valid in Power BI desktop.

Correct answer: A. Configure a data gateway and set up scheduled refresh twice a day

A scheduled refresh requires a data gateway to securely bridge on-premises SQL Server data into Power BI Service. Incremental refresh requires partitions rather than fixed schedules, and Power Automate is unnecessary overhead for standard scheduling.

Correct answer: D. A goal value and its percentage achievement

KPI visuals display an actual value alongside a target goal, showing how the metric tracks against expectations. Progress bars or pie charts are separate visual types, while trendlines are typically shown in line charts.

Correct answer: D. Create a dataflow in Power BI, Choose the DirectQuery mode for data connectivity, Use the Power Query editor to transform data as needed, Connect the dataflow to the Power BI dataset using DirectQuery.

Creating a dataflow, selecting DirectQuery, transforming the data, and linking it to the dataset provides live connectivity. Saving the dataflow alone is incorrect because you must connect it to the dataset to build reports.

Correct answer: C. II, III, IV, VIII

A virtual network gateway securely connects to the Azure PostgreSQL database without needing personal machines. Configuring scheduled refresh updates the data daily, while setting the owner as an admin ensures they have proper gateway management access.

Correct answer: D. VI – I – III – V – VII – IV – II

The standard workflow requires creating the project, coding in TypeScript, packaging the file, and then testing it locally. Deployment to the Power BI service logically follows successful local validation, as deploying untested code disrupts end users.