Question 1

Data engineering team is required to share the data across with Data science team, both the teams are using different workspaces which of the following techniques can be used to simplify sharing data across?

Options :

A : Data Sharing

B : Unity Catalog

C : DELTA lake

D : Use single storage location

E : DELTA LIVE Pipelines

Answer: B

Question 2

When you drop a managed table using SQL syntax DROP TABLE table_name how does it impact metadata, history, and data stored in the table?

Options :

A : Drops table from meta store, drops metadata, history, and data in storage.

B : Drops table from meta store and data from storage but keeps metadata and history in storage

C : Drops table from meta store, meta data and history but keeps the data in storage

D : Drops table but keeps meta data, history and data in storage

E : Drops table and history but keeps meta data and data in storage

Answer: A

Question 3

What is the purpose of a gold layer in Multi-hop architecture?

Options :

A : Optimizes ETL throughput and analytic query performance

B : Eliminate duplicate records

C : Preserves grain of original data, without any aggregations

D : Data quality checks and schema enforcement

E : Powers ML applications, reporting, dashboards and adhoc reports.

Answer: A

Question 4

You had setup a new all-purpose cluster, but the cluster is unable to start which of the following steps do you need to take to resolve this issue?

Options :

A : Check the cluster driver logs

B : Check the cluster event logs

C : Workspace logs

D : Storage account

E : Data plane

Answer: B

Question 5

Which of the following python statement can be used to replace the schema name and table name in the query statement?

Options :

A : table_name = "sales"schema_name = "bronze"query = f”select * from schema_name.table_name”

B : table_name = "sales"schema_name = "bronze"query = "select * from {schema_name}.{table_name}"

C : table_name = "sales"schema_name = "bronze"query = f"select * from { schema_name}.{table_name}"

D : table_name = "sales"schema_name = "bronze"query = f"select * from + schema_name +"."+table_name"

Answer: C

Free Databricks-Certified-Associate-Data-Engineer Mock Exam – Practice Online Confidently

Buying Options: