Microsoft PL-300 Practice Test - Questions Answers, Page 26
Question list
List of questions
Related questions
You have a Power BI report that contains four pages.
All the pages contain a slicer for a field named Country,
You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages, What should you do?
Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.
Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.
Sync the Country slicer on page 1, page 2, and page 3.
Move the Country slicer from page 2 and page 3 to page 1.
You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR. You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:
• Create reports that use the HR dataset.
• Publish the reports to WorkspaceB.
• Prevent the ability to modify the HR dataset.
• Prevent the ability to add users to WorkspaceB.
The Sales table contains records of sales by day from the last five years up until today's date.
You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.
Which DAX expression should you use?
Option A
Option B
option C
Option D
You have a Power BI data model that contains a table named Stores. The table has the following columns:
* Store Name
* Open Date
* Status
* State
* City
You need to create a calculated column named Active Store Name that meets the following requirements:
You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do?
From Power Bl Desktop, customize the current theme,
From power Bl Desktop, use a built in report theme.
Create a theme as a JSON file and import the theme into Power Bl Desktop.
Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop.
DRAG DROP
You use Power Bi Desktop to create a Power Bl data model and a blank report You need to add the Word Cloud visual shown in the following exhibit to the report.
The solution must minimize development effort
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.
HOTSPOT
You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic NOTE: Each correct solution is worth one point
DRAG DROP
You have a Power BI data model that contains two tables named Products and Sales.
A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total. How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content NOTE:
Each correct selection is worth one point
DRAG DROP
Exhibit:
You need to create a report that meets the requirements:
• Visualizes the Sales value over a period of years and months
• Adds a Slicer for the month
• Adds a Slicer for the year
Which three actions Should you perform in sequence?
HOTSPOT
The data model must support the following analysis:
Total sales by product by month in which the order was placed
Quantities sold by product by day on which the order was placed
Number Of sales transactions by quarter in Which the order was placed For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.
Question