Which of the following data workloads will utilize a Gold table as its source?

• A.A job that cleans data by removing malformatted records
• B.A job that aggregates uncleaned data to create standard summary statistics
• C.A job that ingests raw data from a streaming source into the Lakehouse
• D.A job that enriches data by parsing its timestamps into a human-readable format
• E.A job that queries aggregated data designed to feed into a dashboard

Comment: *

Name: *

Email: *

Verification: *

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 allows the use of SQL queries to examine data.
• D.A data lakehouse stores data in open formats.
• E.A data lakehouse enables machine learning and artificial Intelligence workloads.

Comment: *

Name: *

Email: *

Verification: *

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?

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

Comment: *

Name: *

Email: *

Verification: *

A data engineer needs to create a table in Databricks using data from their organization's existing SQLite database.
They run the following command:

Which of the following lines of code fills in the above blank to successfully complete the task?

• A.org.apache.spark.sql.jdbc
• B.autoloader
• C.DELTA
• D.sqlite
• E.org.apache.spark.sql.sqlite

Comment: *

Name: *

Email: *

Verification: *

A data engineer has developed a data pipeline to ingest data from a JSON source using Auto Loader, but the engineer has not provided any type inference or schema hints in their pipeline. Upon reviewing the data, the data engineer has noticed that all of the columns in the target table are of the string type despite some of the fields only including float or boolean values.
Which of the following describes why Auto Loader inferred all of the columns to be of the string type?

• A.There was a type mismatch between the specific schema and the inferred schema
• B.JSON data is a text-based format
• C.Auto Loader only works with string data
• D.All of the fields had at least one null value
• E.Auto Loader cannot infer the schema of ingested data

Comment: *

Name: *

Email: *

Verification: *