Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 381:

  HOTSPOT

  You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.)

  

  The data has the following refresh requirements:

  1. Customer must be refreshed daily.

  2. Date must be refreshed once every three years.

  3. Sales must be refreshed in near real time.

  4. SalesAggregate must be refreshed once per week.

  You need to select the storage modes for the tables. The solution must meet the following requirements:

  1. Minimize the load times of visuals.

  2. 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.

  

  

  ---

  Box 1: Dual

  Customer should use the dual storage mode.

  Dual: Tables with this setting can act as either cached or not cached, depending on the context of the query that's submitted to the Power BI dataset. In some cases, you fulfill queries from cached data. In other cases, you fulfill queries by executing an on-demand query to the data source.

  Note: You set the Storage mode property to one of these three values: Import, DirectQuery, and Dual.

  Box 2: Dual

  You can set the dimension tables (Customer, Geography, and Date) to Dual to reduce the number of limited relationships in the dataset, and improve performance.

  Box 3: DirectQuery

  Sales should use the DirectQuery storage mode.

  DirectQuery: Tables with this setting aren't cached. Queries that you submit to the Power BI dataset"for example, DAX queries"and that return data from DirectQuery tables can be fulfilled only by executing on-demand queries to the data source. Queries that you submit to the data source use the query language for that data source, for example, SQL.

  Box 4: Import

  Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that return data from Import tables can be fulfilled only from cached data.

  https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode

• Question 382:

  You are creating a Power Bi report that will contain multiple visuals.

  You need to ensure that the report Is accessible to users who use a screen reader.

  Which two configurations should you perform? Each correct answer presents part of the solution?

  NOTE: Each correct selection is worth one point.

  A. alt text for each visual
  B. consistent fonts for each visual
  C. consistent colors for each visual
  D. the tab order for each page
  E. Play Axis for each page
  A. alt text for each visual
  D. the tab order for each page

• Question 383:

  You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

  The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

  The report is a single page that contains 15 custom visuals and 10 default visuals.

  Users say that the report is slow to load the visuals when they access and interact with the report.

  You need to recommend a solution to improve the performance of the report.

  What should you recommend?

  A. Split the visuals onto multiple pages.
  B. Implement row-level security (RLS).
  C. Replace the default visuals with custom visuals.
  D. Increase the number of times that the dataset is refreshed.
  A. Split the visuals onto multiple pages.

• Question 384:

  DRAG DROP

  You are modifying a Power Bi model by using Power Bl Desktop.

  You have a table named Sales that contains the following fields.

  

  You have a table named Transaction Size that contains the following data.

  

  You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.

  How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value 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:

  

  

• Question 385:

  You have a Power Bl semantic model that contains two queries.

  You discover that a report based on the model has performance issues.

  You plan to use Power Query to reduce the data loaded to the model.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct answer is worth one point.

  A. Apply group by and summarize techniques.
  B. Combine the queries by using Append.
  C. Remove unnecessary columns and rows.
  D. Combine the queries by using Merge.
  E. Create a new query group.
  A. Apply group by and summarize techniques.
  C. Remove unnecessary columns and rows.

• Question 386:

  HOTSPOT

  You have a dataset that has the permissions 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.

  

  

• Question 387:

  You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:

  

  

  The report will facilitate the following analysis:

  1. The count of orders and the sum of total sales by Order Date

  2. The count of customers who placed an order

  3. The average quantity per order

  You need to reduce data refresh times and report query times.

  Which two actions should you perform? Each correct answer presents part of the solution

  NOTE: Each correct selection is worth one point.

  A. Set the data type for SalesOrderNumber to Decimal Number.
  B. Remove the CustomerKey and ProductKey columns.
  C. Remove the TaxAmt and Freight columns.
  D. Filter the data to only the NorthWest region sales territory.
  C. Remove the TaxAmt and Freight columns.
  D. Filter the data to only the NorthWest region sales territory.

  ---

  Explanation

  C: Remove columns that are not used in the report.

  D: Reduce the number of rows.

  Incorrect:

  Not A: Not possible.

  Not B: Need CustomerKey to count of customers who placed an order

• Question 388:

  You need to create the required relationship for the executive's visual.

  What should you do before you can create the relationship?

  A. Change the data type of Sales[region_id] to Whole Number.
  B. In the Sales table, add a measure for sum(sales_amount).
  C. Change the data type of sales[sales_id] to Text.
  D. Change the data type of sales [region_id] to Decimal Number.
  A. Change the data type of Sales[region_id] to Whole Number.

• Question 389:

  HOTSPOT

  You have a folder of monthly transaction extracts.

  You plan to create a report to analyze the transaction data.

  You receive the following email message: "Hi, I've put 24 files of monthly transaction data onto the shared drive. File Transactions201801.csv through Transaction201812.csv have four columns while files Transactions201901.csv through Transaction201912.csv have the same four columns plus an additional three columns. Each file contains 10 to 50 transactions."

  You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

  

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: Yes

  The four columns used in the 2018 transactions are already displayed.

  Box 2: Yes

  The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected.

  Box 3: Yes

  Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manually change the delimiter, or define how Power BI should handle data types. You can set it to automatically detect data types based on first 200 rows, or the entire dataset or you can even opt out the detection of data types.

• Question 390:

  You have a report in Power Bl named report1 that is based on a shared dataset.

  You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected.

  What should you do?

  A. Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset.
  B. Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report.
  C. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.
  D. Apply row-level security (RLS) to the shared dataset.
  C. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.