Databricks Certified Data Engineer Professional Sample Questions:
1. A data engineer wants to join a stream of advertisement impressions (when an ad was shown) with another stream of user clicks on advertisements to correlate when impression led to monitizable clicks.
Which solution would improve the performance?
A) 
B) 
C) 
D) 
2. A platform engineer needs to report the resource consumption, categorized by SKU tier, across all workspaces. The engineer decides to use the system.billing.usage system table to create a query. Which SQL query will accurately return the daily usage by product?
A) 
B) 
C) 
D) 
3. 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?
A) Text data cannot be stored with Delta Lake.
B) The Delta log creates a term matrix for free text fields to support selective filtering.
C) Delta Lake statistics are not optimized for free text fields with high cardinality.
D) Delta Lake statistics are only collected on the first 4 columns in a table.
E) ZORDER ON review will need to be run to see performance gains.
4. A Spark job is taking longer than expected. Using the Spark UI, a data engineer notes that the Min, Median, and Max Durations for tasks in a particular stage show the minimum and median time to complete a task as roughly the same, but the max duration for a task to be roughly 100 times as long as the minimum.
Which situation is causing increased duration of the overall job?
A) Spill resulting from attached volume storage being too small.
B) Credential validation errors while pulling data from an external system.
C) Network latency due to some cluster nodes being in different regions from the source data
D) Task queueing resulting from improper thread pool assignment.
E) Skew caused by more data being assigned to a subset of spark-partitions.
5. 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?
A) Use repos to create a fork of the remote repository commit all changes and make a pull request on the source repository
B) Use Repos to merge all differences and make a pull request back to the remote repository.
C) Use repos to merge all difference and make a pull request back to the remote repository.
D) Use Repos to pull changes from the remote Git repository; commit and push changes to a branch that appeared as changes were pulled.
E) Use Repos to create a new branch commit all changes and push changes to the remote Git repertory.
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: C | Question # 3 Answer: C | Question # 4 Answer: E | Question # 5 Answer: E |
1035 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
