Ingest and Transform Data DP-203 Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   Which of the following is a common approach to identify duplicate rows in a dataset?

   • AEncrypting the data and comparing hashes
   • BGrouping by key columns and counting occurrences to find rows with count greater than one
   • CCompressing the data and checking file sizes
   • DSorting the data by a random column
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the primary benefit of using Apache Spark for data transformation?

   • AIt provides a graphical interface for building transformations without code
   • BIt processes data in a distributed manner across a cluster, enabling scalability for large datasets
   • CIt stores data in a columnar format for faster reads
   • DIt automatically enforces data quality rules on all data
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which T-SQL statement is commonly used to transform data by inserting rows from a source query into an existing table?

   • AINSERT INTO ... SELECT
   • BMERGE ... WHEN MATCHED
   • CUPDATE ... SET
   • DSELECT INTO ... FROM
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which of the following is an example of a data cleansing operation?

   • ACreating an index on a table to speed up queries
   • BReplacing null values in a column with a default value
   • CCopying data from one storage account to another
   • DGranting permissions to users on a database
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What is the primary goal of data cleansing in a data processing pipeline?

   • ATo encrypt data to protect it from unauthorized access
   • BTo partition data for faster query performance
   • CTo improve data accuracy and consistency by correcting or removing errors
   • DTo compress data to reduce storage costs
   Reveal Solution Discussion Select an answer first