Databricks-Certified-Data-Engineer-Associate Exam Dumps – Our Features

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 ROWWhat is the expected behavior when a batch of data containing data that violates these constraints is processed?

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

A data engineer has a Job with multiple tasks that runs nightly. Each of the tasks runs slowly because the clusters take a long time to start.Which of the following actions can the data engineer perform to improve the start up time for the clusters used for the Job?

• They can use endpoints available in Databricks SQL
• They can use jobs clusters instead of all-purpose clusters
• They can configure the clusters to be single-node
• They can use clusters that are from a cluster pool
• They can configure the clusters to autoscale for larger data sizes

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?

• SELECT * FROM my_table WHERE age > 25;
• UPDATE my_table WHERE age > 25;
• DELETE FROM my_table WHERE age > 25;
• UPDATE my_table WHERE age <= 25;
• DELETE FROM my_table WHERE age <= 25;

An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project’s release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project’s release.Which of the following approaches can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project’s release?

• They can set a limit to the number of DBUs that are consumed by the SQL Endpoint.
• They can set the query’s refresh schedule to end after a certain number of refreshes.
• They cannot ensure the query does not cost the organization money beyond the first week of the project’s release.
• They can set a limit to the number of individuals that are able to manage the query’s refresh schedule.
• They can set the query’s refresh schedule to end on a certain date in the query scheduler.

A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location.Which of the following data entities should the data engineer create?

• Database
• Function
• View
• Temporary view
• Table

A data analyst has a series of queries in a SQL program. The data analyst wants this program to run every day. They only want the final query in the program to run on Sundays. They ask for help from the data engineering team to complete this task.Which of the following approaches could be used by the data engineering team to complete this task?

• They could submit a feature request with Databricks to add this functionality.
• They could wrap the queries using PySpark and use Python’s control flow system to determine when to run the final query.
• They could only run the entire program on Sundays.
• They could automatically restrict access to the source table in the final query so that it is only accessible on Sundays.
• They could redesign the data model to separate the data used in the final query into a new table.

A new data engineering 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?

• GRANT USAGE ON DATABASE customers TO team;
• GRANT ALL PRIVILEGES ON DATABASE team TO customers;
• GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;
• GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;
• GRANT ALL PRIVILEGES ON DATABASE customers TO team;

Which of the following data lakehouse features results in improved data quality over a traditional data lake?

• A data lakehouse provides storage solutions for structured and unstructured data.
• A data lakehouse supports ACID-compliant transactions.
• A data lakehouse allows the use of SQL queries to examine data.
• A data lakehouse stores data in open formats.
• A data lakehouse enables machine learning and artificial Intelligence workloads.

A data engineering team has two tables. The first table march_transactions is a collection of all retail transactions in the month of March. The second table april_transactions is a collection of all retail transactions in the month of April. There are no duplicate records between the tables.Which of the following commands should be run to create a new table all_transactions that contains all records from march_transactions and april_transactions without duplicate records?

• CREATE TABLE all_transactions AS SELECT * FROM march_transactions
• INNER JOIN SELECT * FROM april_transactions; B.
• CREATE TABLE all_transactions AS SELECT * FROM march_transactions
• UNION SELECT * FROM april_transactions; C.
• CREATE TABLE all_transactions AS SELECT * FROM march_transactions
• OUTER JOIN SELECT * FROM april_transactions; D.
• CREATE TABLE all_transactions AS SELECT * FROM march_transactions
• INTERSECT SELECT * from april_transactions; E.
• CREATE TABLE all_transactions AS SELECT * FROM march_transactions
• MERGE SELECT * FROM april_transactions;

A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version, they are unable to restore the data because the data files have been deleted.Which of the following explains why the data files are no longer present?

• The VACUUM command was run on the table
• The TIME TRAVEL command was run on the table
• The DELETE HISTORY command was run on the table
• The OPTIMIZE command was nun on the table
• The HISTORY command was run on the table