Join the discussion
Question 1/96
A data engineering team has been using a Databricks SQL query to monitor the performance of an ELT job.
The ELT job is triggered by a specific number of input records being ready to process. The Databricks SQL
query returns the number of minutes since the job's most recent runtime.
Which of the following approaches can enable the data engineering team to be notified if the ELT job has not
been run in an hour?
The ELT job is triggered by a specific number of input records being ready to process. The Databricks SQL
query returns the number of minutes since the job's most recent runtime.
Which of the following approaches can enable the data engineering team to be notified if the ELT job has not
been run in an hour?
Correct Answer: B
Add Comments
- Other Question (96q)
- Q1. A data engineering team has been using a Databricks SQL query to monitor the performance o...
- Q2. Identify one of the below statements that can query a delta table in PySpark Dataframe API...
- Q3. What are the different ways you can schedule a job in Databricks workspace?...
- Q4. A data engineering team has created a series of tables using Parquet data stored in an ext...
- Q5. Which of the following is true, when building a Databricks SQL dashboard?...
- Q6. The sales team has asked the Data engineering team to develop a dashboard that shows sales...
- Q7. Which of the below SQL commands creates a session scoped temporary view?...
- Q8. Which of the following results in the creation of an external table?...
- Q9. The data engineering team noticed that one of the job normally finishes in 15 mins but get...
- Q10. You have configured AUTO LOADER to process incoming IOT data from cloud object storage eve...
- Q11. The data engineering team is using a SQL query to review data completeness every day to mo...
- Q12. You have written a notebook to generate a summary data set for reporting, Notebook was sch...
- Q13. Which of the following features of data lakehouse can help you meet the needs of both work...
- Q14. Which of the following Structured Streaming queries successfully performs a hop from a Sil...
- Q15. You are currently asked to work on building a data pipeline, you have noticed that you are...
- Q16. Which of the following data workloads will utilize a Silver table as its source?...
- Q17. What is the main difference between the below two commands? 1.INSERT OVERWRITE table_name ...
- Q18. You were asked to write python code to stop all running streams, which of the following co...
- Q19. You had worked with the Data analysts team to set up a SQL Endpoint(SQL warehouse) point s...
- Q20. A data architect has determined that a table of the following format is necessary: Which o...
- Q21. Which of the following data workloads will utilize a Bronze table as its destination?...
- Q22. Which of the following command can be used to drop a managed delta table and the underlyin...
- Q23. While investigating a data issue in a Delta table, you wanted to review logs to see when a...
- Q24. How do you handle failures gracefully when writing code in Pyspark, fill in the blanks to ...
- Q25. How does a Delta Lake differ from a traditional data lake?...
- Q26. Which of the following statements are true about a lakehouse?...
- Q27. A junior data engineer needs to create a Spark SQL table my_table for which Spark manages ...
- Q28. A data engineer has set up two Jobs that each run nightly. The first Job starts at 12:00 A...
- Q29. You are asked to setup an AUTO LOADER to process the incoming data, this data arrives in J...
- Q30. You are tasked to set up a set notebook as a job for six departments and each department c...
- Q31. You had AUTO LOADER to process millions of files a day and noticed slowness in load proces...
- Q32. A dataset has been defined using Delta Live Tables and includes an expectations clause: 1....
- Q33. As a Data Engineer, you were asked to create a delta table to store below transaction data...
- Q34. A team member is leaving the team and he/she is currently the owner of the few tables, ins...
- Q35. The operations team is interested in monitoring the recently launched product, team wants ...
- Q36. The data engineering team noticed that one of the job fails randomly as a result of using ...
- Q37. Which of the following SQL commands are used to append rows to an existing delta table?...
- Q38. You were asked to identify number of times a temperature sensor exceed threshold temperatu...
- Q39. A data engineer wants to create a relational object by pulling data from two tables. The r...
- Q40. You were asked to setup a new all-purpose cluster, but the cluster is unable to start whic...
- Q41. A data engineer needs to dynamically create a table name string using three Python varia-b...
- Q42. When building a DLT s pipeline you have two options to create a live tables, what is the m...
- Q43. What steps need to be taken to set up a DELTA LIVE PIPELINE as a job using the workspace U...
- Q44. A newly joined team member John Smith in the Marketing team who currently does not have an...
- Q45. You are currently looking at a table that contains data from an e-commerce platform, each ...
- Q46. A newly joined team member John Smith in the Marketing team currently has access read acce...
- Q47. How do you check the location of an existing schema in Delta Lake?...
- Q48. A data engineer has a Job with multiple tasks that runs nightly. One of the tasks unexpect...
- Q49. While investigating a data issue, you wanted to review yesterday's version of the table us...
- Q50. The Delta Live Tables Pipeline is configured to run in Development mode using the Triggere...
- Q51. Which of the statements are incorrect when choosing between lakehouse and Datawarehouse?...
- Q52. Question-26. There are 5000 different color balls, out of which 1200 are pink color. What ...
- Q53. You are trying to create an object by joining two tables that and it is accessible to data...
- Q54. You are working on a email spam filtering assignment, while working on this you find there...
- Q55. What is the purpose of the bronze layer in a Multi-hop Medallion architecture?...
- Q56. In which phase of the data analytics lifecycle do Data Scientists spend the most time in a...
- Q57. Which of the following is correct for the global temporary view?...
- Q58. You are noticing job cluster is taking 6 to 8 mins to start which is delaying your job to ...
- Q59. A data engineer has created a Delta table as part of a data pipeline. Downstream data anal...
- Q60. Which of the following benefits does Delta Live Tables provide for ELT pipelines over stan...
- Q61. The data analyst team had put together queries that identify items that are out of stock b...
- Q62. What are the advantages of the Hashing Features?...
- Q63. A data engineering team is in the process of converting their existing data pipeline to ut...
- Q64. Data science team has requested they are missing a column in the table called average pric...
- Q65. An engineering manager uses a Databricks SQL query to monitor their team's progress on fix...
- Q66. How do you create a delta live tables pipeline and deploy using DLT UI?...
- Q67. Where are Interactive notebook results stored in Databricks product architecture?...
- Q68. When writing streaming data, Spark's structured stream supports the below write modes...
- Q69. Which of the following locations hosts the driver and worker nodes of a Databricks-managed...
- Q70. You have noticed the Data scientist team is using the notebook versioning feature with git...
- Q71. A data engineer has ingested a JSON file into a table raw_table with the following schema:...
- Q72. When using the complete mode to write stream data, how does it impact the target table?...
- Q73. A data engineer is overwriting data in a table by deleting the table and recreating the ta...
- Q74. Your team has hundreds of jobs running but it is difficult to track cost of each job run, ...
- Q75. Which of the following statements can be used to test the functionality of code to test nu...
- Q76. You are asked to setup two tasks in a databricks job, the first task runs a notebook to do...
- Q77. Which of the below SQL commands create a Global temporary view?...
- Q78. What is the output of below function when executed with input parameters 1, 3 : 1.def chec...
- Q79. Which of the following Structured Streaming queries is performing a hop from a Bronze tabl...
- Q80. A SQL Dashboard was built for the supply chain team to monitor the inventory and product o...
- Q81. When defining external tables using formats CSV, JSON, TEXT, BINARY any query on the exter...
- Q82. Which of the following section in the UI can be used to manage permissions and grants to t...
- Q83. Which of the following techniques structured streaming uses to ensure recovery of failures...
- Q84. The team has decided to take advantage of table properties to identify a business owner fo...
- Q85. At the end of the inventory process a file gets uploaded to the cloud object storage, you ...
- Q86. Define an external SQL table by connecting to a local instance of an SQLite database using...
- Q87. You are looking to process the data based on two variables, one to check if the department...
- Q88. If you create a database sample_db with the statement CREATE DATABASE sample_db what will ...
- Q89. Which of the following array functions takes input column return unique list of values in ...
- Q90. Which of the following developer operations in CI/CD flow can be implemented in Databricks...
- Q91. How VACCUM and OPTIMIZE commands can be used to manage the DELTA lake?...
- Q92. A data engineer has ingested data from an external source into a PySpark DataFrame raw_df....
- Q93. You are currently asked to work on building a data pipeline, you have noticed that you are...
- Q94. How are Delt tables stored?
- Q95. Which of the following are stored in the control pane of Databricks Architecture?...
- Q96. Which of the following is not a privilege in the Unity catalog?...

[×]
Download PDF File
Enter your email address to download Databricks.Databricks-Certified-Professional-Data-Engineer.v2023-04-24.q96.pdf