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

質問 1：
A stakeholder has provided a data analyst with a lookup dataset in the form of a 50-row CSV file. The data analyst needs to upload this dataset for use as a table in Databricks SQL.
Which approach should the data analyst use to quickly upload the file into a table for use in Databricks SOL?
A. Create a table by uploading the file to cloud storage and then importing the data to Databricks.
B. Create a table by uploading the file using the Create page within Databricks SQL
C. Create a table by manually copying and pasting the data values into cloud storage and then importing the data to Databricks.
D. Create a table via a connection between Databricks and the desktop facilitated by Partner Connect.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
The stakeholders.customers table has 15 columns and 3,000 rows of dat
a. The following command is run:

After running SELECT * FROM stakeholders.eur_customers, 15 rows are returned. After the command executes completely, the user logs out of Databricks.
After logging back in two days later, what is the status of the stakeholders.eur_customers view?
A. The view is not available in the metastore, but the underlying data can be accessed with SELECT * FROM delta. `stakeholders.eur_customers`.
B. The view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.
C. The view remains available but attempting to SELECT from it results in an empty result set because data in views are automatically deleted after logging out.
D. The view has been dropped.
E. The view has been converted into a table.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
What does Partner Connect do when connecting Power Bl and Tableau?
A. Downloads and installs an ODBC driver.
B. Creates a Personal Access Token. downloads and installs an ODBC driver, and downloads a configuration file for connection by Power Bl or Tableau to a SQL Warehouse (formerly known as a SQL Endpoint).
C. Creates a Personal Access Token for authentication into Databricks SQL and emails it to you.
D. Downloads a configuration file for connection by Power Bl or Tableau to a SQL Warehouse (formerly known as a SQL Endpoint).
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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 メンバーにのみ表示されます)

質問 5：
A data team has been given a series of projects by a consultant that need to be implemented in the Databricks Lakehouse Platform.
Which of the following projects should be completed in Databricks SQL?
A. Automating complex notebook-based workflows with multiple tasks
B. Combining two data sources into a single, comprehensive dataset
C. Testing the quality of data as it is imported from a source
D. Tracking usage of feature variables for machine learning projects
E. Segmenting customers into like groups using a clustering algorithm
正解：B
解説: (Topexam メンバーにのみ表示されます)