Free CERTIFIED-DATA-ENGINEER-ASSOCIATE – Databricks CERTIFIED-DATA-ENGINEER-ASSOCIATE Practice Test Question

Select an option, then click Submit answer.

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

Select an option, then click Submit answer.

• ○ GRANT VIEW ON CATALOG customers TO team;
• ○ GRANT CREATE ON DATABASE customers TO team;
• ○ GRANT USAGE ON CATALOG team TO customers;
• ○ GRANT CREATE ON DATABASE team TO customers;
• ○ GRANT USAGE ON DATABASE customers TO team;

Select an option, then click Submit answer.

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

Select an option, then click Submit answer.

• ○ Manually programming in an alert system in each cell of the Notebook
• ○ Setting up an Alert in the Job page
• ○ Setting up an Alert in the Notebook
• ○ There is no way to notify the Job owner in the case of Job failure
• ○ MLflow Model Registry Webhooks

Select an option, then click Submit answer.

• ○ FROM "path/to/csv"
• ○ USING CSV
• ○ FROM CSV
• ○ USING DELTA

Select an option, then click Submit answer.

• ○ trigger("5 seconds")
• ○ trigger(continuous="5 seconds")
• ○ trigger(once="5 seconds")
• ○ trigger(processingTime="5 seconds")

Select an option, then click Submit answer.

• ○ Gold tables are more likely to contain aggregations than Silver tables.
• ○ Gold tables are more likely to contain valuable data than Silver tables.
• ○ Gold tables are more likely to contain a less refined view of data than Silver tables.
• ○ Gold tables are more likely to contain truthful data than Silver tables.

Select an option, then click Submit answer.

• ○ Auto Loader cannot infer the schema of ingested data
• ○ JSON data is a text-based format
• ○ Auto Loader only works with string data
• ○ All of the fields had at least one null value

Select an option, then click Submit answer.

• ○

  

• ○

  

• ○

  

• ○

  

Select an option, then click Submit answer.

• ○ They can use endpoints available in Databricks SQL
• ○ They can use jobs clusters instead of all-purpose clusters
• ○ They can configure the clusters to autoscale for larger data sizes
• ○ They can use clusters that are from a cluster pool

Select an option, then click Submit answer.

• ○ They can set a limit to the number of DBUs that are consumed by the SQL Endpoint.
• ○ They can set the query’s refresh schedule to end after a certain number of refreshes.
• ○ They can set the query’s refresh schedule to end on a certain date in the query scheduler.
• ○ They can set a limit to the number of individuals that are able to manage the query’s refresh schedule.

Select an option, then click Submit answer.

• ○ resources: jobs: hello-job: name: hello-job tasks: - task_key: hello-task existing_cluster_id: 1234-567890-abcde123 notebook_task: notebook_path: ./hello.py
• ○ "resources":{ "jobs":{ "name":"hello-job", "tasks":{ "task_key:"hello-task", "existing_cluster_id":"1234-567890-abcde123", "notebook_task":{ "notebook_path": ".hello.py" } } }
• ○ configuration = { "resources":{ "jobs":{ "name":"hello-job", "tasks":{ "task_key:"hello-task", "existing_cluster_id":"1234-567890-abcde123", "notebook_task":{ "notebook_path": ".hello.py" } } } }
• ○ resources { jobs { name = "hello-job" tasks{ task_key = "hello-task" existing_cluster_id = "1234-567890-abcde123" notebook_task{ notebook_path = ".hello.py" } } } }

Select an option, then click Submit answer.

• ○ Delta Lake
• ○ Data lake
• ○ Data warehouse
• ○ Data lakehouse

Select an option, then click Submit answer.

• ○ They can schedule the query to refresh every 1 day from the SQL endpoint's page in Databricks SQL.
• ○ They can schedule the query to refresh every 12 hours from the SQL endpoint's page in Databricks SQL.
• ○ They can schedule the query to refresh every 1 day from the query's page in Databricks SQL.
• ○ They can schedule the query to run every 12 hours from the Jobs UI.

Select an option, then click Submit answer.

• ○ Commit
• ○ Pull
• ○ Merge
• ○ Clone

Select an option, then click Submit answer.

• ○ Both teams would respond more quickly to ad-hoc requests
• ○ Both teams would use the same source of truth for their work
• ○ Both teams would reorganize to report to the same department
• ○ Both teams would be able to collaborate on projects in real-time

Select an option, then click Submit answer.

• ○ Databricks web application
• ○ Cluster management metadata
• ○ Notebooks
• ○ Data