vuthanhdatt's Second Brain

12

4 min read

Questions and Answers

Question zfId11BLbkVoLCyyATNt

Question

A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF).

Which of the following code blocks creates this SQL UDF?

Choices

  • A:
  • B:
  • C:
  • D:

Question SDTN3JRkY1nYjoEEVzQt

Question

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?

Choices

  • A: The VACUUM command was run on the table
  • B: The TIME TRAVEL command was run on the table
  • C: The DELETE HISTORY command was run on the table
  • D: The OPTIMIZE command was nun on the table

Question tq3x6F6HrPw10WGhE2B3

Question

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

Choices

  • A: Bronze tables contain less data than raw data files.
  • B: Bronze tables contain more truthful data than raw data.
  • C: Bronze tables contain raw data with a schema applied.
  • D: Bronze tables contain a less refined view of data than raw data.

Question rsztb7SZfRhEybZW3mwV

Question

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?

Choices

  • A: if day_of_week = 1 and review_period:
  • B: if day_of_week = 1 and review_period = “True”:
  • C: if day_of_week = 1 & review_period: = “True”:
  • D: if day_of_week == 1 and review_period:

Question 4c5S1XIQVBgjpqXLeiYG

Question

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

Choices

  • A: A key-value pair configuration
  • B: At least one notebook library to be executed
  • C: A path to cloud storage location for the written data
  • D: A location of a target database for the written data

Graph View