PL-300 daily web practice

Answer choices

1. A. Use a merge operation to join tables on common keys.
2. B. Stack compatible rowsets using an append operation.
3. C. Create calculated columns for each dataset before combining them.
4. D. Apply filters to each table individually and then load them separately.

Wrong-answer review

• B. Stack compatible rowsets using an append operation.: B is incorrect because appending rowsets stacks them vertically, which does not combine datasets based on shared attributes.
• C. Create calculated columns for each dataset before combining them.: C is incorrect because creating calculated columns does not address the need to combine datasets; it only adds new calculations within a single dataset.
• D. Apply filters to each table individually and then load them separately.: D is incorrect because applying filters and loading tables separately does not achieve the goal of combining datasets into a unified view.

Answer choices

1. A. Create calculated columns for each measure.
2. B. Use measures instead of calculated columns to handle dynamic calculations.
3. C. Import raw data directly into the report without transformation.
4. D. Apply filters at the dataset level rather than using DAX.

Wrong-answer review

• A. Create calculated columns for each measure.: A is incorrect because calculated columns are static and do not evaluate in filter context.
• C. Import raw data directly into the report without transformation.: C is incorrect because importing raw data without transformation can lead to inefficient reporting and analysis.
• D. Apply filters at the dataset level rather than using DAX.: D is incorrect because applying filters at the dataset level does not leverage DAX's ability to handle complex calculations.

Answer choices

1. A. Disable cross-filtering between visuals.
2. B. Enable cross-highlighting between visuals.
3. C. Set the interaction between visuals to 'None'.
4. D. Configure the visual interactions to filter only when selecting.

Wrong-answer review

• A. Disable cross-filtering between visuals.: A is incorrect because cross-filtering would impact the order date visual, which is not the desired behavior.
• B. Enable cross-highlighting between visuals.: B is incorrect because cross-highlighting still filters the order date visual.
• D. Configure the visual interactions to filter only when selecting.: D is incorrect because this is not a valid option in Power BI's visual interaction settings.

Answer choices

1. A. Set all data sources to 'Organizational' privacy level.
2. B. Use 'None' for privacy levels to simplify data access.
3. C. Adjust privacy levels based on the sensitivity of each dataset, using 'Private', 'Shared', or 'Public'.
4. D. Ignore privacy settings and focus solely on data integration.

Wrong-answer review

• A. Set all data sources to 'Organizational' privacy level.: A is incorrect because setting all data to 'Organizational' may expose sensitive information unnecessarily.
• B. Use 'None' for privacy levels to simplify data access.: B is incorrect as using 'None' for privacy levels can lead to significant security risks and data breaches.
• D. Ignore privacy settings and focus solely on data integration.: D is incorrect because ignoring privacy settings compromises data security and compliance.

Answer choices

1. A. Inspect generated DAX in Query View to identify inefficient calculations.
2. B. Increase data refresh frequency to improve performance.
3. C. Add more columns to the model for detailed analysis.
4. D. Switch all measures from calculated columns to row-level security.

Wrong-answer review

• B. Increase data refresh frequency to improve performance.: B is incorrect as increasing data refresh frequency does not address the root cause of slow queries.
• C. Add more columns to the model for detailed analysis.: C is incorrect because adding more columns can increase complexity and potentially worsen performance issues.
• D. Switch all measures from calculated columns to row-level security.: D is incorrect since row-level security is unrelated to optimizing query performance.

Answer choices

1. A. Apply rule-based conditional formatting to change the color of cells when service level metrics fall below 80%
2. B. Use data-driven conditional formatting based on the average service level across all departments
3. C. Create a slicer that filters out any records where service levels are above 95%
4. D. Add a tooltip that displays additional information for each inspection record

Wrong-answer review

• B. Use data-driven conditional formatting based on the average service level across all departments: B is incorrect: Data-driven formatting would not specifically target low service levels but rather adjust based on overall averages, missing the point of highlighting exceptions.
• C. Create a slicer that filters out any records where service levels are above 95%: C is incorrect: Filtering out high-performing records does not help in identifying where improvements are needed; instead, it hides critical information.
• D. Add a tooltip that displays additional information for each inspection record: D is incorrect: While tooltips can provide additional context, they do not visually highlight issues as effectively as conditional formatting.

Answer choices

1. A. Use the 'Replace Values' transformation to manually correct each erroneous entry.
2. B. Apply the 'Change Type' transformation to convert all date columns to a consistent format.
3. C. Ignore the errors and proceed with loading data, assuming minor discrepancies won't impact analysis.
4. D. Delete all rows containing dates to avoid any potential issues.

Wrong-answer review

• A. Use the 'Replace Values' transformation to manually correct each erroneous entry.: A is incorrect because manually correcting each entry is inefficient and error-prone for large datasets.
• C. Ignore the errors and proceed with loading data, assuming minor discrepancies won't impact analysis.: C is incorrect because ignoring errors can lead to inaccurate analysis results.
• D. Delete all rows containing dates to avoid any potential issues.: D is incorrect as deleting rows with dates would result in loss of valuable data.

Answer choices

1. A. Set all relationships as one-to-many with bidirectional filtering.
2. B. Define relationships based on business logic and set appropriate filter directions.
3. C. Use only many-to-one relationships to simplify data modeling.
4. D. Avoid setting any specific filter directions to maintain flexibility.

Wrong-answer review

• A. Set all relationships as one-to-many with bidirectional filtering.: A is incorrect because bidirectional filtering can lead to unintended results.
• C. Use only many-to-one relationships to simplify data modeling.: C is incorrect because many-to-one relationships alone do not address all modeling scenarios.
• D. Avoid setting any specific filter directions to maintain flexibility.: D is incorrect as avoiding specific filter directions can result in ambiguous data behavior.

Answer choices

1. A. Create a calculated column to aggregate daily attendance counts.
2. B. Add a visual-level bookmark to capture different states of the report.
3. C. Use a measure to dynamically calculate attendance trends based on selected filters.
4. D. Apply conditional formatting to highlight specific days with low attendance.

Wrong-answer review

• A. Create a calculated column to aggregate daily attendance counts.: A is incorrect because a calculated column would fix the data aggregation and not allow dynamic interaction.
• B. Add a visual-level bookmark to capture different states of the report.: B is incorrect because bookmarks are used to capture report states, not to calculate trends dynamically.
• D. Apply conditional formatting to highlight specific days with low attendance.: D is incorrect because conditional formatting highlights specific values but does not support trend analysis over time.

Answer choices

1. A. Create keys by using unique identifiers from each dataset.
2. B. Use default column names without modification.
3. C. Combine datasets based on row order rather than specific keys.
4. D. Rely solely on data type matching for creating relationships.

Wrong-answer review

• B. Use default column names without modification.: B is incorrect because default column names may not be suitable or consistent across datasets, leading to unreliable joins.
• C. Combine datasets based on row order rather than specific keys.: C is incorrect because combining datasets based on row order does not ensure that related data points are accurately linked.
• D. Rely solely on data type matching for creating relationships.: D is incorrect because relying solely on data type matching ignores the need for unique identifiers, which are crucial for stable relationships.