A report designer wants users to navigate like an app. Which feature?

To combine customer data from SQL and marketing data from Excel while keeping refresh incremental for SQL only, you use:

You need to show top 5 products by sales in a visual but allow dynamic ranking. Best DAX?

A colleague edits the shared dataset causing errors in your report. Best prevention?

To reduce model size when storing daily data for 5 years, you should:

You have a DirectQuery model with multiple complex joins causing slow performance. Best optimization?

A financial report needs dynamic currency conversion based on a currency table. DAX pattern?

You must deploy a dataset from dev to test to production with automated versioning. Recommended feature?

To prevent accidental data exposure when exporting summarized data, you configure:

A report uses Azure Synapse as source. To reduce costs while maintaining near real-time, you:

Your DAX measure must return prior year sales for same month, ignoring all filters except Date. (8 Points) CALCULATE([Total Sales], SAMEPERIODLASTYEAR(Date[Date])) Why might this fail?

Security requires that some columns be masked based on user roles. Best method?

A Power BI tenant has hundreds of datasets. To monitor refresh failures centrally, you:

You must schedule refresh of a dataflow every 5 minutes. Requirement?

You need a calculation that iterates rows and applies a complex condition across related tables. Which DAX pattern is best?

To provide custom visuals across the organization, you:

A DirectQuery dataset must support Q&A natural language queries. To optimize, you:

To allow business users to create their own reports on an endorsed dataset while keeping governance, you:

Your data model shows performance issues due to high cardinality columns used as relationships. Best step?

You connect Power BI Desktop to a CSV file containing a “DateOfBirth” column stored as text (e.g. “1990-05-15”). You want to change the type so you can work with date functions. Which step should you do in Power Query?

A business user gives you a flat Excel file with FirstName and LastName columns. They want a single “FullName” column. Which is best?

Which connection mode would you use if the data source size is very large and you need near-real time updates?

You have multiple tables that don’t share a key. To join them in Power BI you use:

In a report you want users to drill down by Year → Quarter → Month on date. What do you need?

A user in a certain country must see only their own country’s data in all visuals. What do you set up?

You publish several reports that all use the same underlying data model. To avoid duplicating the model, you should:

Which of these visuals supports data alerts in Power BI Service?

You want to parameterize the path to a data source so you can change file location easily without editing each query. Where do you define that?

A user tells you the dashboard visuals are too slow because too many columns and tables are querying every time. First step?

In a published workspace, you want some people to edit reports, others only to view. Which workspace role settings are appropriate?

The date table doesn’t have continuous dates (some missing days). Time intelligence (e.g. YTD) functions aren’t working correctly. What’s likely wrong?

A model has columns “OrderDate” and “ShipDate”. You want a measure “Average Shipping Delay (in days)”. How would you write that in DAX?

To combine large historical data in SQL Server with small incremental daily data from Excel, while keeping performance, you can:

A manager wants to see sales growth month-over-month but only for products that have appeared in the previous month. What kind of DAX filter should you apply?

There are several reports in a workspace; one dataset fails refresh due to credential issues. Which steps help fix it?

You notice query folding has broken after performing a custom transformation. Why is query folding important?

A report needs bookmark navigation buttons to switch views: “Summary”, “Detail”, “Compare”. What must you configure?

A dataset has many high cardinality string columns that are used for relationships, making the model slow. What optimization?

A company requires data sensitivity labels on all published reports. What should you configure?

To monitor which datasets are not refreshing properly, what tools are available?

You want to restrict who can create content in a workspace, but allow others to view and use content. Best roles assignment?

Which scenarios best fit using incremental refresh?

A multi-fact model needs to provide aggregated data for fast dashboarding. How would you structure that?

You need a measure that calculates rank of customers by total sales but resets every year. DAX measure should use:

For visuals showing trends, business wants ability to see forecast + actual. Which feature in Power BI helps?

Which visual is ideal for comparing one key metric against a target?

A business user wants a button to reset all slicers to defaults. Which built-in action is best?

When publishing a report that uses an on-prem SQL Server in Import mode, what must be configured for scheduled refresh?

You need a DAX measure to calculate total profit margin as percentage.

A report uses a custom visual from AppSource. How do you ensure it remains available for all users in the organization?

Your model contains a calculated column that duplicates a DAX measure’s logic. Why might this hurt performance?

Which page type gives the best mobile-friendly layout?

A Power BI Pro workspace member needs to share a report with an external user. What’s required?

Your data model has multiple fact tables (Sales, Inventory). What is the recommended relationship design?

A user complains the report refresh takes too long because of large text columns. Which step reduces size?

A dataset with incremental refresh needs to store 5 years of history but refresh only last 30 days. You should:

To allow “Ask a question” natural language queries, you must configure:

You want to create a parameter for database server name so you can easily switch between Dev and Prod. Where do you set it?

For a dataset using DirectQuery, which transformation will force query folding to break?

A workspace Admin wants to audit report usage. What built-in tool helps?

Which scenario justifies a Hybrid Table?

You have a data model in Power BI. The relationships are configured as shown below. (Imagine a Model View diagram showing: Figure 1.0) Based on the data model, you create a table visual with Category from the Product table and Sum of Revenue from the Sales table. The values calculate correctly. What does this demonstrate?

Based on Figure 1.0 You write the following DAX measure in the Sales table: Total Store Revenue = CALCULATE(SUM(Sales[Revenue]), ALL(Store)) You add Region from the Store table and the Total Store Revenue measure to a table visual. What will the value for each region be?

Based on Figure 1.0 You need to analyze revenue by month. Which field should you put on the X-axis of a line chart to ensure the months are in chronological order and can be used with time intelligence functions?

You are in the Power Query Editor and see the following preview for a column named "ProductCode": ProductCode 123-456 ABC-789 DEF-012 (8 Points) You need to split this column into two columns at the hyphen ("-"). Which split option should you use?

You have a line chart showing sales over time. A user wants to highlight a specific time period to see corresponding data in other visuals on the page. Which feature should they use?

Imagine a Clustered Column Chart showing "Sales by Country". The countries on the X-axis are: USA, UK, Japan, Germany, Australia. The values for USA are significantly higher than all others. You want to make the column for the USA stand out even more. What should you do in the Format pane for this visual?

You create a measure to calculate year-over-year growth: YoY Growth % = VAR PYRevenue = CALCULATE( SUM(Sales[Revenue]), SAMEPERIODLASTYEAR('Date'[Date]) ) RETURN DIVIDE(SUM(Sales[Revenue]) - PYRevenue, PYRevenue) The result is a whole number (e.g., 0.25) instead of a percentage (e.g., 25%). How do you fix this?

You have a table in Power Query with a column named "Status" containing the Values: ["Complete", "In Progress", "Not Started", "Complete", null]. You need to replace the null value with the text "Not Started". Which transformation should you use?