- All Exams Instant Download
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...
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...
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...
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...
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...
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...
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:...
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...
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 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:...
