Databricks-Certified-Data-Engineer-Associate 무료 덤프문제 온라인 액세스

A new data engineering team team. has been assigned to an ELT project. The new data engineering team will need full privileges on the database customers to fully manage the project.
Which of the following commands can be used to grant full permissions on the database to the new data engineering team?

• A.GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;
• B.GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;
• C.GRANT USAGE ON DATABASE customers TO team;
• D.GRANT ALL PRIVILEGES ON DATABASE customers TO team;
• E.GRANT ALL PRIVILEGES ON DATABASE team TO customers;

A data engineer has developed an ETL that produce a Delta managed table with liquid clustering feature activated as output. Several consumers are having issues regarding time delay when reading this table. How could the Data Engineer be sure about the OPTIMIZE command has been executed explicitly?

• A.Use DESCRIBE HISTORY table to check if exists any OPTIMIZE operation
• B.Use SHOW TABLES EXTENDED to check the partitions columns used
• C.Use DESCRIBE DETAIL table to see the file size and number of files for the table
• D.Check the system table system.storage.predictive_optimization_operations_history

Which of the following describes the relationship between Bronze tables and raw data?

• A.Bronze tables contain more truthful data than raw data.
• B.Bronze tables contain less data than raw data files.
• C.Bronze tables contain aggregates while raw data is unaggregated.
• D.Bronze tables contain raw data with a schema applied.
• E.Bronze tables contain a less refined view of data than raw data.

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 cause the job to fail.
• 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 are dropped from the target dataset and recorded as invalid in the event log.

A data engineer is running code in a Databricks Repo that is cloned from a central Git repository.
A colleague of the data engineer informs them that changes have been made and synced to the central Git repository. The data engineer now needs to sync their Databricks Repo to get the changes from the central Git repository.
Which of the following Git operations does the data engineer need to run to accomplish this task?

• A.Commit
• B.Merge
• C.Push
• D.Clone
• E.Pull