Microsoft Power BI Data Analyst (PL-300) Certification Sample Questions

Power BI Data Analyst Dumps, PL-300 Dumps, PL-300 PDF, Power BI Data Analyst VCE, Microsoft PL-300 VCE, Microsoft MCA Data Analyst PDF The purpose of this Sample Question Set is to provide you with information about the Microsoft Power BI Data Analyst exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the PL-300 certification test. To get familiar with real exam environment, we suggest you try our Sample Microsoft Power BI Data Analyst Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual Microsoft Certified - Power BI Data Analyst Associate certification exam.

These sample questions are simple and basic questions that represent likeness to the real Microsoft PL-300 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium Microsoft Power BI Data Analyst Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.

Microsoft PL-300 Sample Questions:

01. You have a fact table that contains sales data and the following two date columns: OrderDate and ShipDate. Both columns have a relationship to the Date column in the Calendar table, and DAX measures have been configured to use these relationships for calculations related to order or ship dates.

You need to ensure that by default, the Calendar table does NOT filter the fact table, unless it is using a DAX measure that uses these relationships. What should you do?

a) Set the cross-filter direction to both for each relationship.

b) Enable Make this relationship active for both relationships.

c) Disable Make this relationship active for both relationships.

d) Enable Apply security filter in both directions for both relationships.

02. 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. Select all answers that apply.

a) minimized need for data refresh

b) minimized local disk space usage

c) full support for the Q&A Power BI service

d) full support for the Quick Insights Power BI service

03. You are modifying a report in Power BI Desktop. The report contains a single report page that has three card visuals and one clustered bar chart. You need to create a bookmark that displays only the clustered bar chart and hides the cards. The solution must minimize development effort. What should you do first?

a) Publish the report to the Power BI Service.

b) Select the Spotlight option on the clustered bar chart.

c) Add a bookmark in the Bookmarks Pane.

d) Hide the three cards in the Selection Pane.

04. 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. Select all answers that apply.

a) Binary

b) Date

c) Decimal Number

d) Text

05. 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?

a) Open Power Query Editor.

b) Retrieve the Cosmos DB account key.

c) Switch to the model view.

d) Retrieve the Cosmos DB connection string.

06. You manage a Power BI workspace in a shared capacity. The workspace contains a dataset named DS1. You plan to schedule a refresh of DS1. What is the number of consecutive refresh failures of DS1 that will automatically disable the refresh schedule?

a) 16

b) 4

c) 2

d) 64

07. You decide to start using variables when creating DAX formulas. What are two benefits of using variables in DAX measures over using original expressions?

Each correct answer presents a complete solution. Select all answers that apply.

a) has additional functions that can be used in the DAX measure

b) allows users to change the data source connection in the DAX measure

c) improves the overall readability of the resulting DAX measure

d) improves the overall performance of the resulting DAX measure

08. 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?

a) a list of days ending on May 31, 2020 and starting 365 days earlier

b) a list of days starting on May 31, 2020 and ending 365 days later

c) a list of months ending in May 2020 and starting 12 months earlier

d) a list of months starting in May 2020 and ending 12 months later

09. You upload reports to the Power BI service and pin several visuals to a dashboard. You plan to create alerts rules for several visuals. What are two locations you can view the alerts?

Each correct answer presents a complete solution. Select all answers that apply.

a) an email

b) a report

c) Microsoft Teams

d) the Notification Center

10. You have a fact table that contains sales data. The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options. You load the fact table into Power BI Desktop.

You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Your solution must minimize the model size and administrative effort. What should you do?

a) Enable the Auto date/time global option.

b) Add a year, month, and week columns to the fact table.

c) Add a separate date dimension table.

d) Enable the Auto date/time current file option.

Answers:

Question: 01 Answer: c	Question: 02 Answer: a, b	Question: 03 Answer: d	Question: 04 Answer: b, c	Question: 05 Answer: a
Question: 06 Answer: b	Question: 07 Answer: c, d	Question: 08 Answer: b	Question: 09 Answer: a, d	Question: 10 Answer: c

Note: For any error in Microsoft Certified - Power BI Data Analyst Associate (PL-300) certification exam sample questions, please update us by writing an email on feedback@edusum.com.