vuthanhdatt's Second Brain

10

8 min read

Questions and Answers

Question 4NKjPBmfrlqrakYe8vIj

Question

A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.

The code block used by the data engineer is below:

//IMG//

The data engineer only wants the query to process all of the available data in as many batches as required.

Which line of code should the data engineer use to fill in the blank?

Choices

  • A: trigger(availableNow=True)
  • B: trigger(processingTime= “once”)
  • C: trigger(continuous= “once”)
  • D: trigger(once=True)

Question lOCLvpRH78btFq3qylst

Question

Data engineer and data analysts are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL. The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables.

Which of the following changes will need to be made to the pipeline when migrating to Delta Live Tables?

Choices

  • A: The pipeline can have different notebook sources in SQL & Python
  • B: The pipeline will need to be written entirely in SQL
  • C: The pipeline will need to use a batch source in place of a streaming source
  • D: The pipeline will need to be written entirely in Python

Question BU8j5CQ8tTibup3aX43b

Question

Identify a scenario to use an external table. A Data Engineer needs to create a parquet bronze table and wants to ensure that it gets stored in a specific path in an external location.

Which table can be created in this scenario?

Choices

  • A: An external table where the location is pointing to specific path in external location.
  • B: An external table where the schema has managed location pointing to specific path in external location.
  • C: A managed table where the catalog has managed location pointing to specific path in external location.
  • D: A managed table where the location is pointing to specific path in external location.

Question mXlJboKZlW30J7WL8q9J

Question

Identify the impact of ON VIOLATION DROP ROW and ON VIOLATION FAIL UPDATE for a constraint violation.

A data engineer has created an ETL pipeline using Delta Live table to manage their company travel reimbursement detail, they want to ensure that the if the location details has not been provided by the employee, the pipeline needs to be terminated.

How can the scenario be implemented?

Choices

  • A: CONSTRAINT valid_location EXPECT (location = NULL)
  • B: CONSTRAINT valid_location EXPECT (location != NULL) ON VIOLATION FAIL UPDATE
  • C: CONSTRAINT valid_location EXPECT (location != NULL) ON DROP ROW
  • D: CONSTRAINT valid_location EXPECT (location != NULL) ON VIOLATION FAIL

Question XPHEibf89o3PR9Uw7eQg

Question

Which two conditions are applicable for governance in Databricks Unity Catalog? (Choose two.)

Choices

  • A: You can have more than 1 metastore within a databricks account console but only 1 per region.
  • B: Both catalog and schema must have a managed location in Unity Catalog provided metastore is not associated with a location
  • C: You can have multiple catalogs within metastore and 1 catalog can be associated with multiple metastore
  • D: If catalog is not associated with location, it’s mandatory to associate schema with managed locations
  • E: If metastore is not associated with location, it’s mandatory to associate catalog with managed locations

Graph View