Coursera Microsoft Azure Data Scientist Associate (DP-100) • STUDY MODE
PRACTICE QUIZ: KNOWLEDGE CHECK 1
QUESTION 1 OF 6
Delta Lake provides snapshots of data enabling developers to access and revert to earlier versions of data for audits, rollbacks or to reproduce experiments. This functionality is referred to as?
A
Time TravelCorrect Answer
B
Schema Evolution
C
Schema Enforcement
D
ACID Transactions
QUESTION 2 OF 6
One of the core features of Delta Lake is performing upserts. Which of the following statements is true in regard to Upsert?
A
UpSert is literally TWO operations. Update / InsertCorrect Answer
B
Upsert is a new DML statement for SQL syntax
C
Upsert is supported in traditional data lakes
QUESTION 3 OF 6
When discussing Delta Lake, there is often a reference to the concept of Bronze, Silver and Gold tables. These levels refer to the state of data refinement as data flows through a processing pipeline and are conceptual guidelines. Based on these table concepts the refinements in Silver tables generally relate to which of the following?
A
Highly refined views of the data
B
Data that is directly queryable and ready for insightsCorrect Answer
C
Raw data (or very little processing)
QUESTION 4 OF 6
What is the Databricks Delta command to display metadata?
A
DESCRIBE DETAIL tableNameCorrect Answer
B
MSCK DETAIL tablename
C
SHOW SCHEMA tablename
QUESTION 5 OF 6
How do you perform UPSERT in a Delta dataset?
A
Use UPSERT INTO my-table /MERGE
B
Use UPSERT INTO my-table
C
Use MERGE INTO my-table USING data-to-upsertCorrect Answer
QUESTION 6 OF 6
What optimization does the following command perform: OPTIMIZE Students ZORDER BY Grade?
A
Ensures that all data backing, for example, Grade=8 is colocated, then rewrites the sorted data into new Parquet files.Correct Answer
B
Ensures that all data backing, for example, Grade=8 is colocated, then updates a graph that routes requests to the appropriate files.
C
Creates an order-based index on the Grade field to improve filters against that field.
Ready to test your recall?
Delta Lake provides snapshots of data enabling developers to access and revert to earlier versions of data for audits, rollbacks or to reproduce experiments. This functionality is referred to as?