DP-203 Sample Paper 2

Online Certification Questions

Question 1

Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?

  • A. SELECT * FROM my_table WHERE age > 25;
  • B. UPDATE my_table WHERE age > 25;
  • C. DELETE FROM my_table WHERE age > 25;
  • D. UPDATE my_table WHERE age <= 25;
  • E. DELETE FROM my_table WHERE age <= 25;

Answer:

DELETE FROM my_table WHERE age > 25;

C is the correct answer as the SELECT statement allows to query a table, the UPDATE statement allows to modify values in columns. If you want to remove rows that don't match a specific condition you must use DELETE

Question 2

Which of the following describes the storage organization of a Delta table?

  • A. Delta tables are stored in a single file that contains data, history, metadata, and other attributes.
  • B. Delta tables store their data in a single file and all metadata in a collection of files in a separate location.
  • C. Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.
  • D. Delta tables are stored in a collection of files that contain only the data stored within the table.
  • E. Delta tables are stored in a single file that contains only the data stored within the table.

Answer:

Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.

Delta tables store data in a structured manner using Parquet files, and they also maintain metadata and transaction logs in separate directories. This organization allows for versioning, transactional capabilities, and metadata tracking in Delta Lake. Thank you for pointing out the error, and I appreciate your understanding.