DE-ASSOC practice questions 41–50

1. Question 41 · 170 in bank

   A data engineer wants to create a new table containing the names of customers that live in France. They have written the following command:

   

   A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (PII). Which of the following lines of code fills in the above blank to successfully complete the task?

   • AThere is no way to indicate whether a table contains PII.
   • B"COMMENT PII"
   • CTBLPROPERTIES PII
   • DCOMMENT "Contains PII"
   • EPII

   Show answer

   Answer: D

   Explanation

   The correct answer is D. COMMENT "Contains PII". Context matters. Yes, you can use Table Property to add additional metadata. But you cannot view that property when you describe the table. With the Comment "this is ..." anyone who describe the table will see the comment.

   Source: Adapted from community discussion — Huroye

   References

   • Databricks documentation
   • Microsoft Learn

   Next question

2. Question 42 · 170 in bank

   What can be used to simplify and unify siloed data architectures that are specialized for specific use cases?

   • ADelta Lake
   • BData lake
   • CData warehouse
   • DData lakehouse

   Show answer

   Answer: D

   Next question

3. Question 43 · 170 in bank

   A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table. The code block used by the data engineer is below:

   

   The data engineer only wants the query to process all of the available data in as many batches as required. Which line of code should the data engineer use to fill in the blank?

   • Atrigger(availableNow=True)
   • Btrigger(processingTime= “once”)
   • Ctrigger(continuous= “once”)
   • Dtrigger(once=True)

   Show answer

   Answer: A

   Next question

4. Question 44 · 170 in bank

   Data engineer and data analysts are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL. The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables. Which of the following changes will need to be made to the pipeline when migrating to Delta Live Tables?

   • AThe pipeline can have different notebook sources in SQL & Python
   • BThe pipeline will need to be written entirely in SQL
   • CThe pipeline will need to use a batch source in place of a streaming source
   • DThe pipeline will need to be written entirely in Python

   Show answer

   Answer: A

   Explanation

   The correct answer is A. The pipeline can have different notebook sources in SQL & Python. Delta Live Tables supports both SQL and Python, as well as streaming and batch sources. Therefore, the existing pipeline can continue to use both SQL and Python for different layers without needing to be rewritten entirely in one language or switching from a streaming to a batch source.

   Source: Adapted from community discussion — MultiCloudIronMan

   Next question

5. Question 45 · 170 in bank

   Identify a scenario to use an external table. A Data Engineer needs to create a parquet bronze table and wants to ensure that it gets stored in a specific path in an external location. Which table can be created in this scenario?

   • AAn external table where the location is pointing to specific path in external location.
   • BAn external table where the schema has managed location pointing to specific path in external location.
   • CA managed table where the catalog has managed location pointing to specific path in external location.
   • DA managed table where the location is pointing to specific path in external location.

   Show answer

   Answer: A

   Next question

6. Question 46 · 170 in bank

   Identify the impact of ON VIOLATION DROP ROW and ON VIOLATION FAIL UPDATE for a constraint violation. A data engineer has created an ETL pipeline using Delta Live table to manage their company travel reimbursement detail, they want to ensure that the if the location details has not been provided by the employee, the pipeline needs to be terminated. How can the scenario be implemented?

   • ACONSTRAINT valid_location EXPECT (location = NULL)
   • BCONSTRAINT valid_location EXPECT (location != NULL) ON VIOLATION FAIL UPDATE
   • CCONSTRAINT valid_location EXPECT (location != NULL) ON DROP ROW
   • DCONSTRAINT valid_location EXPECT (location != NULL) ON VIOLATION FAIL

   Show answer

   Answer: B

   Explanation

   B is correct https://docs.databricks.com/en/delta-live-tables/sql-ref.html ON VIOLATION Optional action to take for failed rows: FAIL UPDATE: Immediately stop pipeline execution. DROP ROW: Drop the record and continue processing.

   Source: Adapted from community discussion — Worldmaster

   References

   • Microsoft Learn
   • Databricks documentation

   Next question

