Wednesday, February 28, 2024
0 comments

Microsoft Power BI Data Analyst Professional Certificate (PL-300) : Sample Questions (Part-3)

12:09 PM

 



1.

Question 1

For the sales department of your organization, you publish a report that imports data from Microsoft Excel located in a Microsoft SharePoint folder. The data model contains several DAX measures. You must create a Power BI report from the existing data with minimal development efforts. Which type of data source should you use?

1 / 1 point

An Excel workbook

A Power BI dataset

A SharePoint folder

Power BI dataflows

Correct

That’s correct! You must select the SharePoint folder from the Get Data and paste the SharePoint site URL where the data is hosted.

2.

Question 2

You are importing your Power BI project data from a SQL Server database. Which Power BI desktop view can you use to change the storage mode of the tables?

1 / 1 point

Page view

Model view

Report view

Data view

Correct

That’s correct! You need to navigate to the Model view of Power BI desktop and use the Properties pane to change the storage mode of tables.

3.

Question 3

Which tool should you use to create a custom connector to access data from a third-party API?

1 / 1 point

Power BI

Power Automate

Power Apps

Power Query

Correct

That’s correct! You can use Power query to create and manage a custom connector to retrieve data from third-party API.

4.

Question 4

You have a Power BI file that imports several tables from Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the Power BI file. The solution must minimize the administrative efforts. What should you do?

1 / 1 point

Modify the data source settings.

Create a Power BI file, open the file, and change the data source when prompted.

Create new queries from the Power query editor.

Modify the source of each query in the Power query editor.

Correct

That’s correct! You need to modify the data source settings to change the connection before creating reports in Power BI.

5.

Question 5

You have a CSV file that contains user complaints. The table contains a column called Logged, which has data and the time of each complaint. The data is logged in the following format: 2022-12-21 at 08:35. You want to analyze the complaints by the logged date and utilize Power BI’s built-in date hierarchy. What should you do?

1 / 1 point

Apply transformation to extract the column's first characters that only contain the date.

You can use the same column as the date hierarchy.

Change the data type of the logged column to Date.

Split the logged column using ‘at’ as a delimiter.

Correct

That’s correct! Changing the data type of the logged column to Date allows you to utilize a built-in date hierarchy to analyze complaints by time and use drill-down functionality to display granular details.

6.

Question 6

Your data model contains a huge dataset that you want to reduce. Which Power BI interface can you use to reduce the data?

1 / 1 point

Data view of Power BI desktop.

Power query editor.

Data modeler.

Advanced editor.

Correct

That’s correct! In the Power query editor, you can remove unnecessary columns and rows, duplicates, and enact other transformation steps to reduce the size and volume of the dataset before loading it to the Power BI model.

7.

Question 7

You have developed a query named Customers in Power BI desktop to append the rows from three external tables having customer data into a single customer table. You want to ensure each row in the new customer table has a unique ID value. What is the best way to add an ID column to the customer table?

1 / 1 point

Change the data model by extending the Customers table with an index column.

Change the data model by extending the Customers table with a counter column.

Modify the data model by adding a counter column.

Modify the data model by adding an index column.

Correct

You can modify the model by adding an index column from the Power query editor. The index column will assign a unique ID to each customer row.

8.

Question 8

How can you filter rows in Power BI based on specified conditions during data transformation?

1 / 1 point

Use Filter rows and specify the conditions.

Apply the Exclude values transformation.

Utilize the Sort option.

Apply the remove rows transformation operation.

Correct

That’s correct! In the power query editor, you can use Filter rows and define the conditions to filter rows based on your required conditions.

9.

Question 9

You have accessed the data from a SQL Server as DirectQuery. The dataset contains millions of rows. The objective of the analysis is to group data by year and region. Creating aggregated tables has the capacity to reduce the dataset sourced through DirectQuery. Which Power BI element allows you to create aggregations?

1 / 1 point

Page view of Power BI desktop

Data view of Power BI desktop

Model view of Power BI desktop

Power query editor

Correct

That’s correct! You can create aggregated tables from the DirectQuery sourced datasets from the Power Query editor and group by defined columns.

10.

Question 10

You are designing a data model for hospital emergency visits. You want to capture patient information like name, address, insurance details, email, and phone number. Which type of table should you store this information?

