← Back to exam page

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

Loading demo links...

Showing 13–15 of 15 questions

Question 13

Your colleague was walking you through how a job was setup, but you noticed a warning message that said, “Jobs running on all-purpose cluster are considered all purpose compute", the colleague was not sure why he was getting the warning message, how do you best explain this warning mes-sage?

Select an option, then click Submit answer.

  • ○

    All-purpose clusters cannot be used for Job clusters, due to performance issues.
  • ○

    All-purpose clusters take longer to start the cluster vs a job cluster
  • ○

    All-purpose clusters are less expensive than the job clusters
  • ○

    All-purpose clusters are more expensive than the job clusters
  • ○

    All-purpose cluster provide interactive messages that can not be viewed in a job
Question 14

What is the main difference between AUTO LOADER and COPY INTO?

Select an option, then click Submit answer.

  • ○

    COPY INTO supports schema evolution.
  • ○

    AUTO LOADER supports schema evolution.
  • ○

    COPY INTO supports file notification when performing incremental loads.
  • ○

    AUTO LOADER supports reading data from Apache Kafka
  • ○

    AUTO LOADER Supports file notification when performing incremental loads.
Question 15

identifies if its needs to be converted to Fahrenheit or Celcius with a one-word letter F or C?

select udf_convert(60,'C') will result in 15.5

select udf_convert(10,'F') will result in 50

 

Select an option, then click Submit answer.

  • ○

    1. CREATE UDF FUNCTION udf_convert(temp DOUBLE, measure STRING)
    2. RETURNS DOUBLE
    3. RETURN CASE WHEN measure == 'F' then (temp * 9/5) + 32
    4. ELSE (temp – 33 ) * 5/9
    5. END
     
  • ○

    1. CREATE UDF FUNCTION udf_convert(temp DOUBLE, measure STRING)
    2. RETURN CASE WHEN measure == 'F' then (temp * 9/5) + 32
    3. ELSE (temp – 33 ) * 5/9
    4. END
     
  • ○

    1. CREATE FUNCTION udf_convert(temp DOUBLE, measure STRING)
    2. RETURN CASE WHEN measure == 'F' then (temp * 9/5) + 32
    3. ELSE (temp – 33 ) * 5/9
    4. END
     
  • ○

    1. CREATE FUNCTION udf_convert(temp DOUBLE, measure STRING)
    2. RETURNS DOUBLE
    3. RETURN CASE WHEN measure == 'F' then (temp * 9/5) + 32
    4. ELSE (temp – 33 ) * 5/9
    5. END
     
  • ○

    1. CREATE USER FUNCTION udf_convert(temp DOUBLE, measure STRING)
    2. RETURNS DOUBLE
    3. RETURN CASE WHEN measure == 'F' then (temp * 9/5) + 32
    4. ELSE (temp – 33 ) * 5/9
    5. END