Practice Assessment for Exam PL-300

You need to prevent hidden date tables from being auto generated by Power BI Desktop for every date or datetime data type column in a dataset.

What two tasks should you perform? Each correct answer presents a complete solution

• 
  Enable Mark as date table for the Calendar table.

• From the Current File options in Power BI Desktop, disable Auto Date/Time

• From the Global options in Power BI Desktop, disable Auto Date/Time for new files.

• 
  Set the Data Category to None for all Date and DateTime fields.

You create a data model in Power BI Desktop that contains DAX calculated columns and measures. You now need to create a report.

In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution.

• 
  as a filter in the “Filters on this page” well of the Filters pane

• 
  as a filter in the “Filters on this visual” well of the Filters pane

• 
  as an item in the “Add drill-through fields here” well of the Visualizations pane

• as an item in the Fields well of a slicer

You need to develop a quick measure in Power BI Desktop.

Which two elements can you use? Each correct answer presents a complete solution.

• 
  Calculations

• 
  Conditional columns

• 
  Data Analysis Expression (DAX) queries

• 
  Fields

• 
  Power Query M functions

You are designing a data model for Power BI Desktop.

You need to reduce the model size.

Which technique should you use to reduce the model size?

• 
  Configure the Query reduction option Filters settings.

• 
  Configure the Query reduction option Slicers settings.

• 
  Set the Storage Mode property of tables to Direct Query.

• 
  Set the Storage Mode property of tables to Import.

You decide to remove unnecessary columns from your data model.

What are two potential performance benefits of doing this? Each correct answer presents a complete solution.

• decreasing report page load times

• 
  increasing the refresh speed

• 
  increasing DAX performance

• 
  reducing the size of the data model

You have a Power BI Desktop PBIX file that contains a single page report with multiple visuals.

You plan to use Performance Analyzer to evaluate the performance of the visuals.

You need to eliminate the impact of visual caching during the evaluation.

What should you do first?

• 
  Add a blank page to the PBIX file.

• 
  Connect DAX Studio to the data model.

• 
  Reopen the PBIX file.

• 
  Start recording.

Your company has a SharePoint server located in a datacentre in Montreal.

You plan to create a report in the Power BI service that will use Microsoft Excel files stored on the SharePoint server.

You need to recommend a solution to ensure that the dataset for the report can automatically refresh daily.

What should you include in the recommendation?

• a Point to Site virtual private network (VPN)

• a Site-to-Site virtual private network (VPN)

• 
  an on-premises data gateway

• 
  Azure Data Box

You manage a Power BI workspace.

You need to delegate the task to update workspace metadata. The solution must use the principle of least privilege.

Which role should you use?

Select only one answer.

Admin

• 
  Admin

• 
  Contributor

• 
  Member

• 
  Viewer

You manage a Power BI workspace.

You need to delegate the task to schedule data refreshes. The solution must use the principle of least privilege.

Which role should you use?

• 
  Admin

• 
  Contributor

• 
  Member

• 
  Viewer

You plan to get data from flat files for a Power BI dataset.

You need to select a location to store the files.

Which location requires an on-premises data gateway?

• 
  OneDrive for Business

• 
  Personal OneDrive account

• 
  SharePoint Online Team Sites

• 
  Shared folder on a local network