Free ADE Data Transformation & Cleaning Questions and Answers

Question 1

What is data transformation in pipelines?

Accepted Answer

Converting data format

Answer

Deleting data.

Answer

Storing data only.

Answer

Visualizing data.

Question 2

Which technique removes duplicate records?

Accepted Answer

Deduplication

Answer

Aggregation.

Answer

Normalization.

Answer

Partitioning.

Question 3

What is data normalization?

Accepted Answer

Restructuring data to reduce redundancy

Answer

Sorting data.

Answer

Encrypting data.

Answer

Filtering data.

Question 4

Which method fills missing data values?

Accepted Answer

Imputation

Answer

Clustering.

Answer

Sampling.

Answer

Indexing.

Question 5

What is the goal of data cleansing?

Accepted Answer

To correct errors

Answer

To hide errors.

Answer

To encrypt data.

Answer

To archive data.

Question 6

Which tool is commonly used for data transformation?

Accepted Answer

Apache Spark

Answer

Microsoft Word.

Answer

Photoshop.

Answer

Excel.

Question 7

Why is schema validation important during transformation?

Accepted Answer

To ensure data format correctness

Answer

To slow down processing.

Answer

To delete extra data.

Answer

To encrypt data.

Question 8

What is data enrichment?

Accepted Answer

Adding relevant external data

Answer

Deleting duplicate data.

Answer

Encrypting data.

Answer

Partitioning data.

Question 9

What is the role of data profiling?

Accepted Answer

To analyze data quality and structure

Answer

To visualize data only.

Answer

To delete invalid data.

Answer

To backup data.