Join the discussion
Question 1/133
What is a method of installing a Python package scoped at the notebook level to all nodes in the currently active cluster?
Correct Answer: C
Installing a Python package scoped at the notebook level to all nodes in the currently active cluster in Databricks can be achieved by using the Libraries tab in the cluster UI. This interface allows you to install libraries across all nodes in the cluster. While the%pipcommand in a notebook cell would only affect the driver node, using the cluster UI ensures that the package is installed on all nodes.
References:
* Databricks Documentation on Libraries: Libraries
References:
* Databricks Documentation on Libraries: Libraries
Add Comments
- Other Question (133q)
- Q1. What is a method of installing a Python package scoped at the notebook level to all nodes ...
- Q2. The data engineer team has been tasked with configured connections to an external database...
- Q3. An upstream system is emitting change data capture (CDC) logs that are being written to a ...
- Q4. The data governance team is reviewing user for deleting records for compliance with GDPR. ...
- Q5. You are tasked to set up a set notebook as a job for six departments and each department c...
- Q6. The marketing team is looking to share data in an aggregate table with the sales organizat...
- Q7. A Databricks job has been configured with 3 tasks, each of which is a Databricks notebook....
- Q8. A user wants to use DLT expectations to validate that a derived table report contains all ...
- Q9. Which of the following Structured Streaming queries successfully performs a hop from a Sil...
- Q10. Which of the following section in the UI can be used to manage permissions and grants to t...
- Q11. Which of the following Auto loader structured streaming commands successfully performs a h...
- Q12. A Delta Lake table was created with the below query: Consider the following query: DROP TA...
- Q13. Which of the following features of data lakehouse can help you meet the needs of both work...
- Q14. Which statement describes the correct use of pyspark.sql.functions.broadcast?...
- Q15. The data engineering team noticed that one of the job normally finishes in 15 mins but get...
- Q16. In which phase of the data analytics lifecycle do Data Scientists spend the most time in a...
- Q17. What is the best way to query external csv files located on DBFS Storage to inspect the da...
- Q18. Assuming that the Databricks CLI has been installed and configured correctly, which Databr...
- Q19. Although the Databricks Utilities Secrets module provides tools to store sensitive credent...
- Q20. A table named user_ltv is being used to create a view that will be used by data analysts o...
- Q21. The data engineering team maintains the following code: (Exhibit) Assuming that this code ...
- Q22. Which of the following python statement can be used to replace the schema name and table n...
- Q23. The default threshold of VACUUM is 7 days, internal audit team asked to certain tables to ...
- Q24. Data engineering team has a job currently setup to run a task load data into a reporting t...
- Q25. Which of the following commands can be used to run one notebook from another notebook?...
- Q26. A data analyst has provided a data engineering team with the following Spark SQL query: 1....
- Q27. A junior data engineer seeks to leverage Delta Lake's Change Data Feed functionality to cr...
- Q28. A data engineer wants to create a relational object by pulling data from two tables. The r...
- Q29. A Databricks SQL dashboard has been configured to monitor the total number of records pres...
- Q30. A data engineer is testing a collection of mathematical functions, one of which calculates...
- Q31. Which REST API call can be used to review the notebooks configured to run as tasks in a mu...
- Q32. You noticed that colleague is manually copying the notebook with _bkp to store the previou...
- Q33. The Databricks CLI is use to trigger a run of an existing job by passing the job_id parame...
- Q34. Incorporating unit tests into a PySpark application requires upfront attention to the desi...
- Q35. You have noticed that Databricks SQL queries are running slow, you are asked to look reaso...
- Q36. A junior data engineer is working to implement logic for a Lakehouse table named silver_de...
- Q37. Which of the following data workloads will utilize a Bronze table as its destination?...
- Q38. Which of the following command can be used to drop a managed delta table and the underlyin...
- Q39. A member of the data engineering team has submitted a short notebook that they wish to sch...
- Q40. Review the following error traceback: (Exhibit) Which statement describes the error being ...
- Q41. When building a DLT s pipeline you have two options to create a live tables, what is the m...
- Q42. The data engineering team has configured a Databricks SQL query and alert to monitor the v...
- Q43. The security team is exploring whether or not the Databricks secrets module can be leverag...
- Q44. A data ingestion task requires a one-TB JSON dataset to be written out to Parquet with a t...
- Q45. An hourly batch job is configured to ingest data files from a cloud object storage contain...
- Q46. Which statement describes Delta Lake Auto Compaction?...
- Q47. A data engineer has configured a Structured Streaming job to read from a table, manipulate...
- Q48. A Delta table of weather records is partitioned by date and has the below schema: date DAT...
- Q49. You were asked to identify number of times a temperature sensor exceed threshold temperatu...
- Q50. An upstream source writes Parquet data as hourly batches to directories named with the cur...
- Q51. Your team member is trying to set up a delta pipeline and build a second gold table to the...
- Q52. If you create a database sample_db with the statement CREATE DATABASE sample_db what will ...
- Q53. A junior data engineer is migrating a workload from a relational database system to the Da...
- Q54. A particular job seems to be performing slower and slower over time, the team thinks this ...
- Q55. A table is registered with the following code: (Exhibit) Bothusersandordersare Delta Lake ...
- Q56. A data engineer needs to dynamically create a table name string using three Python varia-b...
- Q57. Question-3: In machine learning, feature hashing, also known as the hashing trick (by anal...
- Q58. You have noticed the Data scientist team is using the notebook versioning feature with git...
- Q59. Which of the following statements are correct on how Delta Lake implements a lake house?...
- Q60. The view updates represents an incremental batch of all newly ingested data to be inserted...
- Q61. A Delta Lake table was created with the below query: (Exhibit) Consider the following quer...
- Q62. The data science team has created and logged a production model using MLflow. The followin...
- Q63. A Delta Lake table was created with the below query: (Exhibit) Consider the following quer...
- Q64. What is the top-level object in unity catalog?...
- Q65. Which of the following approaches can the data engineer use to obtain a version-controllab...
- Q66. A production cluster has 3 executor nodes and uses the same virtual machine type for the d...
- Q67. You are currently working on a project that requires the use of SQL and Python in a given ...
- Q68. A data engineer, User A, has promoted a new pipeline to production by using the REST API t...
- Q69. A table named user_ltv is being used to create a view that will be used by data analysis o...
- Q70. if you run the command VACUUM transactions retain 0 hours? What is the outcome of this com...
- Q71. The Databricks workspace administrator has configured interactive clusters for each of the...
- Q72. Two junior data engineers are authoring separate parts of a single data pipeline notebook....
- Q73. A table in the Lakehouse namedcustomer_churn_paramsis used in churn prediction by the mach...
- Q74. A junior developer complains that the code in their notebook isn't producing the correct r...
- Q75. The data architect has mandated that all tables in the Lakehouse should be configured as e...
- Q76. You are currently working on reloading customer_sales tables using the below query 1. INSE...
- Q77. The data engineering team has configured a job to process customer requests to be forgotte...
- Q78. A junior member of the data engineering team is exploring the language interoperability of...
- Q79. A data analyst has noticed that their Databricks SQL queries are running too slowly. They ...
- Q80. While investigating a data issue, you wanted to review yesterday's version of the table us...
- Q81. You were asked to create or overwrite an existing delta table to store the below transacti...
- Q82. Data science team has requested they are missing a column in the table called average pric...
- Q83. What is the output of the below function when executed with input parameters 1, 3 : 1.def ...
- Q84. A team member is leaving the team and he/she is currently the owner of the few tables, ins...
- Q85. The downstream consumers of a Delta Lake table have been complaining about data quality is...
- Q86. The data engineering team is migrating an enterprise system with thousands of tables and v...
- Q87. Which of the following scenarios is the best fit for AUTO LOADER?...
- Q88. The data engineering team has configured a Databricks SQL query and alert to monitor the v...
- Q89. The view updates represents an incremental batch of all newly ingested data to be inserted...
- Q90. Which of the following techniques structured streaming uses to ensure recovery of failures...
- Q91. One of the queries in the Databricks SQL Dashboard takes a long time to refresh, which of ...
- Q92. A small company based in the United States has recently contracted a consulting firm in In...
- Q93. A Delta Lake table representing metadata about content posts from users has the following ...
- Q94. The viewupdatesrepresents an incremental batch of all newly ingested data to be inserted o...
- Q95. The marketing team is launching a new campaign to monitor the performance of the new campa...
- Q96. The viewupdatesrepresents an incremental batch of all newly ingested data to be inserted o...
- Q97. Which statement regarding spark configuration on the Databricks platform is true?...
- Q98. Which statement describes Delta Lake optimized writes?...
- Q99. Which of the following statements describes Delta Lake?...
- Q100. The data engineering team is migrating an enterprise system with thousands of tables and v...
- Q101. The data science team has created and logged a production model using MLflow. The followin...
- Q102. You are noticing job cluster is taking 6 to 8 mins to start which is delaying your job to ...
- Q103. Create a schema called bronze using location '/mnt/delta/bronze', and check if the schema ...
- Q104. Which of the following commands can be used to query a delta table?...
- Q105. A Delta table of weather records is partitioned by date and has the below schema: date DAT...
- Q106. The following code has been migrated to a Databricks notebook from a legacy workload: (Exh...
- Q107. Although the Databricks Utilities Secrets module provides tools to store sensitive credent...
- Q108. A junior data engineer needs to create a Spark SQL table my_table for which Spark manages ...
- Q109. What are the advantages of the Hashing Features?...
- Q110. A new data engineer [email protected] has been assigned to an ELT project. The new ...
- Q111. What is the best way to describe a data lakehouse compared to a data warehouse?...
- Q112. A member of the data engineering team has submitted a short notebook that they wish to sch...
- Q113. Each configuration below is identical to the extent that each cluster has 400 GB total of ...
- Q114. You are working on a email spam filtering assignment, while working on this you find there...
- Q115. You are asked to setup two tasks in a databricks job, the first task runs a notebook to do...
- Q116. When scheduling Structured Streaming jobs for production, which configuration automaticall...
- Q117. A Delta Lake table representing metadata about content from user has the following schema:...
- Q118. The following code has been migrated to a Databricks notebook from a legacy workload: (Exh...
- Q119. While investigating a performance issue, you realized that you have too many small files f...
- Q120. Kevin is the owner of the schema sales, Steve wanted to create new table in sales schema c...
- Q121. The data governance team has instituted a requirement that all tables containing Personal ...
- Q122. A Delta Lake table was created with the below query: (Exhibit) Realizing that the original...
- Q123. You are currently working on a notebook that will populate a reporting table for downstrea...
- Q124. A table nameduser_ltvis being used to create a view that will be used by data analysts on ...
- Q125. A data engineer needs to capture pipeline settings from an existing in the workspace, and ...
- Q126. Which of the following describes a benefit of a data lakehouse that is unavailable in a tr...
- Q127. The security team is exploring whether or not the Databricks secrets module can be leverag...
- Q128. You were asked to create a notebook that can take department as a parameter and process th...
- Q129. One of the team members Steve who has the ability to create views, created a new view call...
- Q130. The data engineering team maintains the following code: (Exhibit) Assuming that this code ...
- Q131. Unity catalog simplifies managing multiple workspaces, by storing and managing permissions...
- Q132. When writing streaming data, Spark's structured stream supports the below write modes...
- Q133. A denote the event 'student is female' and let B denote the event 'student is French'. In ...
[×]
Download PDF File
Enter your email address to download Databricks.Databricks-Certified-Professional-Data-Engineer.v2024-06-24.q133.pdf