Practice Exams:

View All

Microsoft PL-300 Data Sources Shared Semantic Models Storage Modes And Parameters Practice Test

Skills 1.1 • 30 original questions

This Microsoft PL-300 Power BI Data Analyst practice test focuses on data sources shared semantic models storage modes and parameters through original scenario-based questions aligned to the skills measured as of April 20, 2026. Use the full ExamSnap PL-300 collection for broader practice across all current skill areas. For broader exam preparation, review the Microsoft PL-300 Exam Dumps page.

Instructions: Select the best answer for each question. Review the explanation after answering; each distractor includes a reason it is not the best choice for that scenario.

Question 1

During a sales analytics project at Fabrikam Manufacturing, the BI developer must connect to the correct raw source or shared semantic model for the reporting requirement. Which action most directly satisfies the requirement for the sales model, analysis cycle 1?

Diagnose and correct the transformation, conversion, or source issue that is producing data import errors
Connect to the required source or to an existing shared semantic model
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required

Correct answer: B

Why: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. This directly addresses the stated requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

Option review:

A: Import errors should be traced to the failing step, incompatible value, type conversion, missing field, or source problem instead of being ignored. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

B: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. This directly addresses the stated requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

C: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

D: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

E: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

Learning point: Connect to the required source or to an existing shared semantic model

Question 2

Adventure Works is revising its analytics solution during a finance dashboard refresh. The team needs to repair or reconfigure the connection by changing credentials, source settings, or privacy levels. Which Power BI action should the Power BI data analyst choose for the finance semantic model, analysis cycle 1?

Use column quality, distribution, profile, and column properties to evaluate the incoming data
Update the data source settings, credentials, or privacy level
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements
Enable or disable load and configure query loading so only required tables enter the model
Clean inconsistent, unexpected, duplicate, or null values with appropriate Power Query transformations

Correct answer: B

Why: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations. This directly addresses the stated requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

Option review:

A: Power Query profiling reveals errors, empty values, distinctness, distributions, and metadata that help analysts assess data quality before modeling. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

B: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations. This directly addresses the stated requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

C: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

D: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

E: Cleaning steps standardize data and resolve values that would otherwise distort calculations, joins, filtering, or reporting. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

Learning point: Update the data source settings, credentials, or privacy level

Question 3

A design review for the operations dashboard, analysis cycle 1 at Proseware Services identifies one required capability: choose the storage/connectivity mode that best balances freshness, scale, and query behavior. Which implementation is the strongest fit?

Merge queries to join columns from related tables or append queries to stack compatible rows
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements
Group rows and apply aggregations in Power Query
Create or edit a Power Query parameter and reference it in query logic
Connect to the required source or to an existing shared semantic model

Correct answer: B

Why: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. This directly addresses the stated requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

Option review:

A: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

B: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. This directly addresses the stated requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

C: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

D: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

E: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

Learning point: Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Question 4

For the customer report, analysis cycle 1, Fourth Coffee wants the least indirect way to make a source value or query input configurable and reusable across Power Query steps. Which Power BI feature or action should the data analyst select?

Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Connect to the required source or to an existing shared semantic model
Group rows and apply aggregations in Power Query
Create or edit a Power Query parameter and reference it in query logic
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables

Correct answer: D

Why: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. This directly addresses the stated requirement: make a source value or query input configurable and reusable across Power Query steps.

Option review:

A: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

B: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

C: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

D: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. This directly addresses the stated requirement: make a source value or query input configurable and reusable across Power Query steps.

E: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

Learning point: Create or edit a Power Query parameter and reference it in query logic

Question 5

The report author at Fabrikam Manufacturing is comparing several approaches for a monthly KPI review. The chosen approach must connect to the correct raw source or shared semantic model for the reporting requirement. Which option best meets that condition?

Connect to the required source or to an existing shared semantic model
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Use column quality, distribution, profile, and column properties to evaluate the incoming data
Update the data source settings, credentials, or privacy level

Correct answer: A

Option review:

A: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. This directly addresses the stated requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

B: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

C: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

D: Power Query profiling reveals errors, empty values, distinctness, distributions, and metadata that help analysts assess data quality before modeling. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

