Databricks DE Associate Cert 2024 –
2025 YouTube
45 # A new data engineering team team has been assigned to an ELT project. The new
data engineering team will need full privileges on the table sales to fully manage the
project.
Which of the following commands can be used to grant full permissions on the database
to the new data engineering team?
A. GRANT ALL PRIVILEGES ON TABLE sales TO team;
B. GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
C. GRANT SELECT ON TABLE sales TO team;
D. GRANT USAGE ON TABLE sales TO team;
E. GRANT ALL PRIVILEGES ON TABLE team TO sales; - answerA
46 # 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 of the following Git operations does the data engineer need to run to accomplish
this task?
A. Merge
B. Push
C. Pull
D. Commit
E. Clone - answerC
47 # Which of the following is a benefit of the Databricks Lakehouse Platform embracing
open source technologies?
A. Cloud-specific integrations
B. Simplified governance
C. Ability to scale storage
D. Ability to scale workloads
E. Avoiding vendor lock-in - answerE
48 # 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 of the following locations can the data engineer review their permissions on the
table?
, A. Databricks Filesystem
B. Jobs
C. Dashboards
D. Repos
E. Data Explorer - answerE
49 # Which of the following describes a scenario in which a data engineer will want to
use a single- node cluster?
A. When they are working interactively with a small amount of data
B. When they are running automated reports to be refreshed as quickly as possible
C. When they are working with SQL within Databricks SQL
D. When they are concerned about the ability to automatically scale with larger data
E. When they are manually running reports with a large amount of data - answerA
50 # A data engineer has been given a new record of data:
id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4
Which of the following SQL commands can be used to append the new record to an
existing Delta table my_table?
A. INSERT INTO my_table VALUES ('a1', 6, 9.4)
B. my_table UNION VALUES ('a1', 6, 9.4)
C. INSERT VALUES ('a1', 6, 9.4) INTO my_table
D. UPDATE my_table VALUES ('a1', 6, 9.4)
E. UPDATE VALUES ('a1', 6, 9.4) my_table - answerA
51 # A data engineer has realized that the data files associated with a Delta table are
incredibly small.
They want to compact the small files to form larger files to improve performance.
Which of the following keywords can be used to compact the small files?
A. REDUCE
B. OPTIMIZE
C. COMPACTION
D. REPARTITION
E. VACUUM
- compact the small files - answerB
52 # In which of the following file formats is data from Delta Lake tables primarily
stored?
A. Delta
B. CSV
2025 YouTube
45 # A new data engineering team team has been assigned to an ELT project. The new
data engineering team will need full privileges on the table sales to fully manage the
project.
Which of the following commands can be used to grant full permissions on the database
to the new data engineering team?
A. GRANT ALL PRIVILEGES ON TABLE sales TO team;
B. GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
C. GRANT SELECT ON TABLE sales TO team;
D. GRANT USAGE ON TABLE sales TO team;
E. GRANT ALL PRIVILEGES ON TABLE team TO sales; - answerA
46 # 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 of the following Git operations does the data engineer need to run to accomplish
this task?
A. Merge
B. Push
C. Pull
D. Commit
E. Clone - answerC
47 # Which of the following is a benefit of the Databricks Lakehouse Platform embracing
open source technologies?
A. Cloud-specific integrations
B. Simplified governance
C. Ability to scale storage
D. Ability to scale workloads
E. Avoiding vendor lock-in - answerE
48 # 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 of the following locations can the data engineer review their permissions on the
table?
, A. Databricks Filesystem
B. Jobs
C. Dashboards
D. Repos
E. Data Explorer - answerE
49 # Which of the following describes a scenario in which a data engineer will want to
use a single- node cluster?
A. When they are working interactively with a small amount of data
B. When they are running automated reports to be refreshed as quickly as possible
C. When they are working with SQL within Databricks SQL
D. When they are concerned about the ability to automatically scale with larger data
E. When they are manually running reports with a large amount of data - answerA
50 # A data engineer has been given a new record of data:
id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4
Which of the following SQL commands can be used to append the new record to an
existing Delta table my_table?
A. INSERT INTO my_table VALUES ('a1', 6, 9.4)
B. my_table UNION VALUES ('a1', 6, 9.4)
C. INSERT VALUES ('a1', 6, 9.4) INTO my_table
D. UPDATE my_table VALUES ('a1', 6, 9.4)
E. UPDATE VALUES ('a1', 6, 9.4) my_table - answerA
51 # A data engineer has realized that the data files associated with a Delta table are
incredibly small.
They want to compact the small files to form larger files to improve performance.
Which of the following keywords can be used to compact the small files?
A. REDUCE
B. OPTIMIZE
C. COMPACTION
D. REPARTITION
E. VACUUM
- compact the small files - answerB
52 # In which of the following file formats is data from Delta Lake tables primarily
stored?
A. Delta
B. CSV
