최신 Databricks-Certified-Professional-Data-Engineer 무료덤프 - Databricks Certified Professional Data Engineer

문제1

Which statement characterizes the general programming model used by Spark Structured Streaming?

A. Structured Streaming relies on a distributed network of nodes that hold incremental state values for cached stages.

B. Structured Streaming is implemented as a messaging bus and is derived from Apache Kafka.

C. Structured Streaming leverages the parallel processing of GPUs to achieve highly parallel data throughput.

D. Structured Streaming uses specialized hardware and I/O streams to achieve sub-second latency for data transfer.

E. Structured Streaming models new data arriving in a data stream as new rows appended to an unbounded table.

정답: E

설명: (DumpTOP 회원만 볼 수 있음)

문제2

The data engineering team is migrating an enterprise system with thousands of tables and views into the Lakehouse. They plan to implement the target architecture using a series of bronze, silver, and gold tables.
Bronze tables will almost exclusively be used by production data engineering workloads, while silver tables will be used to support both data engineering and machine learning workloads. Gold tables will largely serve business intelligence and reporting purposes. While personal identifying information (PII) exists in all tiers of data, pseudonymization and anonymization rules are in place for all data at the silver and gold levels.
The organization is interested in reducing security concerns while maximizing the ability to collaborate across diverse teams.
Which statement exemplifies best practices for implementing this system?

A. Because all tables must live in the same storage containers used for the database they're created in, organizations should be prepared to create between dozens and thousands of databases depending on their data isolation requirements.

B. Working in the default Databricks database provides the greatest security when working with managed tables, as these will be created in the DBFS root.

C. Storinq all production tables in a single database provides a unified view of all data assets available throughout the Lakehouse, simplifying discoverability by granting all users view privileges on this database.

D. Because databases on Databricks are merely a logical construct, choices around database organization do not impact security or discoverability in the Lakehouse.

E. Isolating tables in separate databases based on data quality tiers allows for easy permissions management through database ACLs and allows physical separation of default storage locations for managed tables.

정답: E

설명: (DumpTOP 회원만 볼 수 있음)

문제3

Assuming that the Databricks CLI has been installed and configured correctly, which Databricks CLI command can be used to upload a custom Python Wheel to object storage mounted with the DBFS for use with a production job?

A. libraries

B. jobs

C. fs

D. workspace

E. configure

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제4

A table nameduser_ltvis being used to create a view that will be used by data analysts on various teams.
Users in the workspace are configured into groups, which are used for setting up data access using ACLs.
Theuser_ltvtable has the following schema:
email STRING, age INT, ltv INT
The following view definition is executed:

An analyst who is not a member of the marketing group executes the following query:
SELECT * FROM email_ltv
Which statement describes the results returned by this query?

A. Three columns will be returned, but one column will be named "redacted" and contain only null values.

B. The email and ltv columns will be returned with the values in user itv.

C. Only the email and ltv columns will be returned; the email column will contain the string
"REDACTED" in each row.

D. The email, age. and ltv columns will be returned with the values in user ltv.

E. Only the email and itv columns will be returned; the email column will contain all null values.

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제5

The DevOps team has configured a production workload as a collection of notebooks scheduled to run daily using the Jobs Ul. A new data engineering hire is onboarding to the team and has requested access to one of these notebooks to review the production logic.
What are the maximum notebook permissions that can be granted to the user without allowing accidental changes to production code or data?

A. Can run

B. Can Read

C. Can edit

D. Can manage

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제6

Which REST API call can be used to review the notebooks configured to run as tasks in a multi-task job?

A. /jobs/get

B. /jobs/runs/get

C. /jobs/list

D. /jobs/runs/list

E. /jobs/runs/get-output

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제7

All records from an Apache Kafka producer are being ingested into a single Delta Lake table with the following schema:
key BINARY, value BINARY, topic STRING, partition LONG, offset LONG, timestamp LONG There are 5 unique topics being ingested. Only the "registration" topic contains Personal Identifiable Information (PII). The company wishes to restrict access to PII. The company also wishes to only retain records containing PII in this table for 14 days after initial ingestion. However, for non-PII information, it would like to retain these records indefinitely.
Which of the following solutions meets the requirements?

A. Separate object storage containers should be specified based on the partition field, allowing isolation at the storage level.

B. All data should be deleted biweekly; Delta Lake's time travel functionality should be leveraged to maintain a history of non-PII information.

C. Data should be partitioned by the registration field, allowing ACLs and delete statements to be set for the PII directory.

D. Data should be partitioned by the topic field, allowing ACLs and delete statements to leverage partition boundaries.

E. Because the value field is stored as binary data, this information is not considered PII and no special precautions should be taken.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제8

A Databricks SQL dashboard has been configured to monitor the total number of records present in a collection of Delta Lake tables using the following query pattern:
SELECT COUNT (*) FROM table -
Which of the following describes how results are generated each time the dashboard is updated?

A. The total count of records is calculated from the Hive metastore

B. The total count of rows is calculated by scanning all data files

C. The total count of records is calculated from the parquet file metadata

D. The total count of rows will be returned from cached results unless REFRESH is run

E. The total count of records is calculated from the Delta transaction logs

정답: E

설명: (DumpTOP 회원만 볼 수 있음)

문제9

A data engineer wants to create a cluster using the Databricks CLI for a big ETL pipeline. The cluster should havefive workers,one driverof type i3.xlarge, and should use the '14.3.x-scala2.12' runtime.
Which command should the data engineer use?

A. databricks compute add 14.3.x-scala2.12 --num-workers 5 --node-type-id i3.xlarge --cluster-name Data Engineer_cluster

B. databricks clusters create 14.3.x-scala2.12 --num-workers 5 --node-type-id i3.xlarge --cluster-name DataEngineer_cluster

C. databricks clusters add 14.3.x-scala2.12 --num-workers 5 --node-type-id i3.xlarge --cluster-name Data Engineer_cluster

D. databricks compute create 14.3.x-scala2.12 --num-workers 5 --node-type-id i3.xlarge --cluster-name Data Engineer_cluster

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제10

A junior data engineer has been asked to develop a streaming data pipeline with a grouped aggregation using DataFrame df. The pipeline needs to calculate the average humidity and average temperature for each non- overlapping five-minute interval. Incremental state information should be maintained for 10 minutes for late- arriving data.
Streaming DataFrame df has the following schema:
"device_id INT, event_time TIMESTAMP, temp FLOAT, humidity FLOAT"
Code block:

Choose the response that correctly fills in the blank within the code block to complete this task.

A. slidingWindow("event_time", "10 minutes")

B. delayWrite("event_time", "10 minutes")

C. await("event_time + '10 minutes'")

D. awaitArrival("event_time", "10 minutes")

E. withWatermark("event_time", "10 minutes")

정답: E

설명: (DumpTOP 회원만 볼 수 있음)

최신 Databricks-Certified-Professional-Data-Engineer 무료덤프 - Databricks Certified Professional Data Engineer

우리와 연락하기

유용한 링크

최신 업데이트