最新なDatabricks Databricks-Certified-Data-Engineer-Associate問題集（228題）、真実試験の問題を全部にカバー！

質問 1：
What are the transformations typically included in building the Bronze layer?
A. Business rules and transformations
B. Aggregate data from multiple sources
C. Include columns Load date/time, process ID
D. Perform extensive data cleansing
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 2：
A new data engineering team team. has been assigned to an ELT project. The new data engineering team will need full privileges on the database customers to fully manage the project.
Which of the following commands can be used to grant full permissions on the database to the new data engineering team?
A. GRANT ALL PRIVILEGES ON DATABASE team TO customers;
B. GRANT USAGE ON DATABASE customers TO team;
C. GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;
D. GRANT ALL PRIVILEGES ON DATABASE customers TO team;
E. GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;
正解：D

質問 3：
A data engineer is writing a DataFrame to a Delta table and wants to physically divide the data into directories based on a specific column such as country. Which Spark DataFrame writer option should be used?
A. orderBy
B. partitionBy
C. groupBy
D. distributeBy
正解：B

質問 4：
A data engineer is working on a personal laptop and needs to perform complex transformations on data stored in a Delta Lake on cloud storage. The engineer decides to use Databricks Connect to interact with Databricks clusters and work in their local IDE. How does Databricks Connect enable the engineer to develop, test, and debug code seamlessly on their local machine while interacting with Databricks clusters?
A. By providing a local environment that mimics the Databricks runtime, enabling the engineer to develop, test, and debug code only through Databricks' own web interface
B. By providing a local environment that mimics the Databricks runtime, enabling the engineer to develop, test, and debug code using a specific IDE that is required by Databricks
C. By providing a local environment that mimics the Databricks runtime, enabling the engineer to develop, test, and debug code using their preferred IDE
D. By allowing direct execution of Spark jobs from the local machine without needing a network connection
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 5：
Which of the following can be used to simplify and unify siloed data architectures that are specialized for specific use cases?
A. Data warehouse
B. Data lake
C. All of these
D. None of these
E. Data lakehouse
正解：E

質問 6：
Identify a scenario to use an external table.
A Data Engineer needs to create a parquet bronze table and wants to ensure that it gets stored in a specific path in an external location.
Which table can be created in this scenario?
A. An external table where the location is pointing to specific path in external location.
B. A managed table where the location is pointing to specific path in external location.
C. An external table where the schema has managed location pointing to specific path in external location.
D. A managed table where the catalog has managed location pointing to specific path in external location.
正解：A
解説: (Pass4Test メンバーにのみ表示されます)

質問 7：
A data engineer is decommissioning a sandbox schema in Unity Catalog. Some tables are ephemeral staging outputs that can be safety removed entirely, but a few tables point at shared cloud storage used by downstream jobs outside Databricks. The engineer must avoid deleting any shared files when cleaning up catalog objects.
How does Unity Catalog behave when dropping Managed vs External tables?
A. DROP all tables; Databricks will only remove metadata for both managed and external tables.
B. DROP managed staging tables to remove data and metadata, and DROP external tables to remove only metadata
C. DROP external tables first to delete their files, then DROP managed tables to keep their files for recovery.
D. DROP managed tables that are ephemeral and DROP external tables; files for both remain for 7 days.
正解：B
解説: (Pass4Test メンバーにのみ表示されます)

質問 8：
A data engineer is configuring Unity Catalog in Databricks and needs to assign a role to a user who should have the ability to grant and revoke privileges on various data objects within a specific schema, but should not have read/write access over the schema or its objects. Which role should the data engineer assign to this user?
A. Schema Owner
B. USE catalog/schema privilege on the schema
C. Catalog Owner
D. Table Owner
正解：A
解説: (Pass4Test メンバーにのみ表示されます)