DP-600 QUESTIONS AND ANSWERS
1. You want to use Apache Spark to explore data interactively in Microsoft Fabric.
What should you create?
A. Spark job definition.
B. Data Factory pipeline.
C. Notebook. - Answer - Notebook
2. You need to use Spark to analyze data in a CSV file. What's the simplest
way to accomplish this goal?
A. Load the file into a dataframe.
B. Import the data into a table in a warehouse
C. Convert the data to Parquet format. - Answer - Load the file into a dataframe.
3. Which method is used to split the data across folders when saving
a dataframe?
A. splitBy
B. distributeBy
C. partitionBy - Answer - partitionBy
4. Fill in the blank - Answer - "For each table, the lakehouse stores a folder
containing Parquet data files and a (...) folder in which transaction details
are logged in JSON format".
A. _delta_Log
B. log
,C. parquet - Answer - _delta_Log
5. What is atomicity in ACID transactions?
A. transactions leave the database in a consistent state
B. transactions complete as a single unit of work
C. in-process transactions can't interfere with one another
D. when a transaction completes, the changes it made are persisted - Answer -
transactions complete as a single unit of work
,6. What is consistency in ACID transactions?
A. transactions leave the database in a consistent state
B. transactions complete as a single unit of work
C. in-process transactions can't interfere with one another
D. when a transaction completes, the changes it made are persisted - Answer -
transactions leave the database in a consistent state
7. What is durability in ACID transactions?
A. when a transaction completes, the changes it made are persisted
B. transactions complete as a single unit of work
C. in-process transactions can't interfere with one another
D. transactions leave the database in a consistent state - Answer - when a transaction
completes, the changes it made are persisted
8. What is isolation in ACID transactions?
A. when a transaction completes, the changes it made are persisted
B. transactions complete as a single unit of work
C. in-process transactions can't interfere with one another
D. transactions leave the database in a consistent state - Answer - in-process
transactions can't interfere with one another
9. Fill in the blank - Answer - "Dataframe that's saved as a (...) table means
that the table definition in the metastore and the underlying data files are both
managed by the Spark runtime for the Fabric lakehouse. Deleting the table will
also delete the underlying files from the Tables storage location for the
, lakehouse".
A. managed
B. external - Answer - managed
10. Fill in the blank - Answer - "(...) tables - Answer - in which the relational
table definition in the metastore is mapped to an alternative file storage
location".
A. managed
B. external - Answer - external
1. You want to use Apache Spark to explore data interactively in Microsoft Fabric.
What should you create?
A. Spark job definition.
B. Data Factory pipeline.
C. Notebook. - Answer - Notebook
2. You need to use Spark to analyze data in a CSV file. What's the simplest
way to accomplish this goal?
A. Load the file into a dataframe.
B. Import the data into a table in a warehouse
C. Convert the data to Parquet format. - Answer - Load the file into a dataframe.
3. Which method is used to split the data across folders when saving
a dataframe?
A. splitBy
B. distributeBy
C. partitionBy - Answer - partitionBy
4. Fill in the blank - Answer - "For each table, the lakehouse stores a folder
containing Parquet data files and a (...) folder in which transaction details
are logged in JSON format".
A. _delta_Log
B. log
,C. parquet - Answer - _delta_Log
5. What is atomicity in ACID transactions?
A. transactions leave the database in a consistent state
B. transactions complete as a single unit of work
C. in-process transactions can't interfere with one another
D. when a transaction completes, the changes it made are persisted - Answer -
transactions complete as a single unit of work
,6. What is consistency in ACID transactions?
A. transactions leave the database in a consistent state
B. transactions complete as a single unit of work
C. in-process transactions can't interfere with one another
D. when a transaction completes, the changes it made are persisted - Answer -
transactions leave the database in a consistent state
7. What is durability in ACID transactions?
A. when a transaction completes, the changes it made are persisted
B. transactions complete as a single unit of work
C. in-process transactions can't interfere with one another
D. transactions leave the database in a consistent state - Answer - when a transaction
completes, the changes it made are persisted
8. What is isolation in ACID transactions?
A. when a transaction completes, the changes it made are persisted
B. transactions complete as a single unit of work
C. in-process transactions can't interfere with one another
D. transactions leave the database in a consistent state - Answer - in-process
transactions can't interfere with one another
9. Fill in the blank - Answer - "Dataframe that's saved as a (...) table means
that the table definition in the metastore and the underlying data files are both
managed by the Spark runtime for the Fabric lakehouse. Deleting the table will
also delete the underlying files from the Tables storage location for the
, lakehouse".
A. managed
B. external - Answer - managed
10. Fill in the blank - Answer - "(...) tables - Answer - in which the relational
table definition in the metastore is mapped to an alternative file storage
location".
A. managed
B. external - Answer - external
