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. Testing the quality of data as it is imported from a source
B. Combining two data sources into a single, comprehensive dataset
C. Automating complex notebook-based workflows with multiple tasks
D. Segmenting customers into like groups using a clustering algorithm
E. Tracking usage of feature variables for machine learning projects
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
How can a data analyst determine if query results were pulled from the cache?
A. Go to the Alerts tab and check the Cache Status alert.
B. Go to the SQL Warehouse (formerly SQL Endpoints) tab and click on Cache. The Cache file will show the contents of the cache.
C. Go to the Queries tab and click on Cache Status. The status will be green if the results from the last run came from the cache.
D. Go to the Query History tab and click on the text of the query. The slideout shows if the results came from the cache.
E. Go to the Data tab and click Last Query. The details of the query will show if the results came from the cache.
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
A data analyst has been asked to count the number of customers in each region and has written the following query:
If there is a mistake in the query, which of the following describes the mistake?
A. The query is using ORDER BY. which is not allowed in an aggregation.
B. The query is selecting region but region should only occur in the ORDER BY clause.
C. The query is using count('). which will count all the customers in the customers table, no matter the region.
D. There are no mistakes in the query.
E. The query is missing a GROUP BY region clause.
正解:E
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
Consider the following two statements:
Statement 1:
Statement 2:
Which of the following describes how the result sets will differ for each statement when they are run in Databricks SQL?
A. When the first statement is run, all rows from the customers table will be returned and only the customer_id from the orders table will be returned. When the second statement is run, only those rows in the customers table that do not have at least one match with the orders table on customer_id will be returned.
B. Both statements will fail because Databricks SQL does not support those join types.
C. The first statement will return all data from the customers table and matching data from the orders table. The second statement will return all data from the orders table and matching data from the customers table. Any missing data will be filled in with NULL.
D. There is no difference between the result sets for both statements.
E. When the first statement is run, only rows from the customers table that have at least one match with the orders table on customer_id will be returned. When the second statement is run, only those rows in the customers table that do not have at least one match with the orders table on customer_id will be returned.
正解:E
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
An analyst writes a query that contains a query parameter. They then add an area chart visualization to the query. While adding the area chart visualization to a dashboard, the analyst chooses "Dashboard Parameter" for the query parameter associated with the area chart.
Which of the following statements is true?
A. The area chart will use whatever value is chosen on the dashboard at the time the area chart is added to the dashboard.
B. The area chart will use whatever is selected in the Dashboard Parameter while all or the other visualizations will remain changed regardless of their parameter use.
C. The area chart will convert to a Dashboard Parameter.
D. The area chart will use whatever value is input by the analyst when the visualization is added to the dashboard. The parameter cannot be changed by the user afterwards.
E. The area chart will use whatever is selected in the Dashboard Parameter along with all of the other visualizations in the dashboard that use the same parameter.
正解:E
解説: (Pass4Test メンバーにのみ表示されます)
Nagayama -
Databricks-Certified-Data-Analyst-Associate問題集は図表が多く、説明も丁寧で読み込むことにより合格に必要な知識を得ることができます。