QUESTION: 29 Exam Topic: Question Set 1

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.
What should you select in Power Query Editor?

Merge queries
Combine files
Append queries

Answer(s): A

Reveal Solution Next Question

QUESTION: 30 Exam Topic: Question Set 1

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 the Parse function from the Date transformations options to the Logged column.

Answer(s): C

Reveal Solution Next Question

QUESTION: 31 Exam Topic: Question Set 2

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

Answer(s): A

Explanation:

The LEN DAX function returns the number of characters in a text string.
Note: DAX is a collection of Power BI functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values.
Stated more simply, DAX helps you create new information from data already in your model.

Reference:

https://docs.microsoft.com/en-us/dax/len-function-dax
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quickstart-learn-dax-basics

Reveal Solution Next Question

QUESTION: 32 Exam Topic: Question Set 2

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.
Each sales region 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.
Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Answer(s): A

Reference:

https://kunaltripathy.com/2021/10/06/bring-your-power-bi-to-power-apps-portal-part-ii/

Reveal Solution Next Question

Free PL-300 Exam Braindumps (page: 8)

QUESTION: 29 Exam Topic: Question Set 1

QUESTION: 30 Exam Topic: Question Set 1

QUESTION: 31 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 32 Exam Topic: Question Set 2

Reference: