- All Exams Instant Download
How does Lakehouse replace the dependency on using Data lakes and Data warehouses in a Data and Analytics solution?
How does Lakehouse replace the dependency on using Data lakes and Data warehouses in a Data and Analytics solution?A . Open, direct access to data stored in standard data formats.B . Supports ACID transactions.C . Supports BI and Machine learning workloadsD . Support for end-to-end streaming and batch workloadsE ....
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...
Which of the following statements can be used to test the functionality of code to test number of rows in the table equal to 10 in python?
Which of the following statements can be used to test the functionality of code to test number of rows in the table equal to 10 in python? row_count = spark.sql("select count(*) from table").collect()[0][0]A . assert (row_count = 10, "Row count did not match")B . assert if (row_count = 10, "Row...
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...
John Smith is a newly joined team member in the Marketing team who currently has access read access to sales tables but does not have access to delete rows from the table, which of the following commands help you accomplish this?
John Smith is a newly joined team member in the Marketing team who currently has access read access to sales tables but does not have access to delete rows from the table, which of the following commands help you accomplish this?A . GRANT USAGE ON TABLE table_name TO [email protected] ....
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 SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?A . MERGE INTO table_nameB . COPY INTO table_nameC . UPDATE table_nameD . INSERT INTO OVERWRITE table_nameE . INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
Which of the following describes how Databricks Repos can help facilitate CI/CD workflows on the Databricks Lakehouse Platform?
Which of the following describes how Databricks Repos can help facilitate CI/CD workflows on the Databricks Lakehouse Platform?A . Databricks Repos can facilitate the pull request, review, and approval process before merging branchesB . Databricks Repos can merge changes from a secondary Git branch into a main Git branchC ....
What steps need to be taken to set up a DELTA LIVE PIPELINE as a job using the workspace UI?
What steps need to be taken to set up a DELTA LIVE PIPELINE as a job using the workspace UI?A . DELTA LIVE TABLES do not support job clusterB . Select Workflows UI and Delta live tables tab, under task type select Delta live tables pipeline and select the notebookC...
