- All Exams Instant Download
as total_sales from sales
as total_sales from salesView AnswerAnswer: C Explanation: The answer is
table("uncleanedSales")
table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is
You noticed that colleague is manually copying the notebook with _bkp to store the previous versions, which of the following feature would you recommend instead.
You noticed that colleague is manually copying the notebook with _bkp to store the previous versions, which of the following feature would you recommend instead.A . Databricks notebooks support change tracking and versioning B. Databricks notebooks should be copied to a local machine and setup source control locally to version...
as total_sales from sales
as total_sales from salesView AnswerAnswer: C Explanation: The answer is
How to determine if a table is a managed table vs external table?
How to determine if a table is a managed table vs external table?A . Run IS_MANAGED(‘table_name’) function B. All external tables are stored in data lake, managed tables are stored in DELTA lake C. All managed tables are stored in unity catalog D. Run SQL command DESCRIBE EXTENDED table_name and...
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?
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?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...
Which of the following data workloads will utilize a Bronze table as its destination?
Which of the following data workloads will utilize a Bronze table as its destination?A . A job that aggregates cleaned data to create standard summary statistics B. A job that queries aggregated data to publish key insights into a dashboard C. A job that ingests raw data from a streaming...
Which of the following approaches can enable the data engineering team to be notified if the ELT job has not been run in an hour?
A data engineer is using a Databricks SQL query to monitor the performance of an ELT job. The ELT job is triggered by a specific number of input records being ready to process. The Databricks SQL query returns the number of minutes since the job’s most recent runtime. Which of...
Which of the following approaches can enable the data engineering team to be notified if the ELT job has not been run in an hour?
A data engineer is using a Databricks SQL query to monitor the performance of an ELT job. The ELT job is triggered by a specific number of input records being ready to process. The Databricks SQL query returns the number of minutes since the job’s most recent runtime. Which of...
You are noticing job cluster is taking 6 to 8 mins to start which is delaying your job to finish on time, what steps you can take to reduce the amount of time cluster startup time
You are noticing job cluster is taking 6 to 8 mins to start which is delaying your job to finish on time, what steps you can take to reduce the amount of time cluster startup timeA . Setup a second job ahead of first job to start the cluster, so...
