- All Exams Instant Download
Which of the following commands results in the successful creation of a view on top of the delta stream (stream on delta table)?
Which of the following commands results in the successful creation of a view on top of the delta stream (stream on delta table)?A . Spark.read.format("delta").table("sales").createOrReplaceTempView("streaming_vw")B . Spark.readStream.format("delta").table("sales").createOrReplaceTempView("streaming_vw ")C . Spark.read.format("delta").table("sales").mode("stream").createOrReplaceTempView("strea ming_vw")D . Spark.read.format("delta").table("sales").trigger("stream").createOrReplaceTempView("stre aming_vw")E . Spark.read.format("delta").stream("sales").createOrReplaceTempView("streaming_vw")F . You can not create a view on streaming data source.View AnswerAnswer: B Explanation:...
table("uncleanedSales")
table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is
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 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 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...
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...
as total_sales from sales
as total_sales from salesView AnswerAnswer: C Explanation: The answer is
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:...
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 scenarios is the best fit for AUTO LOADER?
Which of the following scenarios is the best fit for AUTO LOADER?A . Efficiently process new data incrementally from cloud object storageB . Efficiently move data incrementally from one delta table to another delta tableC . Incrementally process new data from streaming data sources like Kafka into delta lakeD ....
