Practice Assessment for Exam PL-300: Microsoft Power BI Data Analyst

Question 1: You need to create a Power BI dashboard. Which tool should you use? Select only one answer.

1. Power BI Desktop
2. Power Query Editor
3. the Power BI mobile app
4. the Power BI service.

Question 2: You are creating a Power BI dashboard. You need to apply a custom theme to the dashboard from another Power BI dashboard theme. Which type of file should you use? Select only one answer.

1. CSV
3. XML
4. YAML

Question 3: You have a Power BI dashboard that is comprised of pinned visuals that are taken from a variety of reports. Which three objects from a report page can be pinned to the dashboard? Select all answers that apply.

1. Custom visual
3. Image
4. Ribbon chart.

Question 4: You plan to create a Power BI workspace. You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint Online document library is available to workspace users once the workspace is created. Which setting should you configure when creating the workspace? Select only one answer.

1. Allow contributors to update the app
2. Develop a template app
3. License mode
4. Workspace OneDrive.

Question 5: You manage a Power BI workspace in shared capacity. The workspace contains a dataset named DS1. You plan to schedule the refresh of DS1. What is the maximum number of data refreshes per day?

1. 1
2. 4
4. 24

Question 6: You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a dataset named DS1. You need to implement an incremental refresh of DS1. What should you do first?

1. In Power BI Desktop, define filter parameters.
2. In Power BI Desktop, define the incremental refresh policy
3. Publish the dataset to the Power BI service
4. Upgrade the Power BI workspace to the Premium SKU

Question 7: 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?

1. Admin
3. Member
4. Viewer

Question 8: You have a Power BI Premium per user workspace. What is the maximum number of refreshes that can be scheduled each day?

1. 1
2. 8
3. 16

Question 9: You plan to create a report in Power BI Desktop. You need to create a visualization that displays data in two or more dimensions and cross-highlights with other visuals on the same report page.Which type of visualization should you use?

1. Card
3. scatter
4. table

Question 10: You plan to create a report in Power BI Desktop. You need to create a visualization to display a running total. The solution must meet the following requirements:

• The initial and the final value columns must start on the horizontal axis.
• The intermediate values must be floating columns.

Which type of visualization should you use?

1. combo
2. funnel
3. scatter

Question 11: You plan to create a report in Power BI Desktop.You need to identify the type of visualization that displays data as a set of nested rectangles. Which visualization should you use?

1. bar chart
2. column chart
3. slicer

Question 12: You plan to create a report in Power BI Desktop that will display sales opportunities by five sales stages, including lead, prospect, qualified, committed, and transacted. You need to identify the type of visualization that will display a linear process with sequentially connected stages, with one stage transitioning to the next. Which visualization should you use?

2. slicer
3. treemap
4. waterfall

Question 13: You need to create a bookmark that toggles the visibility of a visual. This bookmark must only toggle the visibility state and perform no other action. Which three configurations should you make? Each correct answer presents part of the solution. Select all answers that apply.

1. Disable the Data option.
2. Disable the Current Page option.
3. Disable the Display option
4. Enable the Current Page option
5. Enable the Data option
6. Enable the Display option.

Question 14: You need to create a visual that displays sales by employees, trending over months.The visual must clearly show how employees are performing against each other and have a ranking for each period. Which visual should you use? Select only one answer.

1. clustered bar chart
2. ribbon chart.
3. scatterplot
4. treemap

Question 15: From Power BI Desktop, you open a Power BI report that contains three pages named Main, Error Rate, and On-time Rate. You add a button to the Main page for navigation.

You need to implement a solution that meets the following requirements:

• The navigation destination must change based on the output of a DAX measure named [Error Rate].
• If [Error Rate] is greater than 5%, the button must display the text “Error Rate” and navigate to the Error Rate page.
• Otherwise, the button must display the text “On-time Rate” and navigate to the On-Time Rate page.

What three actions should you perform? Each correct answer presents part of the solution.

