Free GAQM Databricks-Certified-Data-Engineer-Associate Exam Dumps Questions & Answers

A data engineer has joined an existing project and they see the following query in the project repository:
CREATE STREAMING LIVE TABLE loyal_customers AS
SELECT customer_id -
FROM STREAM(LIVE.customers)
WHERE loyalty_level = 'high';
Which of the following describes why the STREAM function is included in the query?

• A.  The table being created is a live table.
• B.  The customers table is a reference to a Structured Streaming query on a PySpark DataFrame.
• C.  The customers table is a streaming live table.
• D.  The data in the customers table has been updated since its last run.
• E.  The STREAM function is not needed and will cause an error.

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 E
• B.  Option B
• C.  Option C
• D.  Option A
• E.  Option D

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

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

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 USAGE ON DATABASE customers TO team;
• C.  GRANT SELECT CREATE MODIFY USAGE PRIVILEGES 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 needs access to a table new_uable, but they do not have the correct permissions. They can ask the table owner for permission, but they do not know who the table owner is.
Which approach can be used to identify the owner of new_table?

• A.  Review the Permissions tab in the table's page in Data Explorer
• B.  There is no way to identify the owner of the table
• C.  Review the Owner field in the table's page in the cloud storage solution
• D.  Review the Owner field in the table's page in Data Explorer