Microsoft PL-300 Practice Test - Questions Answers, Page 8
List of questions
Question 71
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have the tables shown in the following table.
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required. Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Group the impressions by Ad_id, Site_name, and Impression_date.
Aggregate by using the CountRows function.
Create one-to-many relationships between the tables.
Create a calculated measure that aggregates by using the COUNTROWS function.
Create a calculated table that contains Ad_id, Site_name, and Impression_date.
Explanation:
Grouping in power query reduces the number of rows in the impression table that is gonna be loaded in the model. Creating relationships doesn't increase the size of the model.
Question 72
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?
video
custom streaming data
text box
web content
Explanation:
https://docs.microsoft.com/en-us/stream/portal-embed-video
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#addweb-content
Question 73
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
Show whitespace
Column profile
Column distribution
Column quality
Explanation:
Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table. Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities:
Column quality
Column distribution
Column profile
Reference:
https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/ba-p/674555
Question 74
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have a prospective customer list that contains 1,500 rows of dat a. The list contains the following fields:
First name
Last name
Email address
State/Region
Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign. Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Open the Advanced Editor.
Select Column quality.
Enable Column profiling based on entire dataset.
Select Column distribution.
Select Column profile.
Explanation:
In Power query, the load preview by default is 1000 row. By default, the column quality also only looks at the first 1000 row. You can verify this by the status bar at the bottom of the Power query window. To change the profiling so it analyses the entire column of data, select the profiling status in the status bar. Then select Column profiling based on the entire data set. https://theexcelclub.com/data-profiling-views-in-power-query-excel-and-power-bi/
Question 75
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
Customer ID
Customer Name
Phone
Email Address
Address ID
Address contains the following columns:
Address ID
Address Line 1
Address Line 2
City
State/Region
Country
Postal Code
The Customer ID and Address ID columns represent unique rows.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer. What should you do?
Merge the Customer and Address tables.
Transpose the Customer and Address tables.
Group the Customer and Address tables by the Address ID column.
Append the Customer and Address tables.
Explanation:
There are two primary ways of combining queries: merging and appending.
When you have one or more columns that you’d like to add to another query, you merge the queries.
When you have additional rows of data that you’d like to add to an existing query, you append the query.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Question 76
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have the following three versions of an Azure SQL database:
Test
Production
Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com. Which should you do?
Create a JSON file that contains the database server names. Import the JSON file to the dataset.
Create a parameter and update the queries to use the parameter.
Create a query for each database server and hide the development tables.
Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.
Explanation:
https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/4-development-lifecycle-strategy
Question 77
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the following format:
2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do?
Change the data type of the Logged column to Date.
Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
Apply a transform to extract the first 11 characters of the Logged column.
Question 78
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?
Add a SQL statement.
Set Data Connectivity mode to DirectQuery.
Set the Command timeout in minutes setting.
Set Data Connectivity mode to Import.
Explanation:
With Power BI Desktop, when you connect to your data source, it's always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you’re always viewing current data.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
Question 79
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City.
There is a one-to-many relationship between Date and Orders and between City and Orders.
The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province] = "Kentucky"
Role2 contains the following filter.
Date[Calendar Year] = 2020
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?
The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020.
The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.
The user will see only data for which the State Province value is Kentucky.
The user will receive an error and will not be able to see the data in the report.
Explanation:
When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters.
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance
Question 80
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together. You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source. Which data modeling design should you use?
Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
Duplicate the Date query in Power Query and use active relationships between both Date tables.
On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.
Explanation:
Only one relationship can be active.
Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-managerelationships
Question