1. Create a DAX measure that outputs the correct page name based on the value of [Error Rate].
2. Set the button type to Page Navigation and then use conditional formatting to specify the destination.
3. Set the button type to Bookmark and then use conditional formatting to specify the destination.
4. Set the navigation destination to the Error Rate page
5. Use conditional formatting to set the button text.

Question 16: You have a visual that is being cross-highlighted. By default, what data will be displayed in a report tooltip?

1. a report page tooltip with cross-highlighted data
2. both the un-filtered and filtered (cross-highlighted) data
3. the filtered (cross-highlighted) data.
4. the un-filtered (non-cross-highlighted) total data

Question 17: You have a Power BI report that uses a dataset that is imported from a database.You add a slicer to a report. You need to sync the slicer to use it on other report pages. What is required to sync slicers between report pages?

1. Each slicer must be the same slicer type
2. Each slicer must be visible
3. Each slicer must have the same title
4. Each slicer must use the same column.

Question 18: You plan to create a report in Power BI Desktop that will display the relationship between the number of orders and the number of orders shipped by product category. You need to identify the visual that will clearly identify outliers in the data set by displaying them away from the bulk of data. Which visual should you use?

1. card
2. gauge
4. treemap

Question 18: You plan to use Power BI Desktop to analyze sales data of your company. You need to identify two types of data you will be able to use for creating bins that group the sales data.Which two data types should you identify? Each correct answer presents a complete solution. Select all answers that apply.

1. Binary
2. Date/time.
4. Text
5. True/false

Question 19: You need to create a report in Power BI Desktop that will display the sales data of your company such that customers of a similar age will be grouped into clusters.Which visual should you add to the report?

1. card
2. gauge
4. Treemap

Question 20: You need to create a histogram that will display ranges of integers in groups. Which two resources do you need to create the histogram? Each correct answer presents part of the solution. Select all answers that apply.

1. Bin group type.
2. Date/time column
3. List group type
4. Numerical column.

Question 22: You need to create a visual that will display information on a continuous axis. Which two data types can be used to display a continuous axis on a visual? Each correct answer presents a complete solution.

1. Bit
3. Decimal Numbe.
4. Text

Question 23: 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?.

1. OneDrive for Business
2. Personal OneDrive account
3. SharePoint Online Team Sites
4. Shared folder on a local network.

Question 24: You have a Power BI dataset that gets data from a table in a SQL Server database. From which view in Power BI Desktop can you modify the storage mode of the table? Select only one answer.

1. Data view
2. Model view.
3. Page view
4. Report view

Question 25: You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you should use the DirectQuery storage mode or the Import storage mode. What are two benefits of using DirectQuery instead of Import? Each correct answer presents a complete solution.

1. ull support for the Q&A Power BI service
2. full support for the Quick Insights Power BI service
3. minimized local disk space usage.
4. minimized need for data refresh.

Question 26: You have multiple Excel files stored in a folder synced with OneDrive for Business. You need to import data from the files. The solution must NOT use a data gateway. Which type of connector should you use?

1. Excel workbook
2. Folder
3. SharePoint folder.
4. SharePoint list

Question 27: You plan to publish a dataset from Power BI Desktop. You need to ensure that a server name can be changed after the dataset has been published to the Power BI Service. Which two actions should you perform? Each correct answer presents part of the solution. Select all answers that apply.

1. Create a parameter.
2. Create a query for the server name
3. From the Data source settings in Power BI Desktop, update the permissions
4. From the Data source settings, update the server source to use a parameter.
5. Update the Source applied step of all related queries to reference the server name query

Question 28: When importing data from an Excel workbook into Power BI, you receive the error message: “We couldn’t find any data formatted as a table.”What should you do to resolve the error?

1. Select only one answer
2. In the Excel workbook, select the data you want to import, select the Data Validation button, and save the change
3. In the Excel workbook, select the data you want to import, create a table, and save the change.
4. In Power BI, add a template app
5. In Power BI, add an organizational app

