Microsoft PL-300 Practice Test - Questions Answers, Page 28
Question list
List of questions
Related questions
DRAG DROP
In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product. Every Product has a ProductSubCategory.
Not every ProductsubCategory has a parent ProductCategory.
You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query. How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
DRAG DROP
You receive annual sales data that must be included in Power Bl reports.
From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.
You need to create a report that meets the following requirements:
• Visualizes the Sales value over a period of years and months
• Adds a slicer for the month
• Adds a slicer for the year
The table has the following columns.
You need to add a column that will be used to sort the Year Month column chronologically.
DRAG DROP
You publish a dataset lhat contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct
DRAG DROP
You create a data model in Power BI.
Report developers and users provide feedback that the data model is too complex.
The model contains the following tables.
The model has the following relationships:
*There is a one-to-one relationship between Sales_Region and Region_Manager.
*There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager. *There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager. You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
HOTSPOT
You need to create a Power BI report. The first page of the report must contain the following two views:
*Sales By Postal Code
*Sales by Month
Both views must display a slicer to select a value for a field named Chain.
The Sales By Postal Code view must display a map visual as shown in the following exhibit.
The Sales By Month view must display a column chart visual as shown in the following exhibit.
Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views. What is the minimum number of bookmarks required, and which property should you apply to each bookmark? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
A manager can represent only a single country.
You need to use row-level security (RLS) to meet the following requirements:
The managers must only see the data of their respective country.
The number of RLS roles must be minimized.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.
For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
Create one role for each country.
For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.
You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model. What should you do?
In the report, add a DAX calculated column that calculates the length of col1
In the report, add a DAX function that calculates the average length of col1
From Power Query Editor, add a column that calculates the length of col1
From Power Query Editor, change the distribution for the Column profile to group by length for col1
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint 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. What should you do?
Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
Change the data type of the Logged column to Date.
Split the Logged column by using at as the delimiter.
Apply a transformation to extract the first 11 characters of the Logged column.
What should you do to address the existing environment data concerns?
a calculated column that uses the following formula: ABS(Sales[sales_amount])
a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])
a measure that uses the following formula: SUM(Sales[sales_amount])
a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))
Question