You have a Power BI report that uses a parameter named StartDate to filter data in the query. The business now wants to see data from the beginning of the previous year instead of the current year. What is the most efficient way to update the report?

Change the data source to a different database that has the new date range.

Create a new parameter and replace the old one in the query.

Edit the query steps to hard-code the new start date.

Change the parameter's current value to the new start date.

A data analyst needs to change the value of an existing parameter in Power Query from '2024' to '2025'. Where should they make this change?

In the 'Manage Parameters' dialog in Power Query Editor

In the 'Report view' under 'Bookmarks'

In the 'Model view' under 'Properties'

In the 'Data Source Settings' dialog

A data analyst connects Power BI Desktop to an on-premises SQL Server database using Windows authentication. The analyst wants to ensure that when the report is refreshed in the Power BI service, the refresh uses a specific service account rather than the analyst's personal credentials. What should the analyst configure in the data source settings?

Change the authentication method to 'OAuth2'.

Edit the data source credentials and select 'Windows' authentication, then provide the service account username and password.

Set the data source to use 'Anonymous' authentication.

Set the privacy level for the data source to 'Private'.

You have a Power BI report that connects to a folder containing monthly sales files. The folder path changes each month (e.g., C:\Sales\2024\01, C:\Sales\2024\02). You want to be able to update the folder path without editing the query. What should you do?

Use a calculated column to determine the folder path.

Create a new query for each month and hide the old ones.

Use a relative path in the query.

Create a parameter for the folder path and reference it in the query.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 1

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

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 6–10

6foundation · easy
A business requires a Power BI report that always shows the most current data from a SQL Server database, with no scheduled refresh. Which connectivity mode should the analyst choose?
Select an answer first
7application · medium
You have a Power BI report that uses a parameter named StartDate to filter data in the query. The business now wants to see data from the beginning of the previous year instead of the current year. What is the most efficient way to update the report?
Select an answer first
8foundation · easy
A data analyst needs to change the value of an existing parameter in Power Query from '2024' to '2025'. Where should they make this change?
Select an answer first
9application · medium
A data analyst connects Power BI Desktop to an on-premises SQL Server database using Windows authentication. The analyst wants to ensure that when the report is refreshed in the Power BI service, the refresh uses a specific service account rather than the analyst's personal credentials. What should the analyst configure in the data source settings?
Select an answer first
10application · medium
You have a Power BI report that connects to a folder containing monthly sales files. The folder path changes each month (e.g., C:\Sales\2024\01, C:\Sales\2024\02). You want to be able to update the folder path without editing the query. What should you do?
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.

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

Questions 6–10

A business requires a Power BI report that always shows the most current data from a SQL Server database, with no scheduled refresh. Which connectivity mode should the analyst choose?

You have a Power BI report that uses a parameter named StartDate to filter data in the query. The business now wants to see data from the beginning of the previous year instead of the current year. What is the most efficient way to update the report?

A data analyst needs to change the value of an existing parameter in Power Query from '2024' to '2025'. Where should they make this change?

You have a Power BI report that connects to a folder containing monthly sales files. The folder path changes each month (e.g., C:\Sales\2024\01, C:\Sales\2024\02). You want to be able to update the folder path without editing the query. What should you do?

Keep studying — Prepare the data