Question 29: You create a Power BI data source which uses a SQL SELECT statement. The SQL statement queries multiple tables in a SQL Server database and includes subqueries. After you import data from the data source into Power BI, you notice that one of the columns in the resulting dataset appears blank. You verify that the source table does include data. What should you do to resolve the issue?

1. Clear permissions on the data source in Power BI
2. Use the CAST function in the SQL statement.
3. Use the DATALENGTH function in the SQL statement
4. Set the privacy levels on the data source

Question 30: From Power BI Desktop, you create a data source by importing an Excel file that contains 10,000 rows. You plan to identify data anomalies within the data source. You need to ensure that column distribution considers all rows in the Excel file. What should you do?

1. In the Data Source Settings, modify the Advanced settings
2. In the Data Source Settings, modify the Edit Permissions settings
3. In the Power Query Editor window, enable the Column Profile view.
4. In the Power Query Editor window, modify the Query Settings

Question 31: From Power BI Desktop, you create a data source by importing an Excel file. You plan to identify data anomalies within the data source.Which interface should you use to display the column distribution and column quality graphs?

1. Advanced Editor in Power Query Editor
2. Power Query Editor.
3. the Data view
4. the Model view

Question 32: You have a query that retrieves data from a table that contains more than 8,000 rows of data. In Power Query Editor, you notice that the column statistics for each column shows a count of exactly 1,000. You need to ensure that the column statistics for each column shows the statistics based on all rows that are returned by the query. What should you do?

1. Add a Table.Buffer applied step to the query
2. Change the query load type from Import to DirectQuery
3. Create a Top N row count parameter for the query
4. From the query window, select Column profiling on the entire dataset.

Question 33: You import an Excel file into Power BI Desktop and begin to analyze the data in Power Query Editor. You need to identify outliers in a text column within the data source.Which information should you use from Power Query Editor?Select only one answer.

1. the min and max values in Column profile
2. the top and bottom entries in Value distribution.
3. the value of the Distinct entry in Column statistics
4. the value of the Unique entry in Column statistics

Question 34: You have an Excel spreadsheet that contains three columns labeled Year, 2021, and 2012. The entries in rows for the first column consists of names of the individual months in the year while the other two columns contain the sales amount for each month for the corresponding year. You import data from the Excel spreadsheet into Power BI Desktop. You need to transform the data so it will consist of three columns, with the first one containing month, the second containing year, and the third containing the sales amount for that month and year. Which transformation should you use first?

1. Pivot
2. Remove Columns
3. Transpose Table

Question 35: From Power BI Desktop, you create a data source by importing a Cosmos DB for NoSQL item collection. You connect to the Cosmos DB account, database, and collection, but the preview displays only a list of items named Record. You need to select individual fields from items in the collection that you want to load into Power BI Desktop. What should you do first?

1. Open Power Query Editor.
2. Retrieve the Cosmos DB account key
3. Retrieve the Cosmos DB connection string
4. Switch to the model view

Question 36: You have created a Power BI dataset and need to create multiple reports. What is a benefit of using a Power BI dataset as a data source for multiple reports compared to each report having a separate dataset?

1. It increases the number of scheduled refreshes that can be configured for the Power BI dataset
2. It increases the speed of the reports and visuals connected to the Power BI datasets
3. It prevents sensitive data from being shared with report consumers
4. It reduces the number of datasets, refreshes, and storage requirements in the Power BI service.

Question 37: You have designed a star schema to simplify your data. You need to understand the relationship between the tables in the star schema. What is the relationship between the fact table and dimension tables?

1. many-to-many
2. many-to-one.
3. one-to-many
4. one-to-one

