PL-300 practice questions 41–50

1. Question 41 · 358 in bank

   HOTSPOT - You are designing the data model for a Power BI semantic model. You have the following tables in the star schema.

   

   Which table is the fact table of the star schema, and which column in the Patient table is the surrogate key of the star schema? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Fact Table: Test Result Surrogate Key in Patient Table: Patient Key The fact table is the central table in a star schema and contains measurable data (e.g., metrics, values) and foreign keys to connect to dimension tables. The Test Result table is the fact table because: It contains measurable data like "result value." It includes foreign keys to dimensions like date, test key, and patient key. A surrogate key is a unique identifier for a row in a table, typically used as the primary key in star schemas. The Patient Key is explicitly stated as the unique identifier for rows, making it the surrogate key.

   Source: Adapted from community discussion — b2775a4

   

   Next question

2. Question 42 · 358 in bank

   You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns: • Customer_Name • Customer ID • Website The Contacts table contains the following columns: • Contact ID • Contact Email • Contact Name • Customer Name A web-based contact form is used to fill the Contacts table. The data is not sanitized. You need to create a merge for the Customer and Contacts tables. What should you do?

   • ADisable fuzzy matching.
   • BEnable fuzzy matching.
   • CSet Join Kind to Left Outer.

   Show answer

   Answer: B

   Explanation

   First Why enable fuzzy matching? Since it says the Contacts table is filled using a web-based form without data sanitisation, there may be inconsistencies in how customer names are entered. Fuzzy matching will help match similar strings, accommodating for typos, capitalisation differences, and other minor variations in the customer names. "No confusion, and no need to discuss further" /s jk feedback welcome especially where I might be mistaken

   Source: Adapted from community discussion — NyashaDuri

   Next question

3. Question 43 · 358 in bank

   HOTSPOT - You are using Microsoft Power BI Desktop to profile data in Power Query Editor. Table data is displayed as shown in the following exhibit.

   

   Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   

   Next question

4. Question 44 · 358 in bank

   HOTSPOT - You have a Power BI semantic model named Model1 that contains a table named Sales. Sales contains 10 million records and the following data.

   

   The related report displays the weekly sales per region. You need to minimize the size of Model1. How should you modify the CustomerID column and the PurchaseDateTime column? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Since the report only displays weekly sales per region and doesn't require customer-level detail, you can remove the CustomerID column entirely to reduce model size. For the PurchaseDateTime column, splitting it into separate Date and Time columns lets you keep only the date portion (if that's all that's needed for weekly grouping), thereby minimizing unnecessary data.

   Source: Adapted from community discussion — Zander3

   

   Next question

5. Question 45 · 358 in bank

   You have a Microsoft Power BI Desktop report named Report1 that uses an Azure SQL database as a data source. A user named User1 plans to create a report by using the same data source as Report1. You need to simplify the connection to the data source for User1. Which type of file should you create?

   • APBIDS
   • BXLSX
   • CPBIT
   • DPBIX

   Show answer

   Answer: A

   Explanation

   Answer: A. PBIDS A .pbids (Power BI data source) file is specifically designed to simplify connections to a data source. If the user double-clicks the .pbids file, Power BI Desktop opens and automatically connects them to the specified data source—making it easy for someone else (User1) to reuse the same Azure SQL connection as in Report1.

   Source: Adapted from community discussion — Oleh777

   Next question

6. Question 46 · 358 in bank

   HOTSPOT - You have a Power BI semantic model. You discover that the semantic model contains values that display as errors. You need to use data profiling features in Power Query to preview the data and identify the issues. What should you select to gain insight into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area. NOTE: Each correct answer is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   "Column quality" is what helps us gain insight because it shows the number of valid values, errors, and empty values in a column. For resolution, "Replace errors" would actually allow us to fix those errors, unlike options like "Remove duplicates" or "Remove empty," which don’t actually address the errors themselves.

   Source: Adapted from community discussion — Zander3

   

   Next question

7. Question 47 · 358 in bank

   You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database named DB1. Model1 must show updated data within two minutes of the data being updated in DB1. You need to select a connectivity mode for the connection to DB1. What should you choose?

   • ADirectQuery
   • Blive connection
   • Cimport

   Show answer

   Answer: A

   Next question

8. Question 48 · 358 in bank

   Select 3

   You need to create a semantic model in Power BI Desktop. The solution must meet the following requirements: • The model must contain a table named Orders that has one row per order. Each row will contain the total amount per order. • The orders must be filtered to the selected CustomerID value. • Users must select the CustomerID value from a list. • The list of customers must come from an OData source. Which three objects should you create in Power Query Editor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • Aan Orders query that has a filter on CustomerID
   • Ba Customers query that has a filter on CustomerID
   • Can Orders query that has a single column containing a list of customers
   • Da Customers query that has a single column containing a list of customer IDs
   • Ea parameter for CustomerID that uses a query to populate the suggested values
   • Fa parameter for CustomerID that uses manually entered values to populate the suggested values

   Show answer

   Answer: ADE

   Next question

9. Question 49 · 358 in bank

   HOTSPOT - You have two Azure SQL databases that contain the same tables and columns. For each database, you create a query that retrieves data from a table named Customer. You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Append Queries as New - When you have additional rows of data that you'd like to add to an existing query, you append the query. There are two append options: * Append queries as new displays the Append dialog box to create a new query by appending multiple tables. * Append queries displays the Append dialog box to add additional tables to the current query. Incorrect: When you have one or more columns that you'd like to add to another query, you merge the queries. Box 2: Disable loading the query to the data model By default, all queries from Query Editor will be loaded into the memory of Power BI Model. You can disable the load for some queries, especially queries that used as intermediate transformation to produce the final query for the model. Disabling Load doesn't mean the query won't be refreshed, it only means the query won't be loaded into the memory. When you click on Refresh model in Power BI, or when a scheduled refresh happens even queries marked as Disable Load will be refreshed, but their data will be used as intermediate source for other queries instead of loading directly into the model. This is a very basic performance tuning tip, but very important when your Power BI model grows bigger and bigger. Reference: https://docs.microsoft.com/en-us/power-query/append-queries https://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up

   Source: Adapted from community discussion — lukelin08

   

   Next question

10. Question 50 · 358 in bank

    DRAG DROP - In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product. Every Product has a ProductSubCategory. Not every ProductsubCategory has a parent ProductCategory. You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query. How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:

    

    This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

    Show the answer figure

    Answer: See figure below

    Explanation

    Box 1: Inner - Every Product has a ProductSubCategory. A standard join is needed. One of the join kinds available in the Merge dialog box in Power Query is an inner join, which brings in only matching rows from both the left and right tables. Box 2: Left outer - Not every ProductsubCategory has a parent ProductCategory. One of the join kinds available in the Merge dialog box in Power Query is a left outer join, which keeps all the rows from the left table and brings in any matching rows from the right table. Reference: https://docs.microsoft.com/en-us/power-query/merge-queries-inner https://docs.microsoft.com/en-us/power-query/merge-queries-left-outer

    Source: Adapted from community discussion — fred92

    

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PL-300 practice, question 41. 358 questions available.