- All Exams Instant Download
Which of the following data lakehouse features results in improved data quality over a traditional data lake?
Which of the following data lakehouse features results in improved data quality over a traditional data lake?A . A data lakehouse provides storage solutions for structured and unstructured data.B . A data lakehouse supports ACID-compliant transactions.C . A data lakehouse allows the use of SQL queries to examine data.D ....
Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?
Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?A . DROPB . IGNOREC . MERGED . APPENDE . INSERTView AnswerAnswer: C Explanation: The MERGE command can be used to upsert data from a source table, view, or...
Which of the following benefits is provided by the array functions from Spark SQL?
Which of the following benefits is provided by the array functions from Spark SQL?A . An ability to work with data in a variety of types at onceB . An ability to work with data within certain partitions and windowsC . An ability to work with time-related data in specified...
Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?
A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period is True. Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?A ....
In order for Structured Streaming to reliably track the exact progress of the processing so that it can handle any kind of failure by restarting and/or reprocessing, which of the following two approaches is used by Spark to record the offset range of the data being processed in each trigger?
In order for Structured Streaming to reliably track the exact progress of the processing so that it can handle any kind of failure by restarting and/or reprocessing, which of the following two approaches is used by Spark to record the offset range of the data being processed in each trigger?A...
Which of the following commands should be run to create a new table all_transactions that contains all records from march_transactions and april_transactions without duplicate records?
A data engineering team has two tables. The first table march_transactions is a collection of all retail transactions in the month of March. The second table april_transactions is a collection of all retail transactions in the month of April. There are no duplicate records between the tables. Which of the...
Which of the following commands could the data engineering team use to access sales in PySpark?
A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than...
Which of the following describes the storage organization of a Delta table?
Which of the following describes the storage organization of a Delta table?A . Delta tables are stored in a single file that contains data, history, metadata, and other attributes.B . Delta tables store their data in a single file and all metadata in a collection of files in a separate...
Which of the following approaches could be used by the data engineering team to complete this task?
A data analyst has a series of queries in a SQL program. The data analyst wants this program to run every day. They only want the final query in the program to run on Sundays. They ask for help from the data engineering team to complete this task. Which of...
Assuming previously unprocessed data exists and all definitions are valid, what is the expected outcome after clicking Start to update the pipeline?
A Delta Live Table pipeline includes two datasets defined using STREAMING LIVE TABLE. Three datasets are defined against Delta Lake table sources using LIVE TABLE. The table is configured to run in Production mode using the Continuous Pipeline Mode. Assuming previously unprocessed data exists and all definitions are valid, what...
