A data architect is designing a data model that works for both video-based machine learning work-loads and
highly audited batch ETL/ELT workloads.
Which of the following describes how using a data lakehouse can help the data architect meet the needs of
both workloads?

• A.A data lakehouse combines compute and storage for simple governance
• B.A data lakehouse fully exists in the cloud
• C.A data lakehouse provides autoscaling for compute clusters
• D.A data lakehouse stores unstructured data and is ACID-compliant
• E.A data lakehouse requires very little data modeling

Comment: *

Name: *

Email: *

Verification: *

A data engineer has set up two Jobs that each run nightly. The first Job starts at 12:00 AM, and it usually
completes in about 20 minutes. The second Job depends on the first Job, and it starts at 12:30 AM. Sometimes,
the second Job fails when the first Job does not complete by 12:30 AM.
Which of the following approaches can the data engineer use to avoid this problem?

• A.They can set up the data to stream from the first Job to the second Job
• B.They can use cluster pools to help the Jobs run more efficiently
• C.They can limit the size of the output in the second Job so that it will not fail as easily
• D.They can set up a retry policy on the first Job to help it run more quickly
• E.They can utilize multiple tasks in a single job with a linear dependency

Comment: *

Name: *

Email: *

Verification: *

Kevin is the owner of the schema sales, Steve wanted to create new table in sales schema called regional_sales so Kevin grants the create table permissions to Steve. Steve creates the new table called regional_sales in sales schema, who is the owner of the table regional_sales

• A.Kevin is the owner of sales schema, all the tables in the schema will be owned by Kevin
• B.Steve is the owner of the table
• C.By default ownership is assigned DBO
• D.By default ownership is assigned to DEFAULT_OWNER
• E.Kevin and Smith both are owners of table

Comment: *

Name: *

Email: *

Verification: *

A data engineer wants to horizontally combine two tables as a part of a query. They want to use a shared
column as a key column, and they only want the query result to contain rows whose value in the key column is
present in both tables.
Which of the following SQL commands can they use to accomplish this task?

• A.OUTER JOIN
• B.INNER JOIN
• C.MERGE
• D.UNION
• E.LEFT JOIN

Comment: *

Name: *

Email: *

Verification: *

You are looking to process the data based on two variables, one to check if the department is supply chain or check if process flag is set to True

• A.if department == "supply chain" or process:
• B.if department == "supply chain" or process = TRUE:
• C.if department == "supply chain" | process == TRUE:
• D.if department == "supply chain" | if process == TRUE:
• E.if department = "supply chain" | process:

Comment: *

Name: *

Email: *

Verification: *