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 IDAddress contains the following columns:• Address ID• Address Line 1• Address Line 2• City• State/Region• Country• Postal CodeEach Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. 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.

Append the Customer and Address tables.

Transpose the Customer and Address tables.

Group the Customer and Address tables by the Address ID column.

Merge the Customer and Address tables.

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 m 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?

Create a column by example that starts with 2018-12-31.

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date

Apply the parse function from the Date transformations options to the Logged column.

Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.

You have a Power Bl report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables. There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns.The report contains the visuals shown in the following table. The dataset takes a long time to refresh.You need to modify Posts and Traffic queries to reduce toad times.Which two actions will reduce the toad times? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Remove Posts [Full Text] and Posts [Summary].

Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''

Remove the rows m Traffic in which Traffic [Referring URL] does not start with "/"

Remove the rows in Posts m which Post [Publish Date] is in the last seven days.

Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).

Remove Posts [Full Text] and Posts [Summary].

Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''

You have a Power Bi report for the procurement department. The report contains data from the following tables. There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table. You need to minimize the size of the dataset without affecting the visuals. What should you do?

Remove the Lineitems[Description] column.

Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month

Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).

Remove the Lineitems[Description] column.

You have a Power Bl query named Sates that imports the columns shown in the following table. Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis.Which two actions achieve this goal? Each correct answer presents a complete solution.NOTL Each correct selection is worth one pant.

Remove the rows in which sales [status] has a value of Canceled.

Split Sales [Sale_Date] into separate date and time columns.

Remove the rows in which sales [status] has a value of Canceled.

Change the data type of sale [Delivery_Time] to Integer

Split Sales [Sale_Date] into separate date and time columns.

You are creating a Power BI model that contains a table named Store. Store contains the following fields. You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City. What should you do to ensure that the locations are mapped property?

Set the data category of City. State/Province, and Country.

Set Summarization for City. State/Province, and Country to Don't summarize

Change the data type of City. State/Province, and Country.

Create a calculated column that concatenates the values it City, State/Province, and Country.

You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table: The report will facilitate the following analysis:• The count of orders and the sum of total sales by Order Date• The count of customers who placed an order• The average quantity per orderYou need to reduce data refresh times and report query times.Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.

Fillet the data to only the NorthWest region sales territory.

Remove the TaxAmt and Freight columns.

Fillet the data to only the NorthWest region sales territory.

Remove the CustomerKey and ProductKey columns.

Remove the TaxAmt and Freight columns.

Set the data type for SatesOrderNumber to Decimal Number

From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do?

From powerbi.com.add users to the HR role for the dataset.

From Power Bl Desktop, change the Row-Level Security settings.

From Power Bl Desktop, import a table that contains the HR team members

From powerbi.com.add users to the HR role for the dataset.

From powerbi.com. share the dataset to the HR team members.

You are building a Power Bl report that uses data from an Azure SQL database named erp1.You Import the following tables. You need to perform the following analyses:• Orders sold over time that include a measure of the total order value• Orders by attributes of products soldThe solution must minimize update times when interacting with visuals in the report. What should you do first?

From Power Query, merge the Order Line Items query and the Products query.

From Power Query, merge the Orders query and the Order Line Hems query.

Calculate the count of orders per product by using a DAX function.

Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.

From Power Query, merge the Order Line Items query and the Products query.

You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month.You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do?

Create a separate report page for users to view the column chart.

Add a column chart, a bookmark, and a button for users to choose a visual.

Create a mobile report that contains a column chart.

Create a separate report page for users to view the column chart.

Enable report readers to personalize visuals.

You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette.You are creating a Power Bl dashboard that will include two visuals from each report You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports. Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Select the dark dashboard theme.

When pinning visuals to the dashboard, select Use destination theme.

Select the dark dashboard theme.

When pinning visuals to the dashboard, select Use destination theme.

For the browser, set the color preference to dark mode.

You have a Power Bl workspace that contains several reports.You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do?

Add the user as a Viewer of the workspace.

Grant the Read permission for the datasets to the user.

Add the user as a Viewer of the workspace.

Share the reports with the user.

Create a row-level security (RLS) role and add the user to the role.

Add the user as a member of the workspace.

You have a report in Power Bl named report1 that is based on a shared dataset.You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected. What should you do?

Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.

Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset.

Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report.

Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.

Apply row-level security (RLS) to the shared dataset.

You have the Power Bl model shown in the following exhibit. There are four departments in the Departments table.You need to ensure that users can see the data of their respective department only.What should you do?

Create a row-level security (RLS) role for each department, and then define the membership of the role.

Create a DepartmentID parameter to filter the Departments table.

To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.

Create a slicer that filters Departments based on DepartmentID.

You import a Power Bl dataset that contains the following tables:• Date• Product• Product InventoryThe Product inventory table contains 25 million rows. A sample of the data is shown in the following table. The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?

Change Summarization for DateKey to Don't Summarize.

Change the data type of UnitCost to Integer.

Remove the relationship between Date and Product Inventory.

You have more than 100 published datasets.Ten of the datasets were verified to meet your corporate quality standards.You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets. What should you do?

Publish the datasets in an app.

Feature the dataset on the home page.

You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1. A user wants to create a report by using the data In DS1 and publish the report to another workspace. You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user. What should you do?

Grant the Build permission for DS1 to the user.

Add the user as a Viewer of Workspace1.

Add the user as a member of Workspace1.

Grant the Build permission for DS1 to the user.

You have a Power Bl report that uses row-level security (RLS).You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards. What should you do?

Instruct the Azure network security team to create security groups. Configure RLS to use the groups.

Add the Azure network security team as members of the RLS role.

Instruct the Azure network security team to create security groups. Configure RLS to use the groups.

Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.

Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team.

Microsoft PL-300 Practice Test 6 - Free Online Exam Prep & Questions

For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder The data model contains several measures You need to create a Power Bl report from the existing dat a. The solution must minimize development effort. Which type ol data source should you use?

Become a Premium Member for full access

Unlock Premium Member

Microsoft PL-300 Practice Test 6

Question

Microsoft PL-300 Practice Tests

Practice Tests