1 | Page
DP600 – MICROSOFT FABRICS 2026 ACTUAL EXAM
TEST BANK | ALL QUESTIONS AND CORRECT
DETAILED ANSWERS | RATED A+ | NEW AND
REVISED
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.: c
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.: a
3. Which method is used to split the data across folders when saving
a dataframe?
a. splitBy
b. distributeBy
c.partitionBy: c
4. 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
,2 | Page
b. log
c.parquet: a
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: b
6. What is consistency in ACID transactions?
a. transactions leave the database in a consistent state
,3 | Page
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: a
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: a
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: c
9. 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
run- time 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: a
10. ... tables: in which the relational table definition in the metastore is
mapped to an alternative file storage location.
a. managed
b. external: b
11. Deleting an external table from the lakehouse metastore does not delete the
associated data files.
,4 | Page
a. TRUE
b. FALSE: a
DP600 – MICROSOFT FABRICS 2026 ACTUAL EXAM
TEST BANK | ALL QUESTIONS AND CORRECT
DETAILED ANSWERS | RATED A+ | NEW AND
REVISED
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.: c
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.: a
3. Which method is used to split the data across folders when saving
a dataframe?
a. splitBy
b. distributeBy
c.partitionBy: c
4. 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
,2 | Page
b. log
c.parquet: a
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: b
6. What is consistency in ACID transactions?
a. transactions leave the database in a consistent state
,3 | Page
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: a
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: a
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: c
9. 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
run- time 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: a
10. ... tables: in which the relational table definition in the metastore is
mapped to an alternative file storage location.
a. managed
b. external: b
11. Deleting an external table from the lakehouse metastore does not delete the
associated data files.
,4 | Page
a. TRUE
b. FALSE: a
