← Back to exam page

Databricks-Certified-Professional-Data-Engineer – Databricks Certified Data Engineer Professional

Loading demo links...

Showing 10–12 of 15 questions

Question 10

You would like to build a spark streaming process to read from a Kafka queue and write to a Delta table every 15 minutes, what is the correct trigger option

Select an option, then click Submit answer.

  • ○

    trigger("15 minutes")
  • ○

    trigger(process "15 minutes")
  • ○

    trigger(processingTime = 15)
  • ○

    trigger(processingTime = "15 Minutes")
  • ○

    trigger(15)
Question 11

What could be the expected output of query SELECT COUNT (DISTINCT *) FROM user on this table

Table Description automatically generated

Select an option, then click Submit answer.

  • ○

    3
  • ○

    2
    (Correct)
  • ○

    1
  • ○

    0
  • ○

    NULL
Question 12

What is the main difference between the below two commands?

1. INSERT OVERWRITE table_name

2. SELECT * FROM table

1. CREATE OR REPLACE TABLE table_name

2. AS SELECT * FROM table

Select an option, then click Submit answer.

  • ○

    INSERT OVERWRITE replaces data by default, CREATE OR REPLACE replaces data and Schema by default
  • ○

    INSERT OVERWRITE replaces data and schema by default, CREATE OR REPLACEreplaces data by default
  • ○

    INSERT OVERWRITE maintains historical data versions by de-fault, CREATE OR REPLACEclears the historical data versions by default
  • ○

    INSERT OVERWRITE clears historical data versions by de-fault, CREATE OR REPLACE maintains the historical data versions by default
  • ○

    Both are same and results in identical outcomes