DE-ASSOC practice questions 51–60

1. Question 51 · 170 in bank

   An engineering manager uses a Databricks SQL query to monitor ingestion latency for each data source. The manager checks the results of the query every day, but they are manually rerunning the query each day and waiting for the results. Which of the following approaches can the manager use to ensure the results of the query are updated each day?

   • AThey can schedule the query to refresh every 1 day from the SQL endpoint's page in Databricks SQL.
   • BThey can schedule the query to refresh every 12 hours from the SQL endpoint's page in Databricks SQL.
   • CThey can schedule the query to refresh every 1 day from the query's page in Databricks SQL.
   • DThey can schedule the query to run every 12 hours from the Jobs UI.

   Show answer

   Answer: C

   Explanation

   The correct answer is C. They can schedule the query to refresh every 1 day from the query's page in Databricks SQL. This approach ensures that the query results are automatically updated each day without the need for manual intervention.

   Source: Adapted from community discussion — MultiCloudIronMan

   Next question

2. Question 52 · 170 in bank

   A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version, they are unable to restore the data because the data files have been deleted. Which of the following explains why the data files are no longer present?

   • AThe VACUUM command was run on the table
   • BThe TIME TRAVEL command was run on the table
   • CThe DELETE HISTORY command was run on the table
   • DThe OPTIMIZE command was nun on the table

   Show answer

   Answer: A

   Next question

3. Question 53 · 170 in bank

   Which of the following describes the relationship between Bronze tables and raw data?

   • ABronze tables contain less data than raw data files.
   • BBronze tables contain more truthful data than raw data.
   • CBronze tables contain raw data with a schema applied.
   • DBronze tables contain a less refined view of data than raw data.

   Show answer

   Answer: C

   Next question

4. Question 54 · 170 in bank

   A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period is True. Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?

   • Aif day_of_week = 1 and review_period:
   • Bif day_of_week = 1 and review_period = "True":
   • Cif day_of_week = 1 & review_period: = "True":
   • Dif day_of_week == 1 and review_period:

   Show answer

   Answer: D

   Next question

5. Question 55 · 170 in bank

   Which of the following must be specified when creating a new Delta Live Tables pipeline?

   • AA key-value pair configuration
   • BAt least one notebook library to be executed
   • CA path to cloud storage location for the written data
   • DA location of a target database for the written data

   Show answer

   Answer: B

   Next question

6. Question 56 · 170 in bank

   In which of the following scenarios should a data engineer select a Task in the Depends On field of a new Databricks Job Task?

   • AWhen another task needs to be replaced by the new task
   • BWhen another task needs to successfully complete before the new task begins
   • CWhen another task has the same dependency libraries as the new task
   • DWhen another task needs to use as little compute resources as possible

   Show answer

   Answer: B

   Next question

7. Question 57 · 170 in bank

   A data engineering team has two tables. The first table march_transactions is a collection of all retail transactions in the month of March. The second table april_transactions is a collection of all retail transactions in the month of April. There are no duplicate records between the tables. Which of the following commands should be run to create a new table all_transactions that contains all records from march_transactions and april_transactions without duplicate records?

   • ACREATE TABLE all_transactions AS SELECT * FROM march_transactions INNER JOIN SELECT * FROM april_transactions;
   • BCREATE TABLE all_transactions AS SELECT * FROM march_transactions UNION SELECT * FROM april_transactions;
   • CCREATE TABLE all_transactions AS SELECT * FROM march_transactions OUTER JOIN SELECT * FROM april_transactions;
   • DCREATE TABLE all_transactions AS SELECT * FROM march_transactions INTERSECT SELECT * from april_transactions;

   Show answer

   Answer: B

   Explanation

   The correct answer is B. CREATE TABLE all_transactions AS SELECT * FROM march_transactions UNION SELECT * FROM april_transactions. The UNION operator combines the results of two queries and removes duplicate records, ensuring that the new table all_transactions contains all unique records from both march_transactions and april_transactions.

   Source: Adapted from community discussion — MultiCloudIronMan

   Next question

8. Question 58 · 170 in bank

   How can Git operations must be performed outside of Databricks Repos?

   • ACommit
   • BPull
   • CMerge
   • DClone

   Show answer

   Answer: C

   Explanation

   See https://docs.databricks.com/en/repos/git-operations-with-repos.html "The article describes how to perform common Git operations in your Databricks workspace using Git folders, including cloning, branching, committing, and pushing." See also Question 8.

   Source: Adapted from community discussion — duzi

   References

   • Databricks documentation

   Next question

9. Question 59 · 170 in bank

   A data engineer has joined an existing project and they see the following query in the project repository: CREATE STREAMING LIVE TABLE loyal_customers AS SELECT customer_id - FROM STREAM(LIVE.customers) WHERE loyalty_level = 'high'; Which of the following describes why the STREAM function is included in the query?

   • AThe STREAM function is not needed and will cause an error.
   • BThe data in the customers table has been updated since its last run.
   • CThe customers table is a streaming live table.
   • DThe customers table is a reference to a Structured Streaming query on a PySpark DataFrame.

   Show answer

   Answer: C

   Explanation

   The correct answer is C. The customers table is a streaming live table. The STREAM function is used to indicate that the customers table is a streaming live table, which means it is continuously updated with new data. This allows the loyal_customers table to be created as a streaming live table that processes data incrementally as it arrives.

   Source: Adapted from community discussion — MultiCloudIronMan

   Next question

10. Question 60 · 170 in bank

    Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?

    • ADROP
    • BIGNORE
    • CMERGE
    • DAPPEND
    • EINSERT

    Show answer

    Answer: C

    Explanation

    C. MERGE To write data into a Delta table while avoiding the writing of duplicate records, you can use the MERGE command. The MERGE command in Delta Lake allows you to combine the ability to insert new records and update existing records in a single atomic operation. The MERGE command compares the data being written with the existing data in the Delta table based on specified matching criteria, typically using a primary key or unique identifier. It then performs conditional actions, such as inserting new records or updating existing records, depending on the comparison results. By using the MERGE command, you can handle the prevention of duplicate records in a more controlled and efficient manner. It allows you to synchronize and reconcile data from different sources while avoiding duplication and ensuring data integrity. Therefore, option C, MERGE, is the correct command to use when writing data into a Delta table while avoiding the writing of duplicate records.

    Source: Adapted from community discussion — Atnafu

    References

    • Databricks documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DE-ASSOC practice, question 51. 170 questions available.