Question 38: You have the following Power Query M formula that generates a range of dates. = List.Dates(#date(2020,05,31), 365, #duration(1,0,0,0)) What is the resulting date range?

1. a list of days ending on May 31, 2020 and starting 365 days earlier
2. a list of days starting on May 31, 2020 and ending 365 days later.
3. a list of months ending in May 2020 and starting 12 months earlier
4. a list of months starting in May 2020 and ending 12 months later

Question 39: You are designing a data model in Power BI. You need to avoid introducing ambiguity into your data model design. Which type of cardinality should you avoid?

1. many-to-many.
2. many-to-one
3. one-to-many
4. one-to-one

Question 40: You have a Power BI model. You need to assign items to a display folder. Which three items can be assigned to a display folder? Each correct answer presents part of the solution. Select all answers that apply.

1. Calculated column.
4. Report
5. Table

Question 41: In Power BI Desktop, you need to create a role. Which two interfaces can you use? Each correct answer presents a complete solution. Select all answers that apply.

1. Data view
2. Model view.
3. Page view
4. Power Query Editor
5. Report view.

Question 42: You need to create a new hierarchy in Power BI Desktop. What should you do first? Select only one answer.

1. From the Model view, drag-and-drop one column onto another column in the Fields pane
2. From the Model view, right-click and select Create hierarchy.
3. From the Report view, drag-and-drop one column onto another column in the Fields pane

Question 43: 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. Select all answers that apply.

1. as a filter in the “Filters on this page” well of the Filters pane.
2. as a filter in the “Filters on this visual” well of the Filters pane
3. as an item in the “Add drill-through fields here” well of the Visualizations pane
4. as an item in the Fields well of a slicer.

Question 44: You need to enhance a data model by using Power BI Desktop. Data for which two model items can be created using the DAX language? Each correct answer presents a complete solution. Select all answers that apply.

1. calculated table.
2. display folder
3. hierarchies
4. numeric range parameter.

Question 45: You need to use DAX quick measures to generate results to use in a report. Which type of DAX quick measure calculations will NOT work against a DirectQuery table? Select only one answer.

1. aggregate per category
2. mathematical operations
3. time intelligence.
4. X-functions

Question 46: You have a Power BI Desktop model. You need to determine when to use implicit and explicit measures. What is a feature of an implicit measure that explicit measure does NOT have? Select only one answer.

1. End-users can change the aggregation type of implicit measure from the Values well of a visual.
2. Implicit measures can be used as a Drillthrough field
3. Implicit measures can be used to create Quick measures
4. Implicit measures can be used with Field Parameters

Question 47: You need to reduce the size of a Power BI model that contains two dimension tables named Date and Location, and one fact table named Temperatures. The Temperatures table contains the following fields:

• Reading Time (datetime)
• DateKey (date)
• LocationKey (whole number)
• Temp C (decimal)

You have one row for every 5-minute interval for each location. The Temperatures table is related to the Date and Location dimensions by using many-to-one relationships.

You need to reduce the cardinality of the table. The solution must ensure that the dataset supports reports that analyze average temperature by hour and location.

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

Select all answers that apply.

1. Create a column that contains the time values for the start of the hour of the Reading Time value.
2. Disable the query load on the Temperatures query in the Power Query Editor
3. Remove the rows that occur exactly at 0 minutes and 0 seconds on the hour
4. Use the Group By functionality to aggregate the rows by hour, DateKey, and LocationKey and then create an average Temp C value per row.
5. Use the Group By functionality to aggregate the rows by DateKey, Reading Time, and LocationKey and then create a max Temp C value per row

Question 48: You plan to optimize the performance of Power BI Desktop queries against a remote data source. You need to disable the default behavior that automatically applies cross highlighting and filtering of visuals within the same report. Which option should you configure in Power BI Desktop? Select only one answer.

1. the Filters Query reduction settings
2. the Persistent filters of Report settings
3. the Reduce number of queries sent by Query reduction setting.
4. the Slicers Query reduction settings

Question 49: 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. Select all answers that apply.

1. decreasing report page load times
2. increasing DAX performance
3. increasing the refresh speed
4. reducing the size of the data model.

Question  50: In Power BI Desktop, you plan to use M-language to define a common date table spanning a period of 10 years. You need identify the M language function that would allow you to specify that rows in the table should represent consecutive days within the date range you designated. Your solution must minimize administrative effort. Which syntax should you use?

1. #date
2. #duration.
3. Combine
4. Durations