A data analyst regularly connects to a folder that contains monthly sales files. The folder path includes the year and month, such as 'C:\Sales\2024\01'. The analyst wants to create a Power BI report that can be easily updated each month by changing only the folder path. What should the analyst do?

Use Power Query to hard-code the folder path in the M code.

Create a new data source connection each month in Power BI Desktop.

Create a parameter named 'FolderPath' and use it in the folder data source connection.

Use a relative path in the data source settings.

A company stores sales data in an on-premises SQL Server database and also has a shared Power BI semantic model that contains the same data but with additional calculated measures. A data analyst needs to create a new report that uses the calculated measures from the shared semantic model. The analyst does not have permission to modify the database. What should the analyst do in Power BI Desktop?

Connect to the SQL Server database and use a live connection to the database to access the measures.

Export the data from the shared semantic model to a CSV file and then import the CSV into a new report.

Connect to the SQL Server database and recreate the calculated measures in the new report.

Connect to the shared semantic model as the data source and build the report on top of it.

Your organization has a Microsoft Fabric Lakehouse that stores parquet files for a large sales fact table (billions of rows). You need to create a Power BI report that can handle this volume without duplicating storage, and you need the report to reflect new data as soon as it lands in the Lakehouse. What should you use?

DirectLake mode pointing to the Lakehouse

Import mode with incremental refresh

Import mode with a scheduled refresh every hour

DirectQuery mode pointing to the Lakehouse SQL endpoint

A data analyst has a Power BI report that uses a parameter named 'StartDate' to filter data in a SQL query. The business now wants to change the default start date from January 1, 2024 to July 1, 2024. What is the most efficient way to update the report?

Edit the SQL query in Power Query and replace the date literal.

Create a new parameter named 'NewStartDate' and use it in the query.

Change the value of the 'StartDate' parameter in the Manage Parameters dialog.

Change the data source credentials to reflect the new date.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 1

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

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 26–30

26application · medium
A data analyst regularly connects to a folder that contains monthly sales files. The folder path includes the year and month, such as 'C:\Sales\2024\01'. The analyst wants to create a Power BI report that can be easily updated each month by changing only the folder path. What should the analyst do?
Select an answer first
27application · medium
A company stores sales data in an on-premises SQL Server database and also has a shared Power BI semantic model that contains the same data but with additional calculated measures. A data analyst needs to create a new report that uses the calculated measures from the shared semantic model. The analyst does not have permission to modify the database. What should the analyst do in Power BI Desktop?
Select an answer first
28application · medium
Your organization has a Microsoft Fabric Lakehouse that stores parquet files for a large sales fact table (billions of rows). You need to create a Power BI report that can handle this volume without duplicating storage, and you need the report to reflect new data as soon as it lands in the Lakehouse. What should you use?
Select an answer first
29application · medium
A data analyst has a Power BI report that uses a parameter named 'StartDate' to filter data in a SQL query. The business now wants to change the default start date from January 1, 2024 to July 1, 2024. What is the most efficient way to update the report?
Select an answer first
30foundation · easy
A data analyst needs to connect to a data source that stores data in a tabular format with rows and columns, supports large datasets, and is commonly used in business databases. Which type of data source is this?
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 6)

Questions 26–30

A data analyst regularly connects to a folder that contains monthly sales files. The folder path includes the year and month, such as 'C:\Sales\2024\01'. The analyst wants to create a Power BI report that can be easily updated each month by changing only the folder path. What should the analyst do?

A data analyst has a Power BI report that uses a parameter named 'StartDate' to filter data in a SQL query. The business now wants to change the default start date from January 1, 2024 to July 1, 2024. What is the most efficient way to update the report?

A data analyst needs to connect to a data source that stores data in a tabular format with rows and columns, supports large datasets, and is commonly used in business databases. Which type of data source is this?

Keep studying — Prepare the data