[Q59-Q73] Positive Aspects of ValidExamDumps Databricks-Certified-Professional-Data-Engineer Exam Dumps! [Mar-2023]

4.2/5 - (5 votes)

Positive Aspects of Valid Dumps Databricks-Certified-Professional-Data-Engineer Exam Dumps! [Mar-2023]

First Attempt Guaranteed Success in Databricks-Certified-Professional-Data-Engineer Exam 2023

Q59. Once a cluster is deleted, below additional actions need to performed by the administrator

Remove virtual machines but storage and networking are automatically dropped

Drop storage disks but Virtual machines and networking are automatically dropped

Remove networking but Virtual machines and storage disks are automatically dropped

Remove logs

No action needs to be performed. All resources are automatically removed.

Q60. 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

Kevin is the owner of sales schema, all the tables in the schema will be owned by Kevin

Steve is the owner of the table

By default ownership is assigned DBO

By default ownership is assigned to DEFAULT_OWNER

Kevin and Smith both are owners of table

Q61. You are currently working to ingest millions of files that get uploaded to the cloud object storage for consumption, and you are asked to build a process to ingest this data, the schema of the file is expected to change over time, and the ingestion process should be able to handle these changes automatically. Which of the following method can be used to ingest the data incrementally?

AUTO APPEND

AUTO LOADER

COPY INTO

Structured Streaming

Checkpoint

Q62. A notebook accepts an input parameter that is assigned to a python variable called department and this is an optional parameter to the notebook, you are looking to control the flow of the code using this parameter. you have to check department variable is present then execute the code and if no department value is passed then skip the code execution. How do you achieve this using python?

1.if department is not None:
2. #Execute code
3.else:
4. pass
(Correct)

1.if (department is not None)
2. #Execute code
3.else
4. pass

1.if department is not None:
2. #Execute code
3.end:
4. pass

1.if department is not None:
2. #Execute code
3.then:
4. pass

1.if department is None:
2. #Execute code
3.else:
4. pass

Q63. A data engineer has ingested a JSON file into a table raw_table with the following schema:
1.transaction_id STRING,
2.payload ARRAY<customer_id:STRING, date:TIMESTAMP, store_id:STRING>
The data engineer wants to efficiently extract the date of each transaction into a table with the fol-lowing
schema:
1.transaction_id STRING,
2.date TIMESTAMP
Which of the following commands should the data engineer run to complete this task?

1.SELECT transaction_id, date from payload
2.FROM raw_table;

1.SELECT transaction_id, explode(payload)
2.FROM raw_table;

1.SELECT transaction_id, payload[date]
2.FROM raw_table;

1.SELECT transaction_id, date
2.FROM raw_table;

1.SELECT transaction_id, payload.date
2.FROM raw_table;

Q64. One of the team members Steve who has the ability to create views, created a new view called re-gional_sales_vw on the existing table called sales which is owned by John, and the second team member Kevin who works with regional sales managers wanted to query the data in region-al_sales_vw, so Steve granted the permission to Kevin using command GRANT VIEW, USAGE ON regional_sales_vw to [email protected] but Kevin is still unable to access the view?

Kevin needs select access on the table sales

Kevin needs owner access on the view regional_sales_vw

Steve is not the owner of the sales table

Kevin is not the owner of the sales table

Table access control is not enabled on the table and view

Q65. A DELTA LIVE TABLE pipelines can be scheduled to run in two different modes, what are these two different modes?

Triggered, Incremental

Once, Continuous

Triggered, Continuous

Once, Incremental

Continuous, Incremental

Q66. A new data engineer [email protected] has been assigned to an ELT project. The new data
engineer 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 table to the new data engineer?

1. GRANT ALL PRIVILEGES ON TABLE [email protected] TO sales;

1. GRANT SELECT ON TABLE sales TO [email protected];

1. GRANT ALL PRIVILEGES ON TABLE sales TO [email protected];

1. GRANT USAGE ON TABLE sales TO [email protected];

1. GRANT SELECT CREATE MODIFY ON TABLE sales TO [email protected];

Q67. Which method is used to solve for coefficients bO, b1, … bn in your linear regression model:

Apriori Algorithm

Ridge and Lasso

Ordinary Least squares

Integer programming

Q68. Which of the following describes a benefit of a data lakehouse that is unavailable in a traditional data
warehouse?

A data lakehouse couples storage and compute for complete control

A data lakehouse provides a relational system of data management

A data lakehouse utilizes proprietary storage formats for data

A data lakehouse enables both batch and streaming analytics

A data lakehouse captures snapshots of data for version control purposes

Q69. Which of the statements are correct about lakehouse?

Lakehouse only supports Machine learning workloads and Data warehouses support BI workloads

Lakehouse only supports end-to-end streaming workloads and Data warehouses support Batch workloads

Lakehouse does not support ACID

In Lakehouse Storage and compute are coupled

Lakehouse supports schema enforcement and evolution

Q70. Which of the following python statement can be used to replace the schema name and table name in the query statement?

1.table_name = “sales”
2.schema_name = “bronze”
3.query = f”select * from schema_name.table_name”

1.table_name = “sales”
2.schema_name = “bronze”
3.query = “select * from {schema_name}.{table_name}”

1.table_name = “sales”
2.schema_name = “bronze”
3.query = f”select * from { schema_name}.{table_name}”

1.table_name = “sales”
2.schema_name = “bronze”
3.query = f”select * from + schema_name +”.”+table_name”

Q71. What is the main difference between the bronze layer and silver layer in a medallion architecture?

Duplicates are removed in bronze, schema is applied in silver

Silver may contain aggregated data

Bronze is raw copy of ingested data, silver contains data with production schema and optimized for ELT/ETL throughput

Bad data is filtered in Bronze, silver is a copy of bronze data

Q72. A data engineer wants to create a relational object by pulling data from two tables. The relational object must
be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to
avoid copying and storing physical data.
Which of the following relational objects should the data engineer create?

Delta Table

View

Temporary view

Spark SQL Table

Database

Q73. What is the purpose of the silver layer in a Multi hop architecture?

Replaces a traditional data lake

Efficient storage and querying of full, unprocessed history of data

Eliminates duplicate data, quarantines bad data

Refined views with aggregated data

Optimized query performance for business-critical data