You are asked to setup an AUTO LOADER to process the incoming data, this data arrives in JSON format and get dropped into cloud object storage and you are required to process the data as soon as it arrives in cloud storage, which of the following statements is correct

You are asked to setup an AUTO LOADER to process the incoming data, this data arrives in JSON format and get dropped into cloud object storage and you are required to process the data as soon as it arrives in cloud storage, which of the following statements is correctA ....

March 15, 2023 No Comments READ MORE +

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 branches B. Databricks Repos can merge changes from a secondary Git branch into a main Git branch C....

March 15, 2023 No Comments READ MORE +

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 branches B. Databricks Repos can merge changes from a secondary Git branch into a main Git branch C....

March 15, 2023 No Comments READ MORE +

What is the purpose of a silver layer in Multi hop architecture?

What is the purpose of a silver layer in Multi hop architecture?A . Replaces a traditional data lake B. Efficient storage and querying of full and unprocessed history of data C. A schema is enforced, with data quality checks. D. Refined views with aggregated data E. Optimized query performance for...

March 15, 2023 No Comments READ MORE +

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...

March 15, 2023 No Comments READ MORE +

What is the best way to query external csv files located on DBFS Storage to inspect the data using SQL?

What is the best way to query external csv files located on DBFS Storage to inspect the data using SQL?A . SELECT * FROM 'dbfs:/location/csv_files/' FORMAT = 'CSV' B. SELECT CSV. * from 'dbfs:/location/csv_files/' C. SELECT * FROM CSV. 'dbfs:/location/csv_files/' D. You can not query external files directly, us COPY...

March 15, 2023 No Comments READ MORE +

What is the main difference between the silver layer and the gold layer in medallion architecture?

What is the main difference between the silver layer and the gold layer in medallion architecture?A . Silver may contain aggregated data B. Gold may contain aggregated data C. Data quality checks are applied in gold D. Silver is a copy of bronze data E. God is a copy of...

March 15, 2023 No Comments READ MORE +

Which of the following statements are true about a lakehouse?

Which of the following statements are true about a lakehouse?A . Lakehouse only supports Machine learning workloads and Data warehouses support BI workloads B. Lakehouse only supports end-to-end streaming workloads and Data warehouses support Batch workloads C. Lakehouse does not support ACID D. Lakehouse do not support SQL E. Lakehouse...

March 15, 2023 No Comments READ MORE +

What is the main difference between the silver layer and the gold layer in medallion architecture?

What is the main difference between the silver layer and the gold layer in medallion architecture?A . Silver may contain aggregated data B. Gold may contain aggregated data C. Data quality checks are applied in gold D. Silver is a copy of bronze data E. God is a copy of...

March 15, 2023 No Comments READ MORE +

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_name B. COPY INTO table_name C. UPDATE table_name D. INSERT INTO OVERWRITE table_name E. INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...

March 15, 2023 No Comments READ MORE +