QUESTION: 45 Exam Topic: Question Set 2

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] = 2020

If 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 where the Calendar Year is 2020.
The user will receive an error and will not be able to see the data in the report.
The user will only see data for which the State Province value is Kentucky.
The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020.

Answer(s): D

Explanation:

Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles.
Both Roles are applied, and both role filters must be met.
Incorrect:
Not B: A model relationship is limited when there's no guaranteed "one" side. You get an error message if you belong to multiple RLS roles and at least one of the roles relies on a limited relationship. But here both relationships have a guaranteed 1 side.

Reference:

https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

Reveal Solution Next Question

QUESTION: 46 Exam Topic: Question Set 2

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?

Answer(s): B

Explanation:

This would load the entire table in the first step.
Instead: You add a WHERE clause to the SQL statement.

Reference:

https://docs.microsoft.com/en-us/power-query/native-database-query

Reveal Solution Next Question

QUESTION: 47 Exam Topic: Question Set 2

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: You write a DAX expression that uses the FILTER function.
Does this meet the goal?

Answer(s): B

Explanation:

Instead: You add a WHERE clause to the SQL statement.
Note: DAX is not a language designed to fetch the data like SQL rather than used for data analysis purposes. It is always a better and recommended approach to transform the data as close to the data source itself. For example, your data source is a relational database; then, it's better to go with T-SQL.
SQL is a structured query language, whereas DAX is a formula language used for data analysis purposes. When our data is stored in some structured database systems like SQL server management studio, MySQL, or others, we have to use SQL to fetch the stored data.

Reference:

https://www.learndax.com/dax-vs-sql-when-to-use-dax-over-sql/

Reveal Solution Next Question

QUESTION: 48 Exam Topic: Question Set 2

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: You add a WHERE clause to the SQL statement.
Does this meet the goal?

Answer(s): A

Explanation:

Power Query enables you to specify your native database query in a text box under Advanced options when connecting to a database. In the example below, you'll import data from a SQL Server database using a native database query entered in the SQL statement text box.
1. Connect to a SQL Server database using Power Query. Select the SQL Server database option in the connector selection.
2. In the SQL Server database popup window:
3. Specify the Server and Database where you want to import data from using native database query.
4. Under Advanced options, select the SQL statement field and paste or enter your native database query, then select OK.

Reference:

https://docs.microsoft.com/en-us/power-query/native-database-query

Reveal Solution Next Question

Free PL-300 Exam Braindumps (page: 12)

QUESTION: 45 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 46 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 47 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 48 Exam Topic: Question Set 2

Explanation:

Reference: