A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team.
Which of the following commands can be used to grant the necessary permission on the entire database to the new team?

1. A. GRANT VIEW ON CATALOG customers TO team;
2. B. GRANT CREATE ON DATABASE customers TO team;
3. C. GRANT USAGE ON CATALOG team TO customers;
4. D. GRANT CREATE ON DATABASE team TO customers;
5. E. GRANT USAGE ON DATABASE customers TO team;

Correct Answer: E
The GRANT statement is used to grant privileges on a database, table, or view to a user or role. The ALL PRIVILEGES option grants all possible privileges on the specified object, such as CREATE, SELECT, MODIFY, and USAGE. The syntax of the GRANT statement is:
GRANT privilege_type ON object TO user_or_role;
Therefore, to grant full permissions on the database customers to the new data engineering team, the command should be:
GRANT ALL PRIVILEGES ON DATABASE customers TO team;

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 is the
expected outcome after clicking Start to update the pipeline?

1. A. All datasets will be updated at set intervals until the pipeline is shut dow
2. B. The compute resources will persist to allow for additional testing.
3. C. All datasets will be updated once and the pipeline will persist without any processin
4. D. The compute resources will persist but go unused.
5. E. All datasets will be updated at set intervals until the pipeline is shut dow
6. F. The compute resources will be deployed for the update and terminated when the pipeline is stopped.
7. G. All datasets will be updated once and the pipeline will shut dow
8. H. The compute resources will be terminated.
9. I. All datasets will be updated once and the pipeline will shut dow
10. J. The compute resources will persist to allow for additional testing.

Correct Answer: C
In a Delta Live Table pipeline running in Continuous Pipeline Mode, when you click Start to update the pipeline, the following outcome is expected: All datasets defined using STREAMING LIVE TABLE and LIVE TABLE against Delta Lake table sources will be updated at set intervals. The compute resources will be deployed for the update process and will be active during the execution of the pipeline. The compute resources will be terminated when the pipeline is stopped or shut down. This mode allows for continuous and periodic updates to the datasets as new data arrives or changes in the
underlying Delta Lake tables occur. The compute resources are provisioned and utilized during the update intervals to process the data and perform the necessary operations.

A data engineering team has noticed that their Databricks SQL queries are running too slowly when they are submitted to a non-running SQL endpoint. The data engineering team wants this issue to be resolved.
Which of the following approaches can the team use to reduce the time it takes to return results in this scenario?

1. A. They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to "Reliability Optimized."
2. B. They can turn on the Auto Stop feature for the SQL endpoint.
3. C. They can increase the cluster size of the SQL endpoint.
4. D. They can turn on the Serverless feature for the SQL endpoint.
5. E. They can increase the maximum bound of the SQL endpoint's scaling range

Correct Answer: C
https://www.databricks.com/blog/2022/03/10/top-5-databricks-performance- tips.html

Which of the following benefits of using the Databricks Lakehouse Platform is provided by Delta Lake?

1. A. The ability to manipulate the same data using a variety of languages
2. B. The ability to collaborate in real time on a single notebook
3. C. The ability to set up alerts for query failures
4. D. The ability to support batch and streaming workloads
5. E. The ability to distribute complex data operations

Correct Answer: D
Delta Lake is a key component of the Databricks Lakehouse Platform that provides several benefits, and one of the most significant benefits is its ability to support both batch and streaming workloads seamlessly. Delta Lake allows you to process and analyze data in real-time (streaming) as well as in batch, making it a versatile choice for various data processing needs. While the other options may be benefits or capabilities of Databricks or the Lakehouse Platform in general, they are not specifically associated with Delta Lake.

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

1. A. An ability to work with data in a variety of types at once
2. B. An ability to work with data within certain partitions and windows
3. C. An ability to work with time-related data in specified intervals
4. D. An ability to work with complex, nested data ingested from JSON files
5. E. An ability to work with an array of tables for procedural automation

Correct Answer: D
Array functions in Spark SQL are primarily used for working with arrays and complex, nested data structures, such as those often encountered when ingesting JSON files. These functions allow you to manipulate and query nested arrays and structures within your data, making it easier to extract and work with specific elements or values within complex data formats. While some of the other options (such as option A for working with different data types) are features of Spark SQL or SQL in general, array functions specifically excel at handling complex, nested data structures like those found in JSON files.