Question 1

Your colleague was walking you through how a job was setup, but you noticed a warning message that said, “Jobs running on all-purpose cluster are considered all purpose compute", the colleague was not sure why he was getting the warning message, how do you best explain this warning message?

Options :

A : All-purpose clusters cannot be used for Job clusters, due to performance issues.

B : All-purpose clusters take longer to start the cluster vs a job cluster

C : All-purpose clusters are less expensive than the job clusters

D : All-purpose clusters are more expensive than the job clusters

E : All-purpose cluster provide interactive messages that can not be viewed in a job

Answer: D

Question 2

When investigating a data issue, if you are looking compare the current version of the data with the previous version, what is the best way to query historical data?

Options :

A : SELECT * FROM TIME_TRAVEL(table_name) where time_stamp = 'timestamp'

B : TIME_TRAVEL FROM table_name where time_stamp = 'timestamp'

C : SELECT * FROM table_name as of 'timestamp'

D : DISCRIBE HISTORY table_name as of 'timestmap'

E : SHOW HISTORY table_name as of 'timestmap'

Answer: C

Question 3

You had AUTO LOADER to process millions of files a day and noticed slowness in load process, so you scaled up the Databricks cluster but realized the performance of the Auto loader is still not improving, what is the best way to resolve this.

Options :

A : AUTO LOADER is not suitable to process millions of files a day

B : Setup a second AUTO LOADER process to process the data

C : Increase the maxFilesPerTrigger option to a sufficiently high number

D :

Copy the data from cloud storage to local disk on the cluster for faster access

E : Merge files to one large file

Answer: C

Question 4

You were asked to create a table that can store the below data, note that orderDate is the truncated date format of OrderTime, fill in the blank to complete the DDL. 2022-07-06-16-41-20-9e89d31650240d1b2e8d70a6bcae78b0 CREATE TABLE orders ( orderId int, orderTime timestamp, orderdate date _____________________________________________ , units int)

Options :

A : AS DEFAULT (CAST(orderTime as DATE))

B : GENERATED ALWAYS AS (CAST(orderTime as DATE))

C : GENERATED DEFAULT AS (CAST(orderTime as DATE))

D : AS (CAST(orderTime as DATE))

E : Delta lake does not support calculated columns, value should be inserted into the table as part of the ingestion process

Answer: B

Question 5

Which of the following can be used to simplify and unify siloed data architectures that are specialized for specific use cases?

Options :

A : None of these

B : Data lake

C : Data warehouse

D : All of these

E : Data lakehouse

Answer: E

Confidently Practice Online with Free Databricks-Certified-Associate-Data-Engineer Exam Cram

Buying Options: