Databricks Certified Data Engineer Associate - Databricks-Certified-Data-Engineer-Associate무료 덤프문제 풀어보기
A data engineer needs to append new records to an existing Delta table while preserving existing data. The ingestion pipeline runs every hour and adds incremental data without replacing previous records. Which write mode should be used?
정답: B
An organization is looking for an optimized storage layer that supports ACID transactions and schema enforcement. Which technology should the organization use?
정답: D
설명: (Fast2test 회원만 볼 수 있음)
A data engineer is using Spark SQL to analyze a large dataset stored in Delta format. The engineer notices that queries filtering on partition columns run significantly faster. What is the primary reason for this performance improvement?
정답: B
A data engineer needs to ingest from both streaming and batch sources for a firm that relies on highly accurate data. Occasionally, some of the data picked up by the sensors that provide a streaming input are outside the expected parameters. If this occurs, the data must be dropped, but the stream should not fail. Which feature of Delta Live Tables meets this requirement?
정답: D
설명: (Fast2test 회원만 볼 수 있음)
Which of the following is a benefit of the Databricks Lakehouse Platform embracing open source technologies?
정답: E
A data engineer manages multiple external tables linked to various data sources. The data engineer wants to manage these external tables efficiently and ensure that only the necessary permissions are granted to users for accessing specific external tables. How should the data engineer manage access to these external tables?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
A data engineer notices that a Spark job performing a join between a large table and a small lookup table is slow. The lookup table is only a few megabytes. Which Spark optimization technique should be applied to improve the performance of the join operation?
정답: A
A data engineer must deliver a trustworthy customer 360 dataset in Databricks for data scientists and BI teams. The engineer plans to join deduplicated customer records with cleaned transaction data, enforce schema and data quality checks, and create a conformed
"customer_transactions"view. Later, highly aggregated, domain-specific tables (for weekly spend and executive summaries) will be produced for dashboards.
Where should the engineer build the conformed "customer_transactions" dataset, and where should the aggregated, report-ready tables reside?
"customer_transactions"view. Later, highly aggregated, domain-specific tables (for weekly spend and executive summaries) will be produced for dashboards.
Where should the engineer build the conformed "customer_transactions" dataset, and where should the aggregated, report-ready tables reside?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
A data architect has determined that a table of the following format is necessary:
Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?
Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?
정답: B