Databricks-Certified-Data-Analyst-Associate無料問題集「Databricks Certified Data Analyst Associate」

質問 1

A data analyst is attempting to drop a table my_table. The analyst wants to delete all table metadata and data.
They run the following command:
DROP TABLE IF EXISTS my_table;
While the object no longer appears when they run SHOW TABLES, the data files still exist.
Which of the following describes why the data files still exist and the metadata files were deleted?

（A）The table ' s data was larger than 10 GB

（B）The table did not have a location

（C）The table ' s data was smaller than 10 GB

（D）The table was external

（E）The table was managed

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

Which data lakehouse feature results in improved data quality over a traditional data lake?

（A）A data lakehouse stores data in open formats.

（B）A data lakehouse provides storage solutions for structured and unstructured data.

（C）A data lakehouse allows the use of SQL queries to examine data.

（D）A data lakehouse supports ACID-compliant transactions.

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

A data organization has a team of engineers developing data pipelines following the medallion architecture using Delta Live Tables. While the data analysis team working on a project is using gold-layer tables from these pipelines, they need to perform some additional processing of these tables prior to performing their analysis.
Which of the following terms is used to describe this type of work?

（A）Data enhancement

（B）Last-mile

（C）Last-mile ETL

（D）Data testing

（E）Data blending

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

A data analyst wants to generate insights from large, complex datasets. The analyst needs to quickly understand the meaning of various data columns, ask questions in natural language, and receive AI-driven recommendations for optimizing data queries and workflows.
Which Databricks component is primarily responsible for enabling these capabilities?

（A）Genie Spaces

（B）Databricks Assistant

（C）Unity Catalog

（D）Data Intelligence Engine

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

A data analyst has recently joined a new team that uses Databricks SQL, but the analyst has never used Databricks before. The analyst wants to know where in Databricks SQL they can write and execute SQL queries.
On which of the following pages can the analyst write and execute SQL queries?

（A）Data page

（B）SQL Editor page

（C）Dashboards page

（D）Queries page

（E）Alerts page

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

A Data Analyst is working on sensor_df; this DataFrame contains two columns: record_datetime timestamp and record array.
Which code fragment returns a DataFrame that splits the record column into separate columns and has one array item per row?

（A）exploded_df = sensor_df.withColumn( " record_exploded " , explode( " record " ))exploded_df = exploded_df.select( " record_datetime " , " record_exploded.sensor_id " , " record_exploded.status " , " record_exploded.health " )

（B）exploded_df = exploded_df.select( " record_datetime " , " record_exploded " )

（C）Selects nested fields before correctly creating the exploded column.

（D）Uses withColumn, but selects sensor_id, status, and health as if they are already top-level columns.

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

Which of the following describes the relationship between Gold tables and Silver tables?

（A）Gold tables are more likely to contain truthful data than Silver tables.

（B）Gold tables are more likely to contain valuable data than Silver tables.

（C）Gold tables are more likely to contain aggregations than Silver tables.

（D）Gold tables are more likely to contain a less refined view of data than Silver tables.

（E）Gold tables are more likely to contain more data than Silver tables.

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

Databricks-Certified-Data-Analyst-Associate 無料問題集「Databricks Certified Data Analyst Associate」

弊社を連絡する

関連リンク

トップ試験