- All Exams Instant Download
The default threshold of VACUUM is 7 days, internal audit team asked to certain tables to maintain at least 365 days as part of compliance requirement, which of the below setting is needed to implement.
The default threshold of VACUUM is 7 days, internal audit team asked to certain tables to maintain at least 365 days as part of compliance requirement, which of the below setting is needed to implement.A . ALTER TABLE table_name set TBLPROPERTIES (del-ta.deletedFileRetentionDuration= ‘interval 365 days’)B . MODIFY TABLE table_name set...
as total_sales from sales
as total_sales from salesView AnswerAnswer: C Explanation: The answer is
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...
Identify one of the below statements that can query a delta table in PySpark Dataframe API
Identify one of the below statements that can query a delta table in PySpark Dataframe APIA . Spark.read.mode("delta").table("table_name")B . Spark.read.table.delta("table_name")C . Spark.read.table("table_name")D . Spark.read.format("delta").LoadTableAs("table_name")E . Spark.read.format("delta").TableAs("table_name")View AnswerAnswer: C
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 ....
If you create a database sample_db with the statement CREATE DATABASE sample_db what will be the default location of the database in DBFS?
If you create a database sample_db with the statement CREATE DATABASE sample_db what will be the default location of the database in DBFS?A . Default location, DBFS:/user/B . Default location, /user/db/C . Default Storage accountD . Statement fails “Unable to create database without location”E . Default Location, dbfs:/user/hive/warehouseView AnswerAnswer: E...
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 dataB . Gold may contain aggregated dataC . Data quality checks are applied in goldD . Silver is a copy of bronze dataE . God is a copy of...
Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to N
Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to NA . MODIFY transactions SET active_flag = 'N' WHERE active_flag = 'Y'B . MERGE transactions SET active_flag = 'N' WHERE active_flag = 'Y'C . UPDATE transactions...
You have written a notebook to generate a summary data set for reporting, Notebook was scheduled using the job cluster, but you realized it takes 8 minutes to start the cluster, what feature can be used to start the cluster in a timely fashion so your job can run immediatley?
You have written a notebook to generate a summary data set for reporting, Notebook was scheduled using the job cluster, but you realized it takes 8 minutes to start the cluster, what feature can be used to start the cluster in a timely fashion so your job can run immediatley?A...