E: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

Learning point: Connect to the required source or to an existing shared semantic model

Question 6

A support escalation at Adventure Works has been narrowed to one requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels. Which configuration should be investigated first for the inventory model, analysis cycle 2?

Group rows and apply aggregations in Power Query
Enable or disable load and configure query loading so only required tables enter the model
Create or edit a Power Query parameter and reference it in query logic
Connect to the required source or to an existing shared semantic model
Update the data source settings, credentials, or privacy level

Correct answer: E

Option review:

A: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

B: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

C: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

D: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

E: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations. This directly addresses the stated requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

Learning point: Update the data source settings, credentials, or privacy level

Question 7

An analytics governance review at Proseware Services asks the BI developer to choose the storage/connectivity mode that best balances freshness, scale, and query behavior. Which action aligns most directly with that requirement?

Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Use column quality, distribution, profile, and column properties to evaluate the incoming data
Create or select a stable key that uniquely identifies the appropriate side of a relationship
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Correct answer: E

Option review:

A: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

B: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

C: Power Query profiling reveals errors, empty values, distinctness, distributions, and metadata that help analysts assess data quality before modeling. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

D: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

E: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. This directly addresses the stated requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

Learning point: Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Question 8

Before the forecast report, analysis cycle 2 is released, the analytics team must make a source value or query input configurable and reusable across Power Query steps. Which Power BI implementation should be added?

Create or select a stable key that uniquely identifies the appropriate side of a relationship
Create or edit a Power Query parameter and reference it in query logic
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Group rows and apply aggregations in Power Query
Clean inconsistent, unexpected, duplicate, or null values with appropriate Power Query transformations

Correct answer: B

Option review:

A: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

B: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. This directly addresses the stated requirement: make a source value or query input configurable and reusable across Power Query steps.

C: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

D: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

E: Cleaning steps standardize data and resolve values that would otherwise distort calculations, joins, filtering, or reporting. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

Learning point: Create or edit a Power Query parameter and reference it in query logic

Question 9

Fabrikam Manufacturing is replacing a manual analytics process. The replacement must reliably connect to the correct raw source or shared semantic model for the reporting requirement. Which choice should be implemented for the mobile report, analysis cycle 3?

Connect to the required source or to an existing shared semantic model
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Clean inconsistent, unexpected, duplicate, or null values with appropriate Power Query transformations
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Update the data source settings, credentials, or privacy level

Correct answer: A

Option review:

B: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

C: Cleaning steps standardize data and resolve values that would otherwise distort calculations, joins, filtering, or reporting. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

D: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

Learning point: Connect to the required source or to an existing shared semantic model

Question 10

Which Power BI action best matches this technical purpose for the executive report, analysis cycle 3: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations.

Create or transform columns in Power Query to shape values before load
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements
Group rows and apply aggregations in Power Query
Use column quality, distribution, profile, and column properties to evaluate the incoming data
Update the data source settings, credentials, or privacy level

Correct answer: E

Why: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations. This directly addresses the stated requirement: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations..

Option review:

A: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations..

B: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations..

C: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations..

D: Power Query profiling reveals errors, empty values, distinctness, distributions, and metadata that help analysts assess data quality before modeling. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations..

E: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations. This directly addresses the stated requirement: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations..

Learning point: Update the data source settings, credentials, or privacy level

Question 11

A runbook for the sales model, analysis cycle 3 contains this description: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. Which Power BI feature or action belongs in the runbook?

Diagnose and correct the transformation, conversion, or source issue that is producing data import errors
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Create or select a stable key that uniquely identifies the appropriate side of a relationship
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements
Clean inconsistent, unexpected, duplicate, or null values with appropriate Power Query transformations

Correct answer: D

Why: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. This directly addresses the stated requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

Option review:

A: Import errors should be traced to the failing step, incompatible value, type conversion, missing field, or source problem instead of being ignored. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

B: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

C: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

D: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. This directly addresses the stated requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

E: Cleaning steps standardize data and resolve values that would otherwise distort calculations, joins, filtering, or reporting. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

Learning point: Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Question 12

During validation of the finance semantic model, analysis cycle 3, the analytics lead needs a capability that behaves as follows: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. Which choice is correct?

Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Create or edit a Power Query parameter and reference it in query logic
Create or transform columns in Power Query to shape values before load
Create or select a stable key that uniquely identifies the appropriate side of a relationship
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Correct answer: B

Why: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. This directly addresses the stated requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

Option review:

A: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

B: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. This directly addresses the stated requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

C: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

D: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

E: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

Learning point: Create or edit a Power Query parameter and reference it in query logic

Question 13

A stakeholder asks why a particular Power BI feature should be used for the operations dashboard, analysis cycle 4. The required behavior is: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. Which action provides that behavior?

Connect to the required source or to an existing shared semantic model
Group rows and apply aggregations in Power Query
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Use column quality, distribution, profile, and column properties to evaluate the incoming data

Correct answer: A

Why: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. This directly addresses the stated requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

Option review:

A: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. This directly addresses the stated requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

B: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

C: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

D: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

E: Power Query profiling reveals errors, empty values, distinctness, distributions, and metadata that help analysts assess data quality before modeling. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

Learning point: Connect to the required source or to an existing shared semantic model

Question 14

The customer report, analysis cycle 4 is moving to production at Adventure Works. Which action should be approved when the goal is to repair or reconfigure the connection by changing credentials, source settings, or privacy levels?

Merge queries to join columns from related tables or append queries to stack compatible rows
Update the data source settings, credentials, or privacy level
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Connect to the required source or to an existing shared semantic model

Correct answer: B

Option review:

A: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

C: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

D: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

E: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

Learning point: Update the data source settings, credentials, or privacy level

Question 15

A data analyst at Proseware Services must satisfy this acceptance criterion for the regional workspace, analysis cycle 4: choose the storage/connectivity mode that best balances freshness, scale, and query behavior. Which implementation is most appropriate?

Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements
Create or transform columns in Power Query to shape values before load
Use column quality, distribution, profile, and column properties to evaluate the incoming data
Enable or disable load and configure query loading so only required tables enter the model
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Correct answer: A

Option review:

A: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. This directly addresses the stated requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

B: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

D: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

E: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

Learning point: Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Question 16

A finance dashboard refresh at Fourth Coffee can proceed only after the team can make a source value or query input configurable and reusable across Power Query steps. What should the data analyst configure?

Diagnose and correct the transformation, conversion, or source issue that is producing data import errors
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Create or edit a Power Query parameter and reference it in query logic
Clean inconsistent, unexpected, duplicate, or null values with appropriate Power Query transformations
Use column quality, distribution, profile, and column properties to evaluate the incoming data

Correct answer: C

Option review:

A: Import errors should be traced to the failing step, incompatible value, type conversion, missing field, or source problem instead of being ignored. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

B: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

C: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. This directly addresses the stated requirement: make a source value or query input configurable and reusable across Power Query steps.

D: Cleaning steps standardize data and resolve values that would otherwise distort calculations, joins, filtering, or reporting. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

E: Power Query profiling reveals errors, empty values, distinctness, distributions, and metadata that help analysts assess data quality before modeling. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

Learning point: Create or edit a Power Query parameter and reference it in query logic

Question 17

The analytics team at Fabrikam Manufacturing has ruled out unrelated redesign work. Which action directly enables the team to connect to the correct raw source or shared semantic model for the reporting requirement for the service-level dashboard, analysis cycle 5?

Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Connect to the required source or to an existing shared semantic model
Update the data source settings, credentials, or privacy level
Assign the appropriate data type to each column before loading it
Merge queries to join columns from related tables or append queries to stack compatible rows

Correct answer: B

Option review:

A: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

C: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

D: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

E: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

Learning point: Connect to the required source or to an existing shared semantic model

Question 18

An audit finding for the forecast report, analysis cycle 5 says the current design cannot repair or reconfigure the connection by changing credentials, source settings, or privacy levels. Which Power BI action most directly closes the gap?

Update the data source settings, credentials, or privacy level
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Connect to the required source or to an existing shared semantic model
Diagnose and correct the transformation, conversion, or source issue that is producing data import errors
Merge queries to join columns from related tables or append queries to stack compatible rows

