DE-ASSOC practice questions 1–10

1. Question 1 · 170 in bank

   A data organization leader is upset about the data analysis team’s reports being different from the data engineering team’s reports. The leader believes the siloed nature of their organization’s data engineering and data analysis architectures is to blame. Which of the following describes how a data lakehouse could alleviate this issue?

   • ABoth teams would autoscale their work as data size evolves
   • BBoth teams would use the same source of truth for their work
   • CBoth teams would reorganize to report to the same department
   • DBoth teams would be able to collaborate on projects in real-time
   • EBoth teams would respond more quickly to ad-hoc requests

   Show answer

   Answer: B

   Explanation

   Databricks Lakehouse enables using data as the single source of truth. Duplicating data often results in data silos in organizations. Correct answer B.

   Source: Adapted from community discussion — prasioso

   Next question

2. Question 2 · 170 in bank

   A data engineer needs to determine whether to use the built-in Databricks Notebooks versioning or version their project using Databricks Repos. Which of the following is an advantage of using Databricks Repos over the Databricks Notebooks versioning?

   • ADatabricks Repos automatically saves development progress
   • BDatabricks Repos supports the use of multiple branches
   • CDatabricks Repos allows users to revert to previous versions of a notebook
   • DDatabricks Repos provides the ability to comment on specific changes
   • EDatabricks Repos is wholly housed within the Databricks Lakehouse Platform

   Show answer

   Answer: B

   Explanation

   While both Databricks Notebooks versioning and Databricks Repos allow for version control of code, Databricks Repos provides the additional benefit of supporting the use of multiple branches. This allows for multiple versions of a notebook or project to be developed in parallel, facilitating collaboration among team members and simplifying the process of merging changes into a single main branch.

   Source: Adapted from community discussion — Majjjj

   Next question

3. Question 3 · 170 in bank

   Which of the following benefits is provided by the array functions from Spark SQL?

   • AAn ability to work with data in a variety of types at once
   • BAn ability to work with data within certain partitions and windows
   • CAn ability to work with time-related data in specified intervals
   • DAn ability to work with complex, nested data ingested from JSON files

   Show answer

   Answer: D

   Next question

4. Question 4 · 170 in bank

   A data engineer has been given a new record of data: id STRING = 'a1' rank INTEGER = 6 rating FLOAT = 9.4 Which SQL commands can be used to append the new record to an existing Delta table my_table?

   • AINSERT INTO my_table VALUES ('a1', 6, 9.4)
   • BINSERT VALUES ('a1', 6, 9.4) INTO my_table
   • CUPDATE my_table VALUES ('a1', 6, 9.4)
   • DUPDATE VALUES ('a1', 6, 9.4) my_table

   Show answer

   Answer: A

   Next question

5. Question 5 · 170 in bank

   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 keyword can be used to compact the small files?

   • AOPTIMIZE
   • BVACUUM
   • CCOMPACTION
   • DREPARTITION

   Show answer

   Answer: A

   Explanation

   The OPTIMIZE command is used to compact small files into larger ones, which helps improve the performance of Delta Lake tables. It consolidates small files into fewer larger files to reduce the overhead associated with having many small files. This process is often referred to as "compaction" but the specific keyword in Databricks Delta Lake is OPTIMIZE.

   Source: Adapted from community discussion — kim32

   Next question

6. Question 6 · 170 in bank

   A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location. Which of the following data entities should the data engineer create?

   • ATable
   • BFunction
   • CView
   • DTemporary view

   Show answer

   Answer: A

   Explanation

   Correct Answer is C As View is persited they are physically stored and accessable across cluster even when restarted or detactched .

   Source: Adapted from community discussion — MohdAltaf19

   Next question

7. Question 7 · 170 in bank

   A data engineer runs a statement every day to copy the previous day’s sales into the table transactions. Each day’s sales are in their own file in the location "/transactions/raw". Today, the data engineer runs the following command to complete this task:

   

   After running the command today, the data engineer notices that the number of records in table transactions has not changed. What explains why the statement might not have copied any new records into the table?

   • AThe format of the files to be copied were not included with the FORMAT_OPTIONS keyword.
   • BThe COPY INTO statement requires the table to be refreshed to view the copied rows.
   • CThe previous day’s file has already been copied into the table.
   • DThe PARQUET file format does not support COPY INTO.

   Show answer

   Answer: C

   Next question

8. Question 8 · 170 in bank

   Which command can be used to write data into a Delta table while avoiding the writing of duplicate records?

   • ADROP
   • BINSERT
   • CMERGE
   • DAPPEND

   Show answer

   Answer: C

   Next question

9. Question 9 · 170 in bank

   A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL. Which command could the data engineering team use to access sales in PySpark?

   • ASELECT * FROM sales
   • Bspark.table("sales")
   • Cspark.sql("sales")
   • Dspark.delta.table("sales")

   Show answer

   Answer: B

   Next question

10. Question 10 · 170 in bank

    A data engineer has created a new database using the following command: CREATE DATABASE IF NOT EXISTS customer360; In which location will the customer360 database be located?

    • Adbfs:/user/hive/database/customer360
    • Bdbfs:/user/hive/warehouse
    • Cdbfs:/user/hive/customer360
    • Ddbfs:/user/hive/database

    Show answer

    Answer: B

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DE-ASSOC practice, question 1. 170 questions available.