Which of the following data lakehouse features results in improved data quality over a traditional data lake?

• A.A data lakehouse stores data in open formats.
• B.A data lakehouse allows the use of SQL queries to examine data.
• C.A data lakehouse provides storage solutions for structured and unstructured data.
• D.A data lakehouse supports ACID-compliant transactions.
• E.A data lakehouse enables machine learning and artificial Intelligence workloads.

Comment: *

Name: *

Email: *

Verification: *

A data engineer has realized that the data files associated with a Delta table are incredibly small. They want to compact the small files to form larger files to improve performance.
Which of the following keywords can be used to compact the small files?

• A.REDUCE
• B.OPTIMIZE
• C.COMPACTION
• D.REPARTITION
• E.VACUUM

Comment: *

Name: *

Email: *

Verification: *

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 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.CREATE TABLE all_transactions AS
  SELECT * FROM march_transactions
  INNER JOIN SELECT * FROM april_transactions;
• B.CREATE TABLE all_transactions AS
  SELECT * FROM march_transactions
  UNION SELECT * FROM april_transactions;
• C.CREATE TABLE all_transactions AS
  SELECT * FROM march_transactions
  OUTER JOIN SELECT * FROM april_transactions;
• D.CREATE TABLE all_transactions AS
  SELECT * FROM march_transactions
  INTERSECT SELECT * from april_transactions;
• E.CREATE TABLE all_transactions AS
  SELECT * FROM march_transactions
  MERGE SELECT * FROM april_transactions;

Comment: *

Name: *

Email: *

Verification: *

A data engineer is using the following code block as part of a batch ingestion pipeline to read from a composable table:

Which of the following changes needs to be made so this code block will work when the transactions table is a stream source?

• A.Replace predict with a stream-friendly prediction function
• B.Replace schema(schema) with option ("maxFilesPerTrigger", 1)
• C.Replace "transactions" with the path to the location of the Delta table
• D.Replace format("delta") with format("stream")
• E.Replace spark.read with spark.readStream

Comment: *

Name: *

Email: *

Verification: *

A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version, they are unable to restore the data because the data files have been deleted.
Which of the following explains why the data files are no longer present?

• A.The TIME TRAVEL command was run on the table
• B.The OPTIMIZE command was nun on the table
• C.The HISTORY command was run on the table
• D.The VACUUM command was run on the table
• E.The DELETE HISTORY command was run on the table

Comment: *

Name: *

Email: *

Verification: *