- All Exams Instant Download
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 storage B. Efficiently move data incrementally from one delta table to another delta table C. Incrementally process new data from streaming data sources like Kafka into delta lake D....
How would you approach resolving this issue?
A SQL Dashboard was built for the supply chain team to monitor the inventory and product orders, but all of the timestamps displayed on the dashboards are showing in UTC format, so they requested to change the time zone to the location of New York. How would you approach resolving...
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...
Which of the following statements are correct on how Delta Lake implements a lake house?
Which of the following statements are correct on how Delta Lake implements a lake house?A . Delta lake uses a proprietary format to write data, optimized for cloud storage B. Using Apache Hadoop on cloud object storage C. Delta lake always stores meta data in memory vs storage D. Delta...
When you drop an external DELTA table using the SQL Command DROP TABLE table_name, how does it impact metadata (delta log, history), and data stored in the storage?
When you drop an external DELTA table using the SQL Command DROP TABLE table_name, how does it impact metadata (delta log, history), and data stored in the storage?A . Drops table from metastore, metadata (delta log, history) and data in storage B. Drops table from metastore, data but keeps metadata...
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...
What is the purpose of the silver layer in a Multi hop architecture?
What is the purpose of the silver layer in a Multi hop architecture?A . Replaces a traditional data lake B. Efficient storage and querying of full, unprocessed history of data C. Eliminates duplicate data, quarantines bad data D. Refined views with aggregated data E. Optimized query performance for business-critical dataView...
You are tasked to set up a set notebook as a job for six departments and each department can run the task parallelly, the notebook takes an input parameter dept number to process the data by department, how do you go about to setup this up in job?
You are tasked to set up a set notebook as a job for six departments and each department can run the task parallelly, the notebook takes an input parameter dept number to process the data by department, how do you go about to setup this up in job?A . Use...
Which of the following functions can be used to convert JSON string to Struct data type?
Which of the following functions can be used to convert JSON string to Struct data type?A . TO_STRUCT (json value) B. FROM_JSON (json value) C. FROM_JSON (json value, schema of json) D. CONVERT (json value, schema of json) E. CAST (json value as STRUCT)View AnswerAnswer: C Explanation: Syntax Copy
as total_sales from sales
as total_sales from salesView AnswerAnswer: C Explanation: The answer is
