A data analyst is working with gold-layer tables to complete an ad-hoc project. A stakeholder has provided the analyst with an additional dataset that can be used to augment the gold-layer tables already in use.
Which of the following terms is used to describe this data augmentation?
A. Data testing
B. Last-mile ETL
C. Data enhancement
D. Last-mile
E. Ad-hoc improvements
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.
Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?
A. Increase the minimum scaling value
B. Turn off the Auto stop feature
C. Increase the SQL endpoint cluster size
D. Use a Serverless SQL endpoint
E. Reduce the SQL endpoint cluster size
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
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 removing all access
B. Edit the Owner field in the table page by selecting the Admins group
C. Edit the Owner field in the table page by selecting the new owner's account
D. Edit the Owner field in the table page by selecting All Users
E. Edit the Owner field in the table page by removing their own account
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
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 via a connection between Databricks and the desktop facilitated by Partner Connect.
B. Create a table by uploading the file to cloud storage and then importing the data to Databricks.
C. Create a table by uploading the file using the Create page within Databricks SQL
D. Create a table by manually copying and pasting the data values into cloud storage and then importing the data to Databricks.
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
In which of the following situations will the mean value and median value of variable be meaningfully different?
A. When the variable contains no outliers
B. When the variable is of the categorical type
C. When the variable is of the boolean type
D. When the variable contains a lot of extreme outliers
E. When the variable contains no missing values
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
A data analyst has been asked to use the below table sales_table to get the percentage rank of products within region by the sales:

The result of the query should look like this:

Which of the following queries will accomplish this task?
A)

B)

C)


A. Option C
B. Option A
C. Option D
D. Option B
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
渋谷** -
Databricks-Certified-Data-Analyst-Associate問題集は全面的かつ権威的な資料を提供します。Databricks-Certified-Data-Analyst-Associate試験に役に立ちます。早く買いましょう!