vuthanhdatt's Second Brain

34

3 min read

Questions and Answers

Question htXHZxV1yfJ1FcdNrKUl

Question

A data engineer needs to use a Delta table as part of a data pipeline, but they do not know if they have the appropriate permissions.

In which location can the data engineer review their permissions on the table?

Choices

  • A: Jobs
  • B: Dashboards
  • C: Catalog Explorer
  • D: Repos

Question 20rAZMEqW8Bd9px8tsBQ

Question

A data engineer is running code in a Databricks Repo that is cloned from a central Git repository. A colleague of the data engineer informs them that changes have been made and synced to the central Git repository. The data engineer now needs to sync their Databricks Repo to get the changes from the central Git repository.

Which Git operation does the data engineer need to run to accomplish this task?

Choices

  • A: Clone
  • B: Pull
  • C: Merge
  • D: Push

Question 3wbJwwj2APLxcIAzotV1

Question

Which file format is used for storing Delta Lake Table?

Choices

  • A: CSV
  • B: Parquet
  • C: JSON
  • D: Delta

Question 0OMppcxydhjH3iel5pt8

Question

A data architect has determined that a table of the following format is necessary:

//IMG//

Which code block is used by SQL DDL command to create an empty Delta table in the above format regardless of whether a table already exists with this name?

Choices

  • A: CREATE OR REPLACE TABLE table_name ( employeeId STRING, startDate DATE, avgRating FLOAT )
  • B: CREATE OR REPLACE TABLE table_name WITH COLUMNS ( employeeId STRING, startDate DATE, avgRating FLOAT ) USING DELTA
  • C: CREATE TABLE IF NOT EXISTS table_name ( employeeId STRING, startDate DATE, avgRating FLOAT )
  • D: CREATE TABLE table_name AS SELECT employeeId STRING, startDate DATE, avgRating FLOAT

Graph View