1 / 1 point

Fact table

Measure table

Dimension table

Look up table

Correct

That’s correct! The information about the patients is descriptive in nature therefore should be stored in the dimension table that will provide context for the fact table of the data model.

11.

Question 11

Which Power BI interface do you need to use to identify the data anomalies present within your imported dataset from an Excel workbook?

1 / 1 point

Advanced editor of Power query editor.

The Model view of Power BI desktop.

The Data view of Power BI desktop.

The Power query editor

Correct

That’s correct! The Power query editor displays the column distribution and column quality graphs where you can identify any anomaly present within the imported dataset.

12.

Question 12

True or False: In the context of data profiling, Unique values and Distinct values represent the same information.

1 / 1 point

True

False

Correct

That’s correct! Distinct means a total number of different values regardless of how many times they appear in the dataset. A name that appears multiple times in the list is counted as 1 distinct count. Whereas the Unique values are the total number of values that only appear once.

13.

Question 13

You connect the Power query editor to a database table. You need to remove the Row ID column. You need to make sure that the new columns do not display in the table model during a scheduled data refresh in the future. What transformation should you use?

0 / 1 point

Use the Select columns command to select the columns to keep.

Use the Remove Column command on the Row ID column.

Select Row ID and use the Remove Other Columns command.

Use the Transpose command, then filter the rows to remove Row ID.

Incorrect

Not quite. Please review the video Introduction to dataflows.

14.

Question 14

Which statement is true about reference queries in Power BI?

0 / 1 point

Reference queries allow you to integrate data efficiently.

Reference queries enable faster data load.

Reference queries allow you to combine tables with similar structures.

Reference queries allow you to reuse query logic and transformation.

Incorrect

Not quite. Please review the activity Using reference queries.

15.

Question 15

You have a Power BI data model containing two tables Sales and Employees. The tables are related via a one-to-many relationship based on the EmployeeID column. You want to analyze the sales performance for each employee. Which cross-filter direction will you choose?

1 / 1 point

Single

Both

None

Correct

That’s correct! To analyze sales performance for each employee, you need to set a single cross-filter direction which ensures selecting an employee will filter the sales amount for that employee.

16.

Question 16

You have a Power BI data model where the fact table is related to the Calendar table via multiple inactive relationships based on OrderDate, DeliveryDate, and ShipDate. How can you use the inactive relationship while defining DAX measures?

1 / 1 point

Using the KEEPFILTERS function.

Using the USERRELATIONSHIP function.

Managing the relationship from the Manage relationship window

Using the CROSSFILTER function.

Correct

That’s correct! The USERRELATIONSHIP function allows you to utilize the inactive relationship between two tables by overriding the active relationship for the current measure.

17.

Question 17

You want to create a date table starting from May 31, 2021, and ending one year later. What M code will you use to create this table?

1 / 1 point

