In Power Query, what is the purpose of creating a parameter?

To define a relationship between two tables

To store a value that can be used to dynamically change queries

To create a calculated column in the data model

To format the visual appearance of a report

In Power BI Desktop, where can a data analyst change the privacy level setting for a data source?

In the Model view under 'Relationships'

In the Data view under 'Column Tools'

In the Report view under 'Page Setup'

In the Power Query Editor under 'Data Source Settings'

Which of the following is a valid way to connect to data in Power BI Desktop?

Use the 'Publish' button on the Home tab

Use the 'Get Data' button on the Home tab

Use the 'New Measure' button on the Home tab

Use the 'Transform Data' button on the Home tab

When modifying data source settings in Power BI, what is the purpose of setting a privacy level?

To restrict which users can view the report

To define the refresh schedule for the dataset

To encrypt data at rest in the Power BI service

To control how data is combined across sources

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 1

Get or Connect to Data PL-300 Practice Questions (Page 3)

Part of the Prepare the data domain, which accounts for 25–30% of the PL-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 3–7 from this objective — we provide 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

8concepts

25–30%of the exam

Questions 11–15

11foundation · easy
In Power Query, what is the purpose of creating a parameter?
Select an answer first
12foundation · easy
A data analyst needs to create a report based on a CSV file that is updated weekly. The report does not require real-time data. Which connectivity mode is most appropriate?
Select an answer first
13foundation · easy
In Power BI Desktop, where can a data analyst change the privacy level setting for a data source?
Select an answer first
14foundation · easy
Which of the following is a valid way to connect to data in Power BI Desktop?
Select an answer first
15foundation · easy
When modifying data source settings in Power BI, what is the purpose of setting a privacy level?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-300” is a trademark of its owner, used for identification only.