Free Access to GAQM.Databricks-Certified-Data-Engineer-Associate.v2024-09-16.q91 with Valid Practice Test (Page 9)

Question 36

A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team.
Which of the following commands can be used to grant the necessary permission on the entire database to the new team?

A.GRANT CREATE ON DATABASE customers TO team;
B.GRANT VIEW ON CATALOG customers TO team;
C.GRANT USAGE ON CATALOG team TO customers;
D.GRANT USAGE ON DATABASE customers TO team;

Question 37

A data architect has determined that a table of the following format is necessary:

Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?

A.Option A
B.Option B
C.Option C
D.Option D
E.Option E

Question 38

A data engineer is attempting to drop a Spark SQL table my_table. The data engineer wants to delete all table metadata and data.
They run the following command:
DROP TABLE IF EXISTS my_table
While the object no longer appears when they run SHOW TABLES, the data files still exist.
Which of the following describes why the data files still exist and the metadata files were deleted?

A.The table's data was larger than 10 GB
B.The table's data was smaller than 10 GB
C.The table was external
D.The table did not have a location
E.The table was managed

Question 39

A dataset has been defined using Delta Live Tables and includes an expectations clause:
CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION DROP ROW What is the expected behavior when a batch of data containing data that violates these constraints is processed?

A.Records that violate the expectation are dropped from the target dataset and loaded into a quarantine table.
B.Records that violate the expectation are added to the target dataset and flagged as invalid in a field added to the target dataset.
C.Records that violate the expectation are dropped from the target dataset and recorded as invalid in the event log.
D.Records that violate the expectation are added to the target dataset and recorded as invalid in the event log.
E.Records that violate the expectation cause the job to fail.

Question 40