BenchMark Quizzes by MDFT Pro

Discover Anomalies In Power BI Data

You use Power BI Desktop to prepare data for MDFT Academy. You examine data quality in Power Query, focusing on identifying outliers and unusual patterns in your dataset.

You need to discover anomalies in the data. Which two options should you use? Each correct answer presents a complete solution.

Choose all correct answers from the options below.

Explanations for each answer:

Column quality is incorrect. Column quality shows the number and percentage of valid, error, and empty values, but does not assist in identifying anomalies.
Data connectivity mode is incorrect. Data connectivity mode sets the storage mode as Import or Direct Query, not for finding anomalies.
Column distribution is correct. Column distribution shows the distribution of data, which helps identify outliers and anomalies.
Column profile is correct. Column profile shows statistics and the distribution of data in a column, helping to find anomalies.

Learn more about data profiling in Power BI:

Power BI Data Profiling

Exam Preparation Quiz

Discover Anomalies In Power BI Data