Power BI Pl300 Certification Test | Complete Questions & Answers (100% Correct)

Power BI Pl300 Certification Test | Complete Questions & Answers (100% Correct) Power BI Pl300 Certification Test | Complete Questions & Answers (100% Correct) You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements: Customer must be refreshed daily. Date must be refreshed once every three years. Sales must be refreshed in near real time . SalesAggregate must be refreshed once per week. You need to select the storage modes for the tables. The solution must meet the following requirements: Minimize the load times of visuals. Ensure that the data is loaded to the model based on the refresh requirements. Which storage mode should you select for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Customer: Direct Query, Dual, Import Date: DirectQuery, Dual, Import Sales: DirectQuery, Dual, Import SalesAggregate: DirectQuery, Dual, Import - ANSWER - Customer: Dual Date: Dual Sales: DirectQuery SalesAggregate: Import You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.You need to create a Power BI report that connects to the project management app.Which connector should you select? A. Microsoft Teams Personal Analytics B. SQL Server database C. Dataverse D. Dataflows - ANSWER - C. Dataverse For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.The data model contains several measures.You need to create a Power BI report from the existing data. The solution must minimize development effort.Which type of data source should you use? A. Power BI dataset B. a SharePoint folder C. Power BI dataflows D. an Excel workbook - ANSWER - A. Power BI dataset You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns: Customer ID Customer Name Phone Email Address Address ID Address contains the following columns: Address ID Address Line 1 Address Line 2 City State/Region Country Postal Code Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table.You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer. What should you do? A. Merge the Customer and Address tables. B. Group the Customer and Address tables by the Address ID column. C. Transpose the Customer and Address tables. D. Append the Customer and Address tables. - ANSWER - A. Merge the Customer and Address tables. 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 . What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Option to use to combine the Customer tables: Append queries, Append queries as new, Merge queries, Merge queries as new Action to perform on the original two SQL database queries: Delete the queries, Disable including the query in the report refresh, Disable loading the query to the data model, Duplicate the queries - ANSWER - Option to use to combine the Customer tables: Append queries as new Action to perform on the original two SQL database queries: Disable loading the query to the data model 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: JOIN KINDS: Full outer Inner Left anti Left outer Right anti Right outer - ANSWER - Product - Product Subcategory : Inner ProductSubCategory - ProductCategory : Left outer