Databricks Databricks-Certified-Data-Analyst-Associate 問題集

質問 1：
A data analyst created and is the owner of the managed table my_ table. They now want to change ownership of the table to a single other user using Data Explorer.
Which of the following approaches can the analyst use to complete the task?
A. Edit the Owner field in the table page by selecting All Users
B. Edit the Owner field in the table page by removing their own account
C. Edit the Owner field in the table page by selecting the Admins group
D. Edit the Owner field in the table page by selecting the new owner's account
E. Edit the Owner field in the table page by removing all access
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A data analyst needs to use the Databricks Lakehouse Platform to quickly create SQL queries and data visualizations. It is a requirement that the compute resources in the platform can be made serverless, and it is expected that data visualizations can be placed within a dashboard.
Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?
A. Databricks Notebooks
B. Databricks Machine Learning
C. Databricks SQL
D. Tableau
E. Delta Lake
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A data analyst runs the following command:
SELECT age, country
FROM my_table
WHERE age >= 75 AND country = 'canada';
Which of the following tables represents the output of the above command?
A.

B.

C.

D.

E.

正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist.
Which of the following commands can the analyst use to complete the task without producing an error?
A. DROP DATABASE database_name;
B. DROP TABLE database_name.table_name;
C. DELETE TABLE database_name.table_name;
D. DELETE TABLE table_name FROM database_name;
E. DROP TABLE table_name FROM database_name;
正解：B

質問 5：
Which of the following statements about adding visual appeal to visualizations in the Visualization Editor is incorrect?
A. Visualization scale can be changed.
B. Borders can be added.
C. Data Labels can be formatted.
D. Tooltips can be formatted.
E. Colors can be changed.
正解：B
解説: (Topexam メンバーにのみ表示されます)