Question 1

Which of the following benefits is provided by the array functions from Spark SQL?

Options :

A : An ability to work with data in a variety of types at once

B : An ability to work with data within certain partitions and windows

C : An ability to work with time-related data in specified intervals

D : An ability to work with complex, nested data ingested from JSON files

E : An ability to work with an array of tables for procedural automation

Answer: B

Question 2

The data engineering team is looking to add a new column to the table, but the QA team would like to test the change which of the below options allow you to quickly copy the table from Prod to QA environment, modify and run the tests

Options :

A : DEEP CLONE

B : SHADOW CLONE

C :

ZERO COPY CLONE

D : SHALLOW CLONE

E : METADATA CLONE

Answer: D

Question 3

Which data lakehouse feature results in improved data quality over a traditional data lake?

Options :

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.

Answer: D

Question 4

Which of the following statements are incorrect about the lakehouse

Options :

A : Support end-to-end streaming and batch workloads

B : Supports ACID

C : Support for diverse data types that can store both structured and unstructured

D : Supports BI and Machine learning

E : Storage is coupled with Compute

Answer: E

Question 5

Data science team members are using a single cluster to perform data analysis, although cluster size was chosen to handle multiple users and auto-scaling was enabled, the team realized queries are still running slow, what would be the suggested fix for this?

Options :

A : Setup multiple clusters so each team member has their own cluster

B : Disable the auto-scaling feature

C : Use High concurrency mode instead of the standard mode

D : Increase the size of the driver node

Answer: C