vuthanhdatt's Second Brain

37

11 min read

Questions and Answers

Question TkgrjU4LH7WTUo7kTbgX

Question

A CHECK constraint has been successfully added to the Delta table named activity_details using the following logic:

//IMG//

A batch job is attempting to insert new records to the table, including a record where latitude = 45.50 and longitude = 212.67.

Which statement describes the outcome of this batch insert?

Choices

  • A: The write will fail when the violating record is reached; any records previously processed will be recorded to the target table.
  • B: The write will fail completely because of the constraint violation and no records will be inserted into the target table.
  • C: The write will insert all records except those that violate the table constraints; the violating records will be recorded to a quarantine table.
  • D: The write will include all records in the target table; any violations will be indicated in the boolean column named valid_coordinates.
  • E: The write will insert all records except those that violate the table constraints; the violating records will be reported in a warning log.

Question mEBacLIbj9unFhLMHvNr

Question

A junior data engineer has manually configured a series of jobs using the Databricks Jobs UI. Upon reviewing their work, the engineer realizes that they are listed as the “Owner” for each job. They attempt to transfer “Owner” privileges to the “DevOps” group, but cannot successfully accomplish this task.

Which statement explains what is preventing this privilege transfer?

Choices

  • A: Databricks jobs must have exactly one owner; “Owner” privileges cannot be assigned to a group.
  • B: The creator of a Databricks job will always have “Owner” privileges; this configuration cannot be changed.
  • C: Other than the default “admins” group, only individual users can be granted privileges on jobs.
  • D: A user can only transfer job ownership to a group if they are also a member of that group.
  • E: Only workspace administrators can grant “Owner” privileges to a group.

Question dsw2t6OuXp5324bZGsmK

Question

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?

Choices

  • A: All data should be deleted biweekly; Delta Lake’s time travel functionality should be leveraged to maintain a history of non-PII information.
  • B: Data should be partitioned by the registration field, allowing ACLs and delete statements to be set for the PII directory.
  • C: Because the value field is stored as binary data, this information is not considered PII and no special precautions should be taken.
  • D: Separate object storage containers should be specified based on the partition field, allowing isolation at the storage level.
  • E: Data should be partitioned by the topic field, allowing ACLs and delete statements to leverage partition boundaries.

Question TOyKVMPJNKo6t2yskOZE

Question

The data architect has decided that once data has been ingested from external sources into the Databricks Lakehouse, table access controls will be leveraged to manage permissions for all production tables and views.

The following logic was executed to grant privileges for interactive queries on a production database to the core engineering group.

GRANT USAGE ON DATABASE prod TO eng; GRANT SELECT ON DATABASE prod TO eng;

Assuming these are the only privileges that have been granted to the eng group and that these users are not workspace administrators, which statement describes their privileges?

Choices

  • A: Group members have full permissions on the prod database and can also assign permissions to other users or groups.
  • B: Group members are able to list all tables in the prod database but are not able to see the results of any queries on those tables.
  • C: Group members are able to query and modify all tables and views in the prod database, but cannot create new tables or views.
  • D: Group members are able to query all tables and views in the prod database, but cannot create or edit anything in the database.
  • E: Group members are able to create, query, and modify all tables and views in the prod database, but cannot define custom functions.

Question 6fZfhPy9TtiCd3Y1AyoH

Question

A distributed team of data analysts share computing resources on an interactive cluster with autoscaling configured. In order to better manage costs and query throughput, the workspace administrator is hoping to evaluate whether cluster upscaling is caused by many concurrent users or resource-intensive queries.

In which location can one review the timeline for cluster resizing events?

Choices

  • A: Workspace audit logs
  • B: Driver’s log file
  • C: Ganglia
  • D: Cluster Event Log
  • E: Executor’s log file

Graph View