BenchMark Quizzes by MDFT Pro

Analyze Data Quality Statements In Power Query

You are analyzing data quality for a dataset in Power BI for MDFT Pro. You use Power Query to preview the data and want to ensure your analysis covers the entire dataset, not just a sample.

Which options should you choose to analyze the entire dataset?

Choose all correct answers from the options below.

Explanations for each answer:

Using Column profile in Data Preview, you can gain an insight into only the first 1,000 rows in the dataset. is incorrect. By default, Power Query examines the first 1,000 rows, but you can change this to analyze the whole dataset.
You can use Column Quality in Data Preview to analyze the entire dataset by changing the profiling status. is correct. You can change the data preview to analyze the entire dataset by selecting the profiling status in the status bar.
You should enable Power Query background refresh to ensure that the preview data is up to date. is incorrect. Enabling background refresh can result in preview data becoming out of date. It is better to disable this option.
You can use Column Distribution to analyze the entire dataset by changing the profiling status. is correct. Column distribution can be set to analyze the entire dataset, not just the first 1,000 rows, by changing the profiling status.

Learn more about data profiling in Power BI:

Power BI Data Profiling

Exam Preparation Quiz

Analyze Data Quality Statements In Power Query