Exam PL-300 topic 2 question 30 discussion

Actual exam question from Microsoft's PL-300

Question #: 30
Topic #: 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 report-level filter that filters based on the order date.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by Mizaan at Oct. 4, 2022, 3:49 p.m.

Comments

Submit Cancel

Mizaan

Highly Voted 2 years, 10 months ago

Selected Answer: B

It says "you want to import sample data". If you are filter at a chart level, you have already imported the data, so the answer is no

upvoted 37 times

...

Igetmyrole

Highly Voted 1 year, 11 months ago

B is the correct answer. Adding a report-level filter based on the order date doesn't meet the goal of importing a sample of the data from the Order table. A report-level filter affects the data that is displayed within the report but doesn't change the data imported into the data model. To import sample of the data, we need to apply a filter during the data loading process, such as using Power Query Editor or SQL query options, to select a subset of the records from the Order table before importing it into the data model.

upvoted 7 times

...

GiuseppeTanda

Most Recent 8 months, 2 weeks ago

Selected Answer: B

Report level comes after import data.

upvoted 1 times

...

jaume

9 months ago

Selected Answer: B

Report-level filter will reduce the results visualized in the report but data-model behind report would remain the same

upvoted 2 times

...

23042b9

9 months, 3 weeks ago

Selected Answer: B

The answer is: No (N) Creating inactive relationships alone does not meet the goal of analyzing sales over time based on all the date foreign keys without using DAX measures to activate those relationships.

upvoted 1 times

...