Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Databricks Certified Data Engineer Professional

Databricks Certified Data Engineer Professional Exam Practice Questions (P. 5)

  • Full Access (327 questions)
  • One Year of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #41
The DevOps team has configured a production workload as a collection of notebooks scheduled to run daily using the Jobs UI. A new data engineering hire is onboarding to the team and has requested access to one of these notebooks to review the production logic.
What are the maximum notebook permissions that can be granted to the user without allowing accidental changes to production code or data?
  1. A
    Can Manage
  2. B
    Can Edit
  3. C
    No permissions
  4. D
    Can Read
  5. E
    Can Run

Correct Answer:
D

Question #42
A table named user_ltv is being used to create a view that will be used by data analysts on various teams. Users in the workspace are configured into groups, which are used for setting up data access using ACLs.
The user_ltv table has the following schema:
email STRING, age INT, ltv INT
The following view definition is executed:

An analyst who is not a member of the marketing group executes the following query:

SELECT * FROM email_ltv -
Which statement describes the results returned by this query?
  1. A
    Three columns will be returned, but one column will be named "REDACTED" and contain only null values.
  2. B
    Only the email and ltv columns will be returned; the email column will contain all null values.
  3. C
    The email and ltv columns will be returned with the values in user_ltv.
  4. D
    The email.age, and ltv columns will be returned with the values in user_ltv.
  5. E
    Only the email and ltv columns will be returned; the email column will contain the string "REDACTED" in each row.

Correct Answer:
E

Question #43
The data governance team has instituted a requirement that all tables containing Personal Identifiable Information (PH) must be clearly annotated. This includes adding column comments, table comments, and setting the custom table property "contains_pii" = true.
The following SQL DDL statement is executed to create a new table:

Which command allows manual confirmation that these three requirements have been met?
  1. A
    DESCRIBE EXTENDED dev.pii_test
  2. B
    DESCRIBE DETAIL dev.pii_test
  3. C
    SHOW TBLPROPERTIES dev.pii_test
  4. D
    DESCRIBE HISTORY dev.pii_test
  5. E
    SHOW TABLES dev

Correct Answer:
A

Question #44
The data governance team is reviewing code used for deleting records for compliance with GDPR. They note the following logic is used to delete records from the Delta Lake table named users.

Assuming that user_id is a unique identifying key and that delete_requests contains all users that have requested deletion, which statement describes whether successfully executing the above logic guarantees that the records to be deleted are no longer accessible and why?
  1. A
    Yes; Delta Lake ACID guarantees provide assurance that the DELETE command succeeded fully and permanently purged these records.
  2. B
    No; the Delta cache may return records from previous versions of the table until the cluster is restarted.
  3. C
    Yes; the Delta cache immediately updates to reflect the latest data files recorded to disk.
  4. D
    No; the Delta Lake DELETE command only provides ACID guarantees when combined with the MERGE INTO command.
  5. E
    No; files containing deleted records may still be accessible with time travel until a VACUUM command is used to remove invalidated data files.

Correct Answer:
E

Question #45
An external object storage container has been mounted to the location /mnt/finance_eda_bucket.
The following logic was executed to create a database for the finance team:

After the database was successfully created and permissions configured, a member of the finance team runs the following code:

If all users on the finance team are members of the finance group, which statement describes how the tx_sales table will be created?
  1. A
    A logical table will persist the query plan to the Hive Metastore in the Databricks control plane.
  2. B
    An external table will be created in the storage container mounted to /mnt/finance_eda_bucket.
  3. C
    A logical table will persist the physical plan to the Hive Metastore in the Databricks control plane.
  4. D
    An managed table will be created in the storage container mounted to /mnt/finance_eda_bucket.
  5. E
    A managed table will be created in the DBFS root storage container.

Correct Answer:
D

Question #46
Although the Databricks Utilities Secrets module provides tools to store sensitive credentials and avoid accidentally displaying them in plain text users should still be careful with which credentials are stored here and which users have access to using these secrets.
Which statement describes a limitation of Databricks Secrets?
  1. A
    Because the SHA256 hash is used to obfuscate stored secrets, reversing this hash will display the value in plain text.
  2. B
    Account administrators can see all secrets in plain text by logging on to the Databricks Accounts console.
  3. C
    Secrets are stored in an administrators-only table within the Hive Metastore; database administrators have permission to query this table by default.
  4. D
    Iterating through a stored secret and printing each character will display secret contents in plain text.
  5. E
    The Databricks REST API can be used to list secrets in plain text if the personal access token has proper credentials.

Correct Answer:
D

Question #47
What statement is true regarding the retention of job run history?
  1. A
    It is retained until you export or delete job run logs
  2. B
    It is retained for 30 days, during which time you can deliver job run logs to DBFS or S3
  3. C
    It is retained for 60 days, during which you can export notebook run results to HTML
  4. D
    It is retained for 60 days, after which logs are archived
  5. E
    It is retained for 90 days or until the run-id is re-used through custom run configuration

Correct Answer:
C

Question #48
A data engineer, User A, has promoted a new pipeline to production by using the REST API to programmatically create several jobs. A DevOps engineer, User B, has configured an external orchestration tool to trigger job runs through the REST API. Both users authorized the REST API calls using their personal access tokens.
Which statement describes the contents of the workspace audit logs concerning these events?
  1. A
    Because the REST API was used for job creation and triggering runs, a Service Principal will be automatically used to identify these events.
  2. B
    Because User B last configured the jobs, their identity will be associated with both the job creation events and the job run events.
  3. C
    Because these events are managed separately, User A will have their identity associated with the job creation events and User B will have their identity associated with the job run events.
  4. D
    Because the REST API was used for job creation and triggering runs, user identity will not be captured in the audit logs.
  5. E
    Because User A created the jobs, their identity will be associated with both the job creation events and the job run events.

Correct Answer:
C

Question #49
A user new to Databricks is trying to troubleshoot long execution times for some pipeline logic they are working on. Presently, the user is executing code cell-by-cell, using display() calls to confirm code is producing the logically correct results as new transformations are added to an operation. To get a measure of average time to execute, the user is running each cell multiple times interactively.
Which of the following adjustments will get a more accurate measure of how code is likely to perform in production?
  1. A
    Scala is the only language that can be accurately tested using interactive notebooks; because the best performance is achieved by using Scala code compiled to JARs, all PySpark and Spark SQL logic should be refactored.
  2. B
    The only way to meaningfully troubleshoot code execution times in development notebooks Is to use production-sized data and production-sized clusters with Run All execution.
  3. C
    Production code development should only be done using an IDE; executing code against a local build of open source Spark and Delta Lake will provide the most accurate benchmarks for how code will perform in production.
  4. D
    Calling display() forces a job to trigger, while many transformations will only add to the logical query plan; because of caching, repeated execution of the same logic does not provide meaningful results.
  5. E
    The Jobs UI should be leveraged to occasionally run the notebook as a job and track execution time during incremental code development because Photon can only be enabled on clusters launched for scheduled jobs.

Correct Answer: D ?️

Question #50
A production cluster has 3 executor nodes and uses the same virtual machine type for the driver and executor.
When evaluating the Ganglia Metrics for this cluster, which indicator would signal a bottleneck caused by code executing on the driver?
  1. A
    The five Minute Load Average remains consistent/flat
  2. B
    Bytes Received never exceeds 80 million bytes per second
  3. C
    Total Disk Space remains constant
  4. D
    Network I/O never spikes
  5. E
    Overall cluster CPU utilization is around 25%

Correct Answer: E ?️

Previous Questions Next Questions

All Pages