A data engineer has created a new database using the following command:
CREATE DATABASE IF NOT EXISTS customer360;
In which of the following locations will the customer360 database be located?

• A.dbfs:/user/hive/database/customer360
• B.dbfs:/user/hive/warehouse
• C.dbfs:/user/hive/customer360
• D.More information is needed to determine the correct response

Comment: *

Name: *

Email: *

Verification: *

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 Development mode using the Continuous Pipeline Mode.
Assuming previously unprocessed data exists and all definitions are valid, what is the expected outcome after clicking Start to update the pipeline?

• A.All datasets will be updated once and the pipeline will shut down. The compute resources will be terminated.
• B.All datasets will be updated at set intervals until the pipeline is shut down. The compute resources will persist until the pipeline is shut down.
• C.All datasets will be updated once and the pipeline will persist without any processing. The compute resources will persist but go unused.
• D.All datasets will be updated once and the pipeline will shut down. The compute resources will persist to allow for additional testing.
• E.All datasets will be updated at set intervals until the pipeline is shut down. The compute resources will persist to allow for additional testing.

Comment: *

Name: *

Email: *

Verification: *

In which of the following scenarios should a data engineer use the MERGE INTO command instead of the INSERT INTO command?

• A.When the location of the data needs to be changed
• B.When the target table is an external table
• C.When the source table can be deleted
• D.When the target table cannot contain duplicate records
• E.When the source is not a Delta table

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands will return the location of database customer360?

• A.DESCRIBE LOCATION customer360;
• B.DROP DATABASE customer360;
• C.DESCRIBE DATABASE customer360;
• D.ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};
• E.USE DATABASE customer360;

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes a benefit of creating an external table from Parquet rather than CSV when using a CREATE TABLE AS SELECT statement?

• A.Parquet files can be partitioned
• B.CREATE TABLE AS SELECT statements cannot be used on files
• C.Parquet files have a well-defined schema
• D.Parquet files have the ability to be optimized
• E.Parquet files will become Delta tables

Comment: *

Name: *

Email: *

Verification: *