=List.Dates(#date(2021,05,31), 365, #duration(0,0,0,1))

=List.Dates(#date(2021,05,31), 365, #duration(1,0,0,0))

=List.Dates(#date(2021,05,31), 1, #duration(1,0,0,0))

=List.Dates(#date(2021,05,31), 365, #duration(1,0,1,0))

Correct

That’s correct! The #date designates the starting date, 365 designates the duration and #duration(1,0,0,0) designates the duration interval in days. Therefore, the formula results in listing days starting on May 31, 2021 and ending 365 days later.

18.

Question 18

What is the default summarization of a numerical column in Power BI?

1 / 1 point

SUM

MIN

Count

Average

Correct

That’s correct! Power BI applies SUM summarization by default to each numeric column that you can change according to your analytical needs.

19.

Question 19

Which Power BI component lets you test the row-level security using different security roles?

0 / 1 point

Power BI service.

Both Power BI desktop and Service.

Power BI mobile app.

Power BI desktop.

Incorrect

Not quite. Please review the video Dynamic row-level security with DAX.

20.

Question 20

Which of the following statements about Measures in Power BI is true? Select all that apply.

1 / 1 point

Measures can only be created using DAX in Power BI.

Measures can reference other measures during calculations.

Correct

That’s correct! You can reference previously computed measures to calculate the new measures.

Measures can reference columns directly.

Measures are dynamic calculations that do not take space in the data model

Correct

That’s correct! Unlike Calculated columns, measures do not take up space and compute the value on the fly.

21.

Question 21

You are working on a complex data model that requires various DAX measures to define a range of business metrics. You decided to use variables while creating DAX formulas. What are the benefits of using variables in DAX expressions over using original expressions? Select all that apply.

1 / 1 point

Variables allow users to change the data source connection in the DAX measure.

Variables improve the overall readability of the resulting DAX measure.

Correct

That’s correct! Variable names are often shorter than the original expressions and used multiple times within the same DAX script therefore they improve the readability of the expression.

Variables have additional functions that can be used in the DAX measure.

Variables improve the overall performance of the resulting DAX measure.

Correct

That’s correct! If an expression is used multiple times within the same DAX code, instead of writing it each time, a variable improves the performance by caching the defined calculation.

22.

Question 22

You have a warehouse Power BI data model that contains a table named Warehouse. The table has a column named Inventory count, which contains the current number of items for each row of a particular product type on a given day.

The model has a DAX measure that calculates the sum of all values in the Inventory count column of the Warehouse table:

Current Inventory =

CALCULATE ( SUM ( 'Warehouse'[Inventory Count] ) )

You must ensure that the Current Inventory returns only the current total number of inventory items, rather than the sum of all inventory items. You also need to make sure the state holidays and weekends should be excluded from the calculation. What additional DAX function should you include in the query?

0 / 1 point

DISTINCTCOUNT

LASTNONBLANK

CALENDARAUTO

LASTDATE

Incorrect

Not quite. Please review the activity Create a semi-additive measure.

23.

Question 23

You have a Power BI desktop data mode that you need to enhance. Which model items can you add to the model using DAX? Select all that apply.

1 / 1 point

Measures

Correct

That’s correct! Measures are dynamic calculations that enhance your data model that you can create using DAX.

Hierarchies

Calculated tables

Correct

That’s correct! You can add Calculated tables to your data model using DAX.

Display folder

24.

Question 24

True or False: You cannot create quick measures in Power BI service because only Power BI desktop supports the creation of quick measures.

0 / 1 point

True

False

Incorrect

Not quite. Please review the video Creatingquick measures.

25.

Question 25

You have created a data model in Power BI desktop that contains DAX-calculated columns and measures. You want to create a report from the model.

Where can you use DAX-calculated columns, without being able to use measures? Select all that apply.

1 / 1 point

As a filter in the Filters on this Page well of the Filters pane.

Correct

That’s correct! DAX measures cannot be placed in the Filters on this page well of the report.

As an item in the Fields well of a slicer.

Correct

That’s correct! Unlike measures, calculated columns can be used in the slicer to place filter options on the report page.

As an item in the Add drill-through fields here well of the Visualizationpane.

As a filter in the Filters on this visual well of the Filters pane.

26.

Question 26

You need to create aggregations to improve model performance of a DirectQuery sourced dataset in Power BI. Which Power BI component allows you to create aggregations?

1 / 1 point

Power BI desktop model view

Power BI desktop table view

Power query editor

Power BI desktop report view

Correct

That’s correct! You can only create aggregations in the Power Query editor from a DirectQuery sourced dataset. Remember you need to manage the aggregations after you create them. You can manage aggregations in Power BI desktop model view.

27.

Question 27

You are working on an on-premises SQL Server dataset to develop a real-time analytical solution. In addition to providing real-time analysis, you need to optimize the query performance. What actions should you take to optimize the query performance? Select all that apply.

0 / 1 point

Connect Power BI via DirectQuery mode.

Reduce the data volume by importing only necessary columns.

Correct

That’s correct! Reducing the data by importing only the columns needed for analysis will reduce the model size thereby improving the query performance.

Create aggregations based on DirectQuerysourced tables.

Correct

That’s correct! Aggregations on the DirectQuerysourced tables improve the performance and efficiency of query.

Import the data to Power BI memory.

Query the original data source for all analytical requirements

You didn't select all the correct answers

28.

Question 28

Which of the following Data types offers an optimal performance for the currency field of your data model?

1 / 1 point

Decimal number

Fixed decimal number

Text

Whole number

Correct

That’s correct! In the performance analyzer, you can inspect the execution time of each DAX measure which helps you to identify the slow performing measures and optimize them.

29.

Question 29

You need to visualize the running total of a company by fulfilling the following criteria.

·        The initial and final value columns must start on the horizontal axis.

·        The intermediate values must be floating columns.

Which type of visualization should you choose?

1 / 1 point

Scatter plot

Funnel chart

Combo chart

Waterfall chart

Correct

That’s correct! A Waterfall visualization is a chart that displays the running total, with the initial and final value columns starting on the horizontal axis and the intermediate values are floating columns.

30.

Question 30

You need to create a custom visual using Python from Power BI desktop. What do you need to do first?

1 / 1 point

Configure the global Python scripting option in Power BI desktop.

Enable preview features in Power BI desktop.

Install Python on your computer

Enable the script visuals options in the Visualizations pane of Power BI desktop.

Correct

That’s correct! To enable custom Python visuals using Power BI desktop, you first need to install Python and its libraries on your computer. Configuring global scripting and enabling script visuals might be required after you install Python.

31.

Question 31

You have developed a CustomTheme in Power BI desktop and created reports based on this theme. When you publish your reports to Power BI service and create dashboards out of the reports, will Power BI service alter the theme and adapt your reports to the dashboard default theme?

1 / 1 point

True

False

Correct

That’s correct! You can keep the original theme of your reports and its visual elements while publishing and creating dashboards in Power BI service.

32.

Question 32

You have a Power BI report that uses a dataset imported from the database. The report contains a Slicer that you need to sync so that it can be used on other report pages. What is required to sync the slicers between report pages?

1 / 1 point

Each Slicer must have the same title.

Each Slicer must be visible.

Each Slicer must be the same slicer type.

Each Slicer must use the same column

Correct

That’s correct! The same column must be used to create a Slicer for them to recognize each other in sync slicer settings.

33.

Question 33

Power BI desktop supports many accessibility tools. Which keyboard keys let you access the accessibility features?

1 / 1 point

Alt

Alt + A

Tab

Tab + A

Correct

That’s correct! The Alt key displays the Keytips over each command in the current view of the Ribbon with a letter displayed on each tab which lets you navigate various tools via accessibility.

34.

Question 34

True or False: Power BI allows you to add visual elements and images to your report tooltip.

1 / 1 point

True

False

Correct

That’s correct! Your report tooltip can contain visuals, images, and any other collection of items you create on the report page.

35.

Question 35

Your task is to edit a Power BI report by adjusting the behavior of report interactions. What type of interaction behavior can you change between visuals? Select all that apply.

1 / 1 point

Highlight

Correct

That’s correct! Highlight is the default interaction between the visual which shows you both unfiltered and filtered values in the visual.

Expand

Filter

Correct

That’s correct! A Filter changes the behavior by showing you the filtered data in the visual.

Drill through

36.

Question 36

You are working on a Power BI report that contains multiple Slicers. A new user of the report might not be able to visualize the entire data because of the active selection of Slicers. What should you do to enhance the user experience?

1 / 1 point

Add a Bookmark

Duplicate the report page and remove the Slicers from the duplicated page

Add a Button to clear all the Slicers

Correct

That’s correct! You can add a Button to the report page to clear all Slicers from the report which will enhance the user experience.

37.

Question 37

You have a Power BI dataset where each employee is reporting to multiple managers in the organizational hierarchy. How does a PATH function of DAX handle such a situation?

0 / 1 point

The PATH function cannot handle multiple reporting relationships.

It chooses the shortest path for each employee.

It creates a separate path for each employee-manager relationship.

It concatenates all paths for each manager.

Incorrect

Not quite. Please review the reading Path Dax functions.

38.

Question 38

How can you group layers of visual elements in your Power BI desktop report? Select all that apply.

1 / 1 point

Select all visuals to be grouped, right-click on any visual, and select Group from the context menu.

Correct

That’s correct! You need to select multiple visuals to be grouped by holding the Ctrl key and selecting Group from the context menu.

Select all visuals to be grouped, navigate to the Format ribbon, and select Group.

Correct

That’s correct! You can also navigate to the Format ribbon and select Groupafter selecting the multiple visuals from the report canvas.

Right-click on any visual and select Group from the context menu

Drag and drop the visual elements.

39.

Question 39

You have a Power BI report displaying a Column chart of Sales on the Y-axis and Countries on the X-axis. When users hover the cursor on any data point the tooltip displays the sales values along with the name of the country. How can you display the sales breakdown by each category within the same country?

0 / 1 point

Add a Category slicer where users can select a category.

Add a visual for sales breakdown by category on a Tooltip.

Add a separate visual displaying sales breakdown by product category.

Create a separate report page for each product category.

Incorrect

Not quite. Please review the reading Activity: Create custom tooltips.

40.

Question 40

In Power BI you can add symmetry shading along with x- and y-axis Constant lines to which of the following visuals?

1 / 1 point

Waterfall chart

Line chart

Scatter chart

Area chart

Correct

That’s correct! You can add Constant x and y-axis lines with symmetry shading only in the Scatter chart in Power BI.

41.

Question 41

True or False: In Power BI desktop, you can convert a Q&A visual to a fully formatted visual element to display on your report canvas.

1 / 1 point

True

False

Correct

That’s correct! You can also define relationships between tables and fields to help Q&A understand questions about your data.

42.

Question 42

Anomaly detection is a powerful feature of Power BI where you can detect anomalies within your time series data. Which of the following features are not supported by anomaly detection? Select all that apply.

0 / 1 point

You cannot use drill down with anomaly detection.

Correct

That’s correct! Drilling down to the granular level of details with a hierarchical structure is also not supported in anomaly detection.

Line charts are not supported.

DirectQuery connectivity is not supported.

Live connection to the dataset is not supported.

Correct

That’s correct! Power BI’s anomaly detection feature does not support Live connection to the dataset.

You didn't select all the correct answers

43.

Question 43

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?

0 / 1 point

Member

Admin

Viewer

Contributor

Incorrect

Not quite. Please review the video Workspaces and workspace roles.

44.

Question 44

You are creating a workspace in Power BI service. You must ensure you can configure a Microsoft 365 group whose SharePoint online document library is available to workspace users after it is created. Which setting should you configure when creating a workspace?

1 / 1 point

License mode

Allow contributors to update the app

Workspace OneDrive

Develop a template app

Correct

That’s correct! Workspace OneDrive settings allow you to configure the Microsoft 365 group whose SharePoint Online document library is available to workspace users once you have created the workspace.

45.

Question 45

You want to create Alerts to notify users if the data on the dashboard changes above or below a certain threshold. Which Power BI visual allows you to set and manage Alerts in Power BI service? Select all that apply:

0 / 1 point

Card visual

Python visual

KPI

Correct

That’s correct! Power BI service also allows you to set and manage Alerts in KPI, a visual used to track performance against a predefined target.

Gauge

Correct

That’s correct! You can set up and manage Alerts in the Gauge visual, within the Power BI service.

Custom visuals

You didn't select all the correct answers

46.

Question 46

True or False: You can only subscribe to external users to a Power BI report or dashboard if your report or dashboard is hosted in a Premium capacity.

0 / 1 point

True

False

Incorrect

Not quite. Please review the video Subscriptions and data alerts.

47.

Question 47

What is the primary advantage of deployment pipelines in Power BI?

1 / 1 point

Enhanced user access to BI report source data.

Less manual work and fewer errors.

Reports can be published from multiple workspace environments.

Semantic model (dataset) creation is streamlined.

Correct

That’s correct! Implementation of deployment pipelines reduces manual work and errors.

48.

Question 48

Your company has a SharePoint server located in a data center in Toronto. You are creating a report in Power BI service that uses 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?

1 / 1 point

Azure Data box

A virtual private network (VPN)

An on-premises data gateway

Correct

That’s correct! With an on-premises data gateway installed on your local machine, you can achieve daily refresh of the data regardless of where the data is hosted.

49.

Question 49

Which Power BI refresh options require you to set parameters?

1 / 1 point

Scheduled refresh

On-demand refresh

Incremental refresh

Correct

That’s correct! In incremental refresh you need to ensure the dataset is partially refreshed according to the parameters you must define.

50.

Question 50

You are applying sensitivity labels to your Power BI reports, which of the following are sensitivity labels in Power BI? Select all that apply.

0 / 1 point

Highly confidential

Confidential

Correct

That’s correct! Confidential is a sensitivity label used for Power BI reports.

Certified

Personal

You didn't select all the correct answers


0 comments:

 
Toggle Footer