A data engineer needs to process SQL queries on a large dataset with fluctuating workloads. The workload requires automatic scaling based on the volume of queries, without the need to manage or provision infrastructure. The solution should be cost-efficient and charge only for the compute resources used during query execution.
Which compute option should the data engineer use?

• A.Serverless SQL Warehouse
• B.Databricks SQL Analytics
• C.Databricks Runtime for ML
• D.Databricks Jobs

Comment: *

Name: *

Email: *

Verification: *

A new data engineering team team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to fully manage the project.
Which of the following commands can be used to grant full permissions on the database to the new data engineering team?

• A.GRANT ALL PRIVILEGES ON TABLE sales TO team;
• B.GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
• C.GRANT SELECT ON TABLE sales TO team;
• D.GRANT USAGE ON TABLE sales TO team;
• E.GRANT ALL PRIVILEGES ON TABLE team TO sales;

Comment: *

Name: *

Email: *

Verification: *

Which of the following is hosted completely in the control plane of the classic Databricks architecture?

• A.Databricks Filesystem
• B.Driver node
• C.Databricks web application
• D.Worker node
• E.JDBC data source

Comment: *

Name: *

Email: *

Verification: *

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

• 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

Comment: *

Name: *

Email: *

Verification: *

Which of the following is a benefit of the Databricks Lakehouse Platform embracing open source technologies?

• A.Cloud-specific integrations
• B.Simplified governance
• C.Ability to scale storage
• D.Ability to scale workloads
• E.Avoiding vendor lock-in

Comment: *

Name: *

Email: *

Verification: *