7. Question 47 · 170 in bank

   Select 2

   Which two conditions are applicable for governance in Databricks Unity Catalog? (Choose two.)

   • AYou can have more than 1 metastore within a databricks account console but only 1 per region.
   • BBoth catalog and schema must have a managed location in Unity Catalog provided metastore is not associated with a location
   • CYou can have multiple catalogs within metastore and 1 catalog can be associated with multiple metastore
   • DIf catalog is not associated with location, it’s mandatory to associate schema with managed locations
   • EIf metastore is not associated with location, it’s mandatory to associate catalog with managed locations

   Show answer

   Answer: AE

   Explanation

   Databricks recommends that you assign managed storage at the catalog level for logical data isolation, with metastore-level and schema-level as options. New workspaces that are enabled for Unity Catalog automatically are created without a metastore-level managed storage location. It means that it's a must to create a managed location for a catalog for otpimal data isolations, otherwise you'll finish up with many schemas/tables data in the same managed location which is a bad prctice from governance perspective. Working with not isolated catalog in Unity Catalog is chaotic, i would prefer to be on my workspace rather than working in such bad governed Unity Catalog. Ans : ["A", "E"]

   Source: Adapted from community discussion — CaoMengde09

   Next question

8. Question 48 · 170 in bank

   A data engineer needs to access the view created by the sales team, using a shared cluster. The data engineer has been provided usage permissions on the catalog and schema. In order to access the view created by sales team. What are the minimum permissions the data engineer would require in addition?

   • ANeeds SELECT permission on the VIEW and the underlying TABLE.
   • BNeeds SELECT permission only on the VIEW
   • CNeeds ALL PRIVILEGES on the VIEW
   • DNeeds ALL PRIVILEGES at the SCHEMA level

   Show answer

   Answer: B

   Explanation

   B is correct. in databricks partner platform, it shows privileges on a view and says: as you see, no one has access to this table, but we could give access to the view without giving access to the underlying table. this is one of the main advantages of views.

   Source: Adapted from community discussion — SajadAhm

   Next question

9. Question 49 · 170 in bank

   Which method should a Data Engineer apply to ensure Workflows are being triggered on schedule?

   • AScheduled Workflows require an always-running cluster, which is more expensive but reduces processing latency.
   • BScheduled Workflows process data as it arrives at configured sources.
   • CScheduled Workflows can reduce resource consumption and expense since the cluster runs only long enough to execute the pipeline.
   • DScheduled Workflows run continuously until manually stopped.

   Show answer

   Answer: C

   Explanation

   The correct answer is C. Scheduled Workflows can reduce resource consumption and expense since the cluster runs only long enough to execute the pipeline. This method ensures that the cluster is only active for the duration of the workflow execution, minimizing resource usage and costs.

   Source: Adapted from community discussion — MultiCloudIronMan

   Next question

10. Question 50 · 170 in bank

    Select 2

    The Delta transaction log for the ‘students’ tables is shown using the ‘DESCRIBE HISTORY students’ command. A Data Engineer needs to query the table as it existed before the UPDATE operation listed in the log. Which command should the Data Engineer use to achieve this? (Choose two.)

    

    • ASELECT * FROM students@v4
    • BSELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:47.000+00:00’
    • CSELECT * FROM students FROM HISTORY VERSION AS OF 3
    • DSELECT * FROM students VERSION AS OF 5
    • ESELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:58.000+00:00’

    Show answer

    Answer: AB

    Explanation

    SELECT * FROM people10m VERSION AS OF 123; Is identical to SELECT * FROM people10m@v123; so . SELECT * FROM students@v4 is the same as running . SELECT * FROM students@v4 VERSION AS OF 5 ["A", "B"]

    Source: Adapted from community discussion — CaoMengde09

    References

    • Databricks documentation

    Next question

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

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