Databricks Certified Data Engineer Associate - Databricks-Certified-Data-Engineer-Associate무료 덤프문제 풀어보기
A Data Engineer is building a simple data pipeline using Delta Live Tables (DLT) in Databricksto ingest customer dat a. The raw customer data is stored in a cloud storage location in JSON format. The task is to create a DLT pipeline that reads the rawJSON data and writes it into a Delta table for further processing.
Which code snippet will correctly ingest the raw JSON data and create a Delta table using DLT?
Which code snippet will correctly ingest the raw JSON data and create a Delta table using DLT?
정답: B
A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.
Which of the following relational objects should the data engineer create?
Which of the following relational objects should the data engineer create?
정답: D
설명: (Fast2test 회원만 볼 수 있음)
A data engineer has written a function in a Databricks Notebook to calculate the population of bacteria in a given medium.
Analysts use this function in the notebook and sometimes provide input arguments of the wrong data type, which can cause errors during execution.
Which Databricks feature will help the data engineer quickly identify if an incorrect data type has been provided as input?
Analysts use this function in the notebook and sometimes provide input arguments of the wrong data type, which can cause errors during execution.
Which Databricks feature will help the data engineer quickly identify if an incorrect data type has been provided as input?
정답: C
Which of the following is a benefit of the Databricks Lakehouse Platform embracing open source technologies?
정답: E
설명: (Fast2test 회원만 볼 수 있음)
A data engineer has a Declarative Automation Bundle with a job resource keyed as etl_job in databricks.yml. After running databricks bundle deploy, the job appears in the workspace but has not executed.
Which command triggers execution of the deployed job?
Which command triggers execution of the deployed job?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
A global retail company sells products across multiple categories (e.g.. Electronics, Clothing) and regions (e.g.. North. South, East. West). The sales team has provided the data engineer with a PySpark dataframe named sales_df as below and the team wants the data engineer to analyze the sales data to help them make strategic decisions.
정답: D
A data engineering team is building a new data-transformation notebook. During development, the engineers need fast testing, quick code changes, and easy debugging. Later, the notebook will run nightly as a scheduled job without human intervention. The team wants to optimize for development speed.
Which compute should the team use during development?
Which compute should the team use during development?
정답: C
A data engineer needs to create a table in Databricks using data from their organization's existing SQLite database. They run the following command:
CREATE TABLE jdbc_customer360
USING
OPTIONS (
url "jdbc:sqlite:/customers.db", dbtable "customer360"
)
Which line of code fills in the above blank to successfully complete the task?
CREATE TABLE jdbc_customer360
USING
OPTIONS (
url "jdbc:sqlite:/customers.db", dbtable "customer360"
)
Which line of code fills in the above blank to successfully complete the task?
정답: C
설명: (Fast2test 회원만 볼 수 있음)
A data engineer wants to create a new table containing the names of customers who live in France.
They have written the following command:
CREATE TABLE customersInFrance
_____ AS
SELECT id,
firstName,
lastName
FROM customerLocations
WHERE country = 'FRANCE';
A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (Pll).
Which line of code fills in the above blank to successfully complete the task?
They have written the following command:
CREATE TABLE customersInFrance
_____ AS
SELECT id,
firstName,
lastName
FROM customerLocations
WHERE country = 'FRANCE';
A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (Pll).
Which line of code fills in the above blank to successfully complete the task?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
A company uses Delta Sharing to collaborate with partners across different cloud providers and geographic regions. What will result in additional costs due to cross-region or egress fees?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
In which of the following file formats is data from Delta Lake tables primarily stored?
정답: E
설명: (Fast2test 회원만 볼 수 있음)