Prepare the data Questions
Practice questions for Prepare the data topic in Microsoft Certified: Power BI Data Analyst Associate. 55 questions covering this domain.
A report author needs visuals to query source data when users interact with the report instead of storing the table data in the semantic model. Which ...
A developer needs to merge two tables by CountryID and StateID. What must be true when selecting multiple join columns?
In Power Query, which merge join kind returns all rows from the left table and only matching rows from the right table?
A semantic model uses a dynamic data source where part of the connection information is generated in code at refresh time. What is the main risk in th...
A Power Query step raises Formula.Firewall because it references another query and directly accesses a data source in the same partition. Which redesi...
A single Power Query mashup merges an on-premises SQL table with an Azure SQL table. Which gateway rule applies when the semantic model is refreshed i...
An analyst wants to combine Online Sales and Store Sales into one table by stacking rows and matching columns by name. Which Power Query operation sho...
Two tables are appended, but one source lacks the Referrer column found in the other. What appears in the missing column for those rows?
A flat export file contains product attributes mixed into every sales row. According to star schema guidance, what is the preferred preparation approa...
When using classic time intelligence with a custom date table, what must you do in Power BI Desktop?
A Fabric-based semantic model should scan OneLake delta tables for fast report loading and, by default, show the latest data. Which table storage mode...
A Power Query author wants a reusable value that can be changed once and referenced in multiple transformations. What should be created?
A query uses a parameter called Minimum Margin in a filter step. If the current value changes from 0.2 to 0.3, what happens to the filtered query resu...
A model must keep a very large Sales fact table near real time while keeping slicers fast for Date, Customer, and Geography. Which design best fits Mi...
A column contains values like "USD 12.50" and "USD 100.00" and the analyst needs only the numeric portion as a Decimal Number. Which combination of st...
An author wants Power Query to remove rows where Quantity is null without breaking later steps. Which operation should be used?
An analyst sees a query against a SQL Server source running slowly. Right-clicking a step shows "View Native Query" is greyed out. Which conclusion is...
Which gateway type should an analyst install for personal scheduled refresh of Import datasets that connect to a single user's on-prem data sources?
An author wants to query Excel files stored in a SharePoint document library. Which connector should be used?
An analyst needs to identify and remove duplicate rows based on the Email column only. Which Power Query approach fits best?
Sign in to see all 55 questions
Create a free account to browse all questions — completely free during our launch phase.