Microsoft Microsoft Certified: Data Analyst Associate PL-300 Questions & Answers

• Question 31:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

  During the development process, you need to import a sample of the data from the Order table.

  Solution: You add a WHERE clause to the SQL statement.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 32:

  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?

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

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

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

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

  Correct Answer: B

  It is common practice that the PBI developer creates RLS groups and instructs the network team to create the corresponding AD roles. Then the developer assigns the AD groups to the RLS groups.

• Question 33:

  You have a Power BI tenant.

  You have reports that use financial datasets and are exported as PDF files.

  You need to ensure that the reports are encrypted.

  What should you implement?

  A. dataset certifications

  B. row-level security (RLS)

  C. sensitivity labels

  D. Microsoft Intune policies

  Correct Answer: C

  General availability of sensitivity labels in Power BI.

  Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied on datasets, reports,

  dashboards, and dataflows. When data is exported from Power BI to Excel, PowerPoint or PDF files, Power BI automatically applies a sensitivity label on the exported file and protects it according to the label's file encryption settings. This way

  your sensitive data remains protected no matter where it is.

  Reference:

  https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-data-protection-ga-and- introducing-new-capabilities/

• Question 34:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

  During the development process, you need to import a sample of the data from the Order table.

  Solution: From Power Query Editor, you import the table and then add a filter step to the query. Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 35:

  You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend.

  You need to include a visual that identifies which fields have the greatest impact on Spend.

  Which type of visual should you use?

  A. decomposition tree

  B. QandA

  C. smart narrative

  D. key influences

  Correct Answer: D

• Question 36:

  You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard.

  You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Use quick insights on the dashboard.

  B. Hide the report page.

  C. Ask a question by using QandA.

  D. Add the visual to the report.

  E. Pin the visual to the dashboard.

  Correct Answer: CE

• Question 37:

  You have a collection of reports for the HR department of your company.

  You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.

  Which type of visualization should you use?

  A. scatter chart

  B. ribbon chart

  C. line chart

  D. key influences

  Correct Answer: C

  The best data for forecasting is time series data or uniformly increasing whole numbers. The line chart has to have only one line.

  Try forecasting: Try the new forecasting capabilities of Power View today on your own data or with the sample report available as part of the Power BI report samples. To view your own data, upload a workbook with a Power View time series line chart to Power BI for Office 365.

  Reference: https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365

• Question 38:

  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?

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

  B. Create a DepartmentID parameter to filter the Departments table.

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

  D. Create a slicer that filters Departments based on DepartmentID.

  Correct Answer: A

• Question 39:

  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?

  A. Round the hour of the Date column to startOfHour.

  B. Change the data type of the Date column to Text.

  C. Trim the Date column.

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

  Correct Answer: D

  We have to separate date and time tables. Also, we don't need to put the time into the date table, because the time is repeated every day. Split your DateTime column into a separate date and time columns in fact table, so that you can join the date to the date table and the time to the time table. The time need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table.

  Reference: https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi

• Question 40:

  You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:

  1.

  First name

  2.

  Last name

  3.

  Email address

  4.

  State/Region

  5.

  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.

  A. Open the Advanced Editor.

  B. Select Column quality.

  C. Enable Column profiling based on entire dataset.

  D. Select Column distribution.

  E. Select Column profile.

  Correct Answer: CE

  In Power query, the load preview by default is 1000 row. By default, the column quality also only looks at the first 1000 row. You can verify this by the status bar at the bottom of the Power query window. To change the profiling so it analyses

  the entire column of data, select the profiling status in the status bar. Then select Column profiling based on the entire data set.

  https://theexcelclub.com/data-profiling-views-in-power-query-excel-and-power-bi/