Exam Certified Data Engineer Professional topic 1 question 43 discussion

Actual exam question from Databricks's Certified Data Engineer Professional

Question #: 43
Topic #: 1

[All Certified Data Engineer Professional Questions]

The data governance team has instituted a requirement that all tables containing Personal Identifiable Information (PH) must be clearly annotated. This includes adding column comments, table comments, and setting the custom table property "contains_pii" = true.
The following SQL DDL statement is executed to create a new table:

Which command allows manual confirmation that these three requirements have been met?

A. DESCRIBE EXTENDED dev.pii_test
B. DESCRIBE DETAIL dev.pii_test
C. SHOW TBLPROPERTIES dev.pii_test
D. DESCRIBE HISTORY dev.pii_test
E. SHOW TABLES dev

Show Suggested Answer

Suggested Answer: A 🗳️

by rok21 at Dec. 9, 2023, 6:29 p.m.

Comments

Submit Cancel

KadELbied

3 months ago

Selected Answer: A

suretly A

upvoted 1 times

...

Tedet

5 months, 1 week ago

Selected Answer: A

C is wrong since Property value returned by this statement excludes some properties that are internal to spark and hive. The excluded properties are: All the properties that start with prefix spark.sql Property keys such as: EXTERNAL, comment All the properties generated internally by hive to store statistics. Some of these properties are: numFiles, numPartitions, numRows.

upvoted 1 times

...