Free Databricks-Certified-Professional-Data-Engineer Exam braindumps download (Databricks-Certified-Professional-Data-Engineer exam dumps Free)

QUESTION: 121

A Databricks SQL dashboard has been configured to monitor the total number of records present in a collection of Delta Lake tables using the following query pattern:

SELECT COUNT (*) FROM table

Which of the following describes how results are generated each time the dashboard is updated?

The total count of rows is calculated by scanning all data files
The total count of rows will be returned from cached results unless REFRESH is run
The total count of records is calculated from the Delta transaction logs
The total count of records is calculated from the parquet file metadata

Answer(s): C

Show Answer Next Question

QUESTION: 122

A Delta Lake table was created with the below query:

Consider the following query:

DROP TABLE prod.sales_by_store

If this statement is executed by a workspace admin, which result will occur?

Data will be marked as deleted but still recoverable with Time Travel.
The table will be removed from the catalog but the data will remain in storage.
The table will be removed from the catalog and the data will be deleted.
An error will occur because Delta Lake prevents the deletion of production data.

Answer(s): C

Show Answer Next Question

QUESTION: 123

A developer has successfully configured their credentials for Databricks Repos and cloned a remote Git repository. They do not have privileges to make changes to the main branch, which is the only branch currently visible in their workspace.

Which approach allows this user to share their code updates without the risk of overwriting the work of their teammates?

Use Repos to create a new branch, commit all changes, and push changes to the remote Git repository.
Use Repos to create a fork of the remote repository, commit all changes, and make a pull request on the source repository.
Use Repos to pull changes from the remote Git repository; commit and push changes to a branch that appeared as changes were pulled.
Use Repos to merge all differences and make a pull request back to the remote repository.

Answer(s): A

Reference:

Show Answer Next Question

QUESTION: 124

The security team is exploring whether or not the Databricks secrets module can be leveraged for connecting to an external database.

After testing the code with all Python variables being defined with strings, they upload the password to the secrets module and configure the correct permissions for the currently active user. They then modify their code to the following (leaving all other variables unchanged).

Which statement describes what will happen when the above code is executed?

The connection to the external table will succeed; the string "REDACTED" will be printed.
An interactive input box will appear in the notebook; if the right password is provided, the connection will succeed and the encoded password will be saved to DBFS.
An interactive input box will appear in the notebook; if the right password is provided, the connection will succeed and the password will be printed in plain text.
The connection to the external table will succeed; the string value of password will be printed in plain text.

Answer(s): A

Reference:

Show Answer Next Question

QUESTION: 125

The data science team has created and logged a production model using MLflow. The model accepts a list of column names and returns a new column of type DOUBLE.

The following code correctly imports the production model, loads the customers table containing the customer_id key column into a DataFrame, and defines the feature columns needed for the model.

Which code block will output a DataFrame with the schema "customer_id LONG, predictions DOUBLE"?

df.map(lambda x:model(x[columns])).select("customer_id, predictions")
df.select("customer_id",
model(*columns).alias("predictions"))
model.predict(df, columns)
df.apply(model, columns).select("customer_id, predictions")

Answer(s): B

Show Answer Next Question

QUESTION: 126

A junior member of the data engineering team is exploring the language interoperability of Databricks notebooks. The intended outcome of the below code is to register a view of all sales that occurred in countries on the continent of Africa that appear in the geo_lookup table.

Before executing the code, running SHOW TABLES on the current database indicates the database contains only two tables: geo_lookup and sales.

What will be the outcome of executing these command cells in order in an interactive notebook?

Both commands will succeed. Executing SHOW TABLES will show that countries_af and sales_af have been registered as views.
Cmd 1 will succeed. Cmd 2 will search all accessible databases for a table or view named countries_af:
if this entity exists, Cmd 2 will succeed.
Cmd 1 will succeed and Cmd 2 will fail. countries_af will be a Python variable representing a PySpark DataFrame.
Cmd 1 will succeed and Cmd 2 will fail. countries_af will be a Python variable containing a list of strings.

Answer(s): D

Show Answer Next Question

QUESTION: 127

The data science team has requested assistance in accelerating queries on free-form text from user reviews. The data is currently stored in Parquet with the below schema:

item_id INT, user_id INT, review_id INT, rating FLOAT, review STRING

The review column contains the full text of the review left by the user. Specifically, the data science team is looking to identify if any of 30 key words exist in this field.

A junior data engineer suggests converting this data to Delta Lake will improve query performance.

Which response to the junior data engineer's suggestion is correct?

Delta Lake statistics are not optimized for free text fields with high cardinality.
Delta Lake statistics are only collected on the first 4 columns in a table.
ZORDER ON review will need to be run to see performance gains.
The Delta log creates a term matrix for free text fields to support selective filtering.

Answer(s): A

Reference:

Show Answer Next Question

QUESTION: 128

The data engineering team has configured a job to process customer requests to be forgotten (have their data deleted). All user data that needs to be deleted is stored in Delta Lake tables using default table settings.

The team has decided to process all deletions from the previous week as a batch job at 1am each Sunday. The total duration of this job is less than one hour. Every Monday at 3am, a batch job executes a series of VACUUM commands on all Delta Lake tables throughout the organization.

The compliance officer has recently learned about Delta Lake's time travel functionality. They are concerned that this might allow continued access to deleted data.

Assuming all delete logic is correctly implemented, which statement correctly addresses this concern?

Because the VACUUM command permanently deletes all files containing deleted records, deleted records may be accessible with time travel for around 24 hours.
Because the default data retention threshold is 24 hours, data files containing deleted records will be retained until the VACUUM job is run the following day.
Because the default data retention threshold is 7 days, data files containing deleted records will be retained until the VACUUM job is run 8 days later.
Because Delta Lake's delete statements have ACID guarantees, deleted records will be permanently purged from all storage systems as soon as a delete job completes.

Answer(s): C

Reference:

Show Answer Next Question

Free Databricks-Certified-Professional-Data-Engineer Exam Braindumps Certified Data Engineer Professional Questions 121–128 (page: 17)

QUESTION: 121

QUESTION: 122

QUESTION: 123

Reference:

QUESTION: 124

Reference:

QUESTION: 125

QUESTION: 126

QUESTION: 127

Reference:

QUESTION: 128

Reference:

Free Databricks-Certified-Professional-Data-Engineer Exam Braindumps
Certified Data Engineer Professional Questions 121–128 (page: 17)