Correct answer: A

Option review:

A: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations. This directly addresses the stated requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

B: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

C: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

D: Import errors should be traced to the failing step, incompatible value, type conversion, missing field, or source problem instead of being ignored. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

E: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

Learning point: Update the data source settings, credentials, or privacy level

Question 19

For the mobile report, analysis cycle 5, the BI developer needs a repeatable solution that will choose the storage/connectivity mode that best balances freshness, scale, and query behavior. Which option should replace the current ad hoc process?

Diagnose and correct the transformation, conversion, or source issue that is producing data import errors
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements
Assign the appropriate data type to each column before loading it

Correct answer: D

Option review:

A: Import errors should be traced to the failing step, incompatible value, type conversion, missing field, or source problem instead of being ignored. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

B: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

C: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

D: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. This directly addresses the stated requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

E: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

Learning point: Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Question 20

During a regional reporting consolidation, Fourth Coffee defines the desired outcome as follows: make a source value or query input configurable and reusable across Power Query steps. Which Power BI capability should the team use?

Create or select a stable key that uniquely identifies the appropriate side of a relationship
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Create or edit a Power Query parameter and reference it in query logic
Merge queries to join columns from related tables or append queries to stack compatible rows
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Correct answer: C

Option review:

B: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

D: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

E: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

Learning point: Create or edit a Power Query parameter and reference it in query logic

Question 21

A new requirement is added to the sales model, analysis cycle 6: connect to the correct raw source or shared semantic model for the reporting requirement. Which action should the self-service BI administrator take?

Create or edit a Power Query parameter and reference it in query logic
Connect to the required source or to an existing shared semantic model
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Use column quality, distribution, profile, and column properties to evaluate the incoming data
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required

Correct answer: B

Option review:

A: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

Learning point: Connect to the required source or to an existing shared semantic model

Question 22

Adventure Works is troubleshooting an unexpected reporting result. The decisive requirement is to repair or reconfigure the connection by changing credentials, source settings, or privacy levels. Which feature or configuration is most relevant?

Create or edit a Power Query parameter and reference it in query logic
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Update the data source settings, credentials, or privacy level
Diagnose and correct the transformation, conversion, or source issue that is producing data import errors
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Correct answer: C

Option review:

A: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

B: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

C: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations. This directly addresses the stated requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

E: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

Learning point: Update the data source settings, credentials, or privacy level

Question 23

A technical workshop for the operations dashboard, analysis cycle 6 documents this behavior: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. Which Power BI choice is being described?

Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements
Assign the appropriate data type to each column before loading it
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Diagnose and correct the transformation, conversion, or source issue that is producing data import errors
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Correct answer: A

Why: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. This directly addresses the stated requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

Option review:

A: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. This directly addresses the stated requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

B: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

C: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

D: Import errors should be traced to the failing step, incompatible value, type conversion, missing field, or source problem instead of being ignored. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

E: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import..

Learning point: Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Question 24

The analytics lead must identify the Power BI capability that provides this function: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. Which answer is correct for the customer report, analysis cycle 6?

Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Merge queries to join columns from related tables or append queries to stack compatible rows
Assign the appropriate data type to each column before loading it
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Create or edit a Power Query parameter and reference it in query logic

Correct answer: E

Why: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. This directly addresses the stated requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

Option review:

A: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

B: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

C: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

D: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

E: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. This directly addresses the stated requirement: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations..

Learning point: Create or edit a Power Query parameter and reference it in query logic

Question 25

A modernization plan for the regional workspace, analysis cycle 7 requires the team to connect to the correct raw source or shared semantic model for the reporting requirement. Which Power BI action is the clearest fit?

Connect to the required source or to an existing shared semantic model
Diagnose and correct the transformation, conversion, or source issue that is producing data import errors
Update the data source settings, credentials, or privacy level
Use column quality, distribution, profile, and column properties to evaluate the incoming data
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Correct answer: A

Option review:

B: Import errors should be traced to the failing step, incompatible value, type conversion, missing field, or source problem instead of being ignored. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

E: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: connect to the correct raw source or shared semantic model for the reporting requirement.

