Although the Databricks Utilities Secrets module provides tools to store sensitive credentials and avoid accidentally displaying them in plain text users should still be careful with which credentials are stored here and which users have access to using these secrets.
Which statement describes a limitation of Databricks Secrets?
A. Because the SHA256 hash is used to obfuscate stored secrets, reversing this hash will display the value in plain text.
B. The Databricks REST API can be used to list secrets in plain text if the personal access token has proper credentials.
C. Iterating through a stored secret and printing each character will display secret contents in plain text.
D. Account administrators can see all secrets in plain text by logging on to the Databricks Accounts console.
E. Secrets are stored in an administrators-only table within the Hive Metastore; database administrators have permission to query this table by default.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
The data governance team has instituted a requirement that all tables containing Personal Identifiable Information (PH) must be clearly annotated. This includes adding column comments, table comments, and setting the custom table property "contains_pii" = true.
The following SQL DDL statement is executed to create a new table:

Which command allows manual confirmation that these three requirements have been met?
A. DESCRIBE HISTORY dev.pii test
B. SHOW TABLES dev
C. SHOW TBLPROPERTIES dev.pii test
D. DESCRIBE EXTENDED dev.pii test
E. DESCRIBE DETAIL dev.pii test
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
A company wants to implement Lakehouse Federation across multiple data sources but is concerned about data consistency and ensuring that all teams access the same authoritative version of their data.
Which statement is applicable for Lakehouse Federations to maintain data consistency?
A. Federation creates local copies that must be manually refreshed.
B. A separate data synchronization service must be deployed.
C. Federation implements change data capture (CDC) from all sources.
D. Federation provides read-only access that reflects the current state of source systems.
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
When evaluating the Ganglia Metrics for a given cluster with 3 executor nodes, which indicator would signal proper utilization of the VM's resources?
A. Total Disk Space remains constant
B. The five Minute Load Average remains consistent/flat
C. CPU Utilization is around 75%
D. Network I/O never spikes
E. Bytes Received never exceeds 80 million bytes per second
正解:C
質問 5:
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. Because the value field is stored as binary data, this information is not considered PII and no special precautions should be taken.
B. Data should be partitioned by the registration field, allowing ACLs and delete statements to be set for the PII directory.
C. Data should be partitioned by the topic field, allowing ACLs and delete statements to leverage partition boundaries.
D. Separate object storage containers should be specified based on the partition field, allowing isolation at the storage level.
E. All data should be deleted biweekly; Delta Lake's time travel functionality should be leveraged to maintain a history of non-PII information.
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
To identify the top users consuming compute resources, a data engineering team needs to monitor usage within their Databricks workspace for better resource utilization and cost control. The team decided to use Databricks system tables, available under the system catalog in Unity Catalog, to gain detailed visibility into workspace activity. Which SQL query should the team run from the system catalog to achieve this?
A. SELECT
sku_name,
usage_metadata.run_name AS user_email,
SUM(usage_quantity) AS total_dbus
FROM system.billing.usage
GROUP BY user_email, sku_name
ORDER BY total_dbus DESC
LIMIT 10
B. SELECT
sku_name,
identity_metadata.created_by AS user_email,
COUNT(usage_quantity) AS total_dbus
FROM system.billing.usage
GROUP BY user_email, sku_name
ORDER BY total_dbus DESC
LIMIT 10
C. SELECT
identity_metadata.run_as AS user_email,
SUM(usage_quantity) AS total_dbus
FROM system.billing.usage
GROUP BY user_email
ORDER BY total_dbus DESC
LIMIT 10
D. SELECT
sku_name,
identity_metadata.created_by AS user_email,
SUM(usage_quantity * usage_unit) AS total_dbus
FROM system.billing.usage
GROUP BY user_email, sku_name
ORDER BY total_dbus DESC
LIMIT 10
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
1002 お客様のコメント









Yuuki -
Databricks-Certified-Professional-Data-Engineer試験用のテキストです。試験合格しました。よかったです。ありがとうございました。