Question 1

you are currently working on creating a spark stream process to read and write in for a one-time micro batch, and also rewrite the existing target table, fill in the blanks to complete the below command sucesfully.

spark.table("source_table")

.writeStream

.option("____", “dbfs:/location/silver")

.outputMode("____")

.trigger(Once=____)

.table("target_table")

Options :

A : checkpointlocation, complete, True

B : targetlocation, overwrite, True

C : checkpointlocation, True, overwrite

D : checkpointlocation, True, complete

E : checkpointlocation, overwrite, True

Answer: A

Question 2

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 3

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 4

At the end of the inventory process a file gets uploaded to the cloud object storage, you are asked to build a process to ingest data which of the following method can be used to ingest the data incrementally, schema of the file is expected to change overtime ingestion process should be able to handle these changes automatically. Below is the auto loader to command to load the data, fill in the blanks for successful execution of below code.

spark.readStream

.format("cloudfiles")

.option("_______",”csv)

.option("_______", ‘dbfs:/location/checkpoint/’)

.load(data_source)

.writeStream

.option("_______",’ dbfs:/location/checkpoint/’)

.option("_______", "true")

.table(table_name))

Options :

A : format, checkpointlocation, schemalocation, overwrite

B : cloudfiles.format, checkpointlocation, cloudfiles.schemalocation, overwrite

C : cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchema

D : cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, append

E : cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, overwrite

Answer: C

Question 5

You currently working with marketing team to setup a dashboard on ad campaign analysis, since the team is not sure how often the dashboard should refreshed they have decided to do a manual refresh on as needed basis. Which of the following steps can be taken to reduce the overall cost of the compute?

Options :

A : They can turn on the Serverless feature for the SQL endpoint.

B : They can decrease the maximum bound of the SQL endpoint’s scaling range.

C : They can decrease the cluster size of the SQL endpoint.

D : They can turn on the Auto Stop feature for the SQL endpoint.

E : They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy from “Reliability Optimized” to “Cost optimized”

Answer: D

Higher Test Marks with Free Online Databricks-Certified-Associate-Data-Engineer Exam Practice

Buying Options: