Microsoft PL-300 Practice Test - Questions Answers, Page 8

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?

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?

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.

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?

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?

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?

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?

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?

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?