Databricks-Certified-Data-Engineer-Associate 무료 덤프문제 온라인 액세스

A data engineer needs to parse only png files in a directory that contains files with different suffixes. Which code should the data engineer use to achieve this task?

• A.df = spark.readstream. format("cloudFiles") \
  .option("cloudFiles.format", "binaryFile") \
  .option("pathGlobfilter", "*.png") \
  .load(<base-path>)
• B.df = spark.readstream.format("cloudFiles") \ .option("cloudFiles.format", "binaryFile") \
  .load("/*.png")
• C.df = spark.readStream.format("cloudFiles") \ .option("cloudFiles.format", "binaryFile") \
  .option("pathGlobfilter", "*.png") \ .append()
• D.df = spark.readStream.format("cloudFiles") \ .option("cloudFiles.format", "binaryFile") \
  .append("/*.png")

A data engineer is configuring a cluster in Databricks and wants to ensure that multiple Spark executors can run tasks concurrently across worker nodes. Which cluster component is responsible for executing tasks?

• A.Driver
• B.Executor
• C.Notebook
• D.Job scheduler

A data engineer is designing a medallion architecture. Raw Kafka events must be stored exactly as received for reprocessing, then cleaned and deduplicated, then aggregated for BI dashboards.
Which mapping of layers is correct?

• A.Bronze = external tables only, Silver = views only, Gold = temporary views only
• B.Bronze = cleaned records, Silver = business aggregates, Gold = raw ingest
• C.Bronze = raw ingest, Silver = cleaned and conformed records, Gold = business-level aggregates
• D.Bronze = aggregated metrics, Silver = raw ingest, Gold = cleaned records

Identify how the count_if function and the count where x is null can be used.
Consider a table random_values with below data.
What would be the output of below query?
select count_if(col1 > 1) as count_a, count(*) as count_b,count(col1)
as count_c from random_values
col1
0
1
2
NULL
2
3

• A.4 6 5
• B.4 6 6
• C.3 6 5
• D.3 6 6

A data engineer needs to conduct Exploratory Analysis on data residing in a database that is within the company's custom-defined network in the cloud. The data engineer is using SQL for this task. Which type of SQL Warehouse will enable the data engineer to process large numbers of queries quickly and cost-effectively?

• A.Serverless compute for notebooks
• B.Pro SQL Warehouse
• C.Classic SQL Warehouse
• D.Serverless SQL Warehouse