Learning point: Connect to the required source or to an existing shared semantic model

Question 26

The analytics lead at Adventure Works is creating a standard for the inventory model, analysis cycle 7. The standard must repair or reconfigure the connection by changing credentials, source settings, or privacy levels. Which feature should be documented?

Create or edit a Power Query parameter and reference it in query logic
Diagnose and correct the transformation, conversion, or source issue that is producing data import errors
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Update the data source settings, credentials, or privacy level
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables

Correct answer: D

Option review:

A: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

B: Import errors should be traced to the failing step, incompatible value, type conversion, missing field, or source problem instead of being ignored. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

C: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

D: Data source settings control connection details, credentials, and privacy behavior used by Power Query and refresh operations. This directly addresses the stated requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

E: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

Learning point: Update the data source settings, credentials, or privacy level

Question 27

Which implementation should Proseware Services use for the service-level dashboard, analysis cycle 7 when the business requirement is to choose the storage/connectivity mode that best balances freshness, scale, and query behavior?

Assign the appropriate data type to each column before loading it
Create or edit a Power Query parameter and reference it in query logic
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Diagnose and correct the transformation, conversion, or source issue that is producing data import errors

Correct answer: C

Option review:

A: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

B: Parameters make source values, filters, or other query inputs reusable and easier to change without rewriting multiple transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

C: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. This directly addresses the stated requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

D: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

E: Import errors should be traced to the failing step, incompatible value, type conversion, missing field, or source problem instead of being ignored. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: choose the storage/connectivity mode that best balances freshness, scale, and query behavior.

Learning point: Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Question 28

A pilot review at Fourth Coffee finds that users still cannot make a source value or query input configurable and reusable across Power Query steps. Which action should be completed before the forecast report, analysis cycle 7 is expanded?

Group rows and apply aggregations in Power Query
Create or edit a Power Query parameter and reference it in query logic
Clean inconsistent, unexpected, duplicate, or null values with appropriate Power Query transformations
Use column quality, distribution, profile, and column properties to evaluate the incoming data
Assign the appropriate data type to each column before loading it

Correct answer: B

Option review:

A: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

C: Cleaning steps standardize data and resolve values that would otherwise distort calculations, joins, filtering, or reporting. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

D: Power Query profiling reveals errors, empty values, distinctness, distributions, and metadata that help analysts assess data quality before modeling. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

E: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: make a source value or query input configurable and reusable across Power Query steps.

Learning point: Create or edit a Power Query parameter and reference it in query logic

Question 29

The report author needs to justify a Power BI design decision for the mobile report, analysis cycle 8. The feature must provide this behavior: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. Which selection is most defensible?

Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Connect to the required source or to an existing shared semantic model
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Create or transform columns in Power Query to shape values before load
Create or select a stable key that uniquely identifies the appropriate side of a relationship

Correct answer: B

Why: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. This directly addresses the stated requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

Option review:

A: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

B: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic. This directly addresses the stated requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

C: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

D: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

E: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Power BI can acquire data directly from supported sources or build a report from a governed semantic model that already contains reusable business logic..

Learning point: Connect to the required source or to an existing shared semantic model

Question 30

For a customer analytics initiative, the executive report, analysis cycle 8 must support the ability to repair or reconfigure the connection by changing credentials, source settings, or privacy levels. Which option is technically aligned with that goal?

Diagnose and correct the transformation, conversion, or source issue that is producing data import errors
Enable or disable load and configure query loading so only required tables enter the model
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Update the data source settings, credentials, or privacy level
Select Import, DirectQuery, or Direct Lake according to freshness, scale, and Fabric architecture requirements

Correct answer: D

Option review:

A: Import errors should be traced to the failing step, incompatible value, type conversion, missing field, or source problem instead of being ignored. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

C: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

E: Import stores data in the semantic model, DirectQuery queries the source at report time, and Direct Lake is optimized for Fabric data in OneLake without a conventional full import. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: repair or reconfigure the connection by changing credentials, source settings, or privacy levels.

Learning point: Update the data source settings, credentials, or privacy level

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 26

Question 27

Question 28

Question 29

Question 30

Related posts: