You have the visual shown in the exhibit. (Click the Exhibit tab.) You need to show the relationship between Total Cost and Total Sales over time.What should you do?

From the Analytics pane, add an Average line.

Create a DAX measure that calculates year-over-year growth.

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

Line and clustered column chart

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.What should you recommend?

Merge tables by using Power Query.

Hide unused columns in the model.

Split the model into multiple models.

You have a sales system that contains the tables shown in the following table. The Date table is marked as a date table.DatelD is the date data type. You need to create an annual sales growth percentage measure.Which DAX expression should you use?

(SUM(‘Sales’[sales_amount]) - CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))) / CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),SAMEPERIODLASTYEAR('Date'[DateID])

(SUM(‘Sales’[sales_amount]) - CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))) / CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DateID]))

CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables.Which relationship should you use to link the tables?

one-to-many from Customer to Transaction

one-to-one between Customer and Transaction

one-to-many from Transaction to Customer

many-to-many between Customer and Transaction

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure. Customer Count = DISTINCTCOUNT(Customer[CustomerID])Users frequently refer to customers as subscribers.You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model. What should you do?

Set Summarize By to None for the CustomerlD column.

Add a description of "subscriber count" to the Customer Count measure.

Set Summarize By to None for the CustomerlD column.

Add a description of "Subscriber" to the Customer table.

Add a synonym of "subscriber" to the Customer table.

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 custom visuals and 10 default visuals.Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance of the report. What should you recommend?

Split the visuals onto multiple pages.

Implement row-level security (RLS).

Replace the default visuals with custom visuals.

Increase the number of times that the dataset is refreshed.

You have four sales regions. Each region has multiple sales managers.You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role. You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions. A sales manager changes to a different region.You need to ensure that the sales manager can see the correct sales data.What should you do?

Request that the sales manager be added to the correct Azure Active Directory group.

From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.

Change the Microsoft Power Bl license type of the sales manager.

Manage the permissions of the underlying dataset

Request that the sales manager be added to the correct Azure Active Directory group.

You have five sales regions. Each region is assigned a single salesperson.You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson. Salespeople must see only the data from their region.You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople. A salesperson reports that she believes she should see more data.You need to verify what data the salesperson currently sees.What should you do?

Use the Test as role option to view data as the salesperson's user account.

Use the Test as role option to view data as the Sales role.

Instruct the salesperson to open the report in Microsoft Power Bl Desktop.

Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

Publish the reports in an app and grant the HR managers access permission.

Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.

Publish the reports to a different workspace other than the one hosting the datasets.

Publish the reports in an app and grant the HR managers access permission.

Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl. You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access and prevent end users from viewing the development assets. What should you recommend?

Create separate workspaces for development and production. Grant the end users access to the production workspace.

Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.

In the same workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.

Create separate workspaces for development and production. Grant the end users access to the production workspace.

Create one workspace for development. From the workspace, publish an app for production.

You are creating a visual to show the ranking of product categories by sales revenue.Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant Which approach provides the widest variety of visuals while adhering to the security policy?

Use default or any custom visuals from the marketplace.

Use default visuals or custom visuals uploaded from a .pbiviz file.

Use default or any custom visuals from the marketplace.

Use default or certified custom visuals.

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.) What occurred at 12:03:06 PM?

The dashboard tile cache refreshed.

A new transaction was added to the data source.

A user added a comment to a tile.

The dashboard tile cache refreshed.

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Sync the slicers across the pages.

Replace the slicers with report-level filters.

Sync the slicers across the pages.

Replace the slicers with page-level filters.

Replace the slicers with visual-level filters.

Create a bookmark for each slicer value.

Replace the slicers with report-level filters.

You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?

Share the dashboard to the user.

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company. You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data. Which report setting should you configure?

Choose the type of data you allow your end users to export.

Don't allow end user to save filters on this report.

Change default visual interaction from cross highlighting to cross filtering.

Enable the updated filter pane, and show filters in the visual header for this report.

Allow users to add comments to this report.

Choose the type of data you allow your end users to export.

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Add the same slicer to each page and configure Sync slicers.

Edit the interactions of the slicer that is on the same page as the KPI visualization.

Add the same slicer to each page and configure Sync slicers.

Edit the interactions of the KPI visualization.

Edit the interactions of the slicer that is on the same page as the KPI visualization.

Configure a report-level filter.

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.You need to load only the manufacturing reports to a table for analysis.What should you do in Microsoft Power Bl Desktop?

Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.

Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.

Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.

Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.

Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.

Your company has employees in 10 states.The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state.You need to view the employees by region as quickly as possible.What should you do?

Create a new group on the state column and set the Group type to List.

Create a new aggregation that summarizes by employee.

Create a new group on the state column and set the Group type to List.

Create a new group on the state column and set the Group type to Bin.

Create a new aggregation that summarizes by state.

You have a query that returns the data shown in the following exhibit. You need to configure the query to display the data as shown in the following exhibit. Which step should you use in the query?

= Table.Unpivot(Source, {"classes"}, "Attribute", "Value")

=Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")

= Table.Unpivot(Source, {"classes"}, "Attribute", "Value")

= Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),{"classes.1"})

= Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date. You need to reduce the size of the data model.What should you do?

Split the Date column into two columns, one that contains only the time and another that contains only the date.

Round the hour of the Date column to startOfHour.

Change the data type of the Date column to Text.

Split the Date column into two columns, one that contains only the time and another that contains only the date.

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to.You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do?

Remove the Subject and Body columns during the import.

Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Remove the Subject and Body columns during the import.

From Model view, set the Subject and Body columns to Hidden.

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.

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.

You have a prospective customer list that contains 1,500 rows of dat a. The list contains the following fields:First nameLast nameEmail addressState/RegionPhone numberYou 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.

Enable Column profiling based on entire dataset.

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:Customer IDCustomer NamePhoneEmail AddressAddress IDAddress contains the following columns:Address IDAddress Line 1Address Line 2CityState/RegionCountryPostal CodeThe 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.

You have the following three versions of an Azure SQL database:TestProductionDevelopmentYou 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 parameter and update the queries to use the parameter.

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.

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. D18912E1457D5D1DDCBD40AB3BF70D5DWhat should you do?

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

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.

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?

Set Data Connectivity mode to DirectQuery.

Set the Command timeout in minutes setting.

Set Data Connectivity mode to Import.

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] = 2020If 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 or the Calendar Year is 2020.

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.

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?

Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

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.

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

Question 1 / 40

You plan to create the chart shown in the following exhibit.

Microsoft PL-300 image Question 8 106265 10052024010716000000

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

Create a horizontal line that has a fixed value of 24,000.

Add a measure to the visual that uses the following DAX expression.

Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.

Add a measure to the visual that uses the following DAX expression.

Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Comment (0)

Microsoft PL-300 Practice Test 2

Question

Microsoft PL-300 Practice Tests

Practice Tests