You have a Power BI semantic model that connects to an on-premises SQL Server database. The database credentials recently changed. You need to update the data source credentials without affecting the existing report visuals. What should you do?

Edit the data source settings in Power BI Desktop and re-publish the report.

Change the privacy level for the data source to Public.

Recreate the data source connection in Power Query and refresh the report.

Update the credentials in the dataset settings page in the Power BI service.

A data analyst has a Power BI report that uses a parameter named 'Environment' to switch between Development and Production SQL Server databases. The parameter is used in the data source connection. The analyst wants to ensure that when the report is published to the Power BI service, the parameter can be changed by the report owner without editing the query. What should the analyst do?

Use a bookmark to switch between environments.

Create two separate reports, one for each environment.

Publish the report and then change the parameter value in the Power BI service settings.

Edit the M code in Power Query to change the environment.

A data analyst needs to connect to a data source that provides real-time streaming data from IoT sensors. The data is continuously generated and the report must display the latest readings with minimal latency. Which type of data source should the analyst use in Power BI?

An Excel file stored on OneDrive

A SharePoint list that is manually updated

A SQL Server database that is updated every hour

A company uses Microsoft Fabric and has a large fact table in a lakehouse that is updated continuously. The business requires that reports always show the latest data, but also requires that interactive filtering on a high-cardinality column (e.g., customer ID) be fast. The company has Power BI Premium capacity. The analyst is considering DirectLake mode. What is the primary trade-off the analyst should evaluate?

DirectLake provides real-time data but may have slower performance for high-cardinality filters compared to Import mode.

DirectLake requires a separate refresh process, which adds complexity.

DirectLake duplicates the data, increasing storage costs.

DirectLake is only available for small datasets, limiting its use.

Which of the following is a common use of a parameter in Power BI?

To change the data source file path dynamically

To create a new table in the data model

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 1

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

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 1–5

1application · medium
You have a Power BI semantic model that connects to an on-premises SQL Server database. The database credentials recently changed. You need to update the data source credentials without affecting the existing report visuals. What should you do?
Select an answer first
2expert · hard
A data analyst has a Power BI report that uses a parameter named 'Environment' to switch between Development and Production SQL Server databases. The parameter is used in the data source connection. The analyst wants to ensure that when the report is published to the Power BI service, the parameter can be changed by the report owner without editing the query. What should the analyst do?
Select an answer first
3application · medium
A data analyst needs to connect to a data source that provides real-time streaming data from IoT sensors. The data is continuously generated and the report must display the latest readings with minimal latency. Which type of data source should the analyst use in Power BI?
Select an answer first
4expert · hard
A company uses Microsoft Fabric and has a large fact table in a lakehouse that is updated continuously. The business requires that reports always show the latest data, but also requires that interactive filtering on a high-cardinality column (e.g., customer ID) be fast. The company has Power BI Premium capacity. The analyst is considering DirectLake mode. What is the primary trade-off the analyst should evaluate?
Select an answer first
5foundation · easy
Which of the following is a common use of a parameter in Power BI?
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 1)

Questions 1–5

You have a Power BI semantic model that connects to an on-premises SQL Server database. The database credentials recently changed. You need to update the data source credentials without affecting the existing report visuals. What should you do?

A data analyst needs to connect to a data source that provides real-time streaming data from IoT sensors. The data is continuously generated and the report must display the latest readings with minimal latency. Which type of data source should the analyst use in Power BI?

Which of the following is a common use of a parameter in Power BI?

Keep studying — Prepare the data