최신Databricks Certified Data Analyst Associate - Databricks-Certified-Data-Analyst-Associate무료샘플문제
문제1
A data analyst has been asked to use the below table sales_table to rank products within region by the sales.
Input table:
region product sales
WEST A 1880.59
EAST A 2045.99
EAST B 4583.23
WEST B 3391.19
The result of the query should look like this:
region product rank
EAST B 1
EAST A 2
WEST B 1
WEST A 2
Which query will accomplish this task?
A data analyst has been asked to use the below table sales_table to rank products within region by the sales.
Input table:
region product sales
WEST A 1880.59
EAST A 2045.99
EAST B 4583.23
WEST B 3391.19
The result of the query should look like this:
region product rank
EAST B 1
EAST A 2
WEST B 1
WEST A 2
Which query will accomplish this task?
정답: C
설명: (ExamPassdump 회원만 볼 수 있음)
문제2
A data analyst has produced a visualization. A stakeholder has viewed the visualization and is complaining that the visualization is difficult to interpret. After looking at the visualization, the analyst determines that the scale of the y-axis must be changed.
Where are the controls for changing the scale of the y-axis in Databricks SQL?
A data analyst has produced a visualization. A stakeholder has viewed the visualization and is complaining that the visualization is difficult to interpret. After looking at the visualization, the analyst determines that the scale of the y-axis must be changed.
Where are the controls for changing the scale of the y-axis in Databricks SQL?
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제3
What is used as a compute resource for Databricks SQL?
What is used as a compute resource for Databricks SQL?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제4
An analyst has been asked to combine the data in two tables: suppliers and new_suppliers. It is possible that some of the supplier_id values match in both tables, meaning those suppliers have already been added to the suppliers table. If that is the case, the data should be unchanged.
Which command will combine the two tables without duplicating the rows with the same supplier_id?
An analyst has been asked to combine the data in two tables: suppliers and new_suppliers. It is possible that some of the supplier_id values match in both tables, meaning those suppliers have already been added to the suppliers table. If that is the case, the data should be unchanged.
Which command will combine the two tables without duplicating the rows with the same supplier_id?
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)
문제5
A data analyst needs to share a Databricks SQL dashboard with stakeholders that are not permitted to have accounts in the Databricks deployment. The stakeholders need to be notified every time the dashboard is refreshed.
Which approach can the data analyst use to accomplish this task with minimal effort/
A data analyst needs to share a Databricks SQL dashboard with stakeholders that are not permitted to have accounts in the Databricks deployment. The stakeholders need to be notified every time the dashboard is refreshed.
Which approach can the data analyst use to accomplish this task with minimal effort/
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)
문제6
A data analyst runs the following command:
INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;
What is the result of running this command?
A data analyst runs the following command:
INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;
What is the result of running this command?
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제7
A data analyst at an e-commerce company needs to process daily sales data. The data consists of approximately 50,000 records stored in a single CSV file, totaling about 20 MB. The analyst needs to perform aggregations and generate a summary report.
Which approach could the data analyst use in this situation?
A data analyst at an e-commerce company needs to process daily sales data. The data consists of approximately 50,000 records stored in a single CSV file, totaling about 20 MB. The analyst needs to perform aggregations and generate a summary report.
Which approach could the data analyst use in this situation?
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)
문제8
A data analysis team is working with the table_bronze SQL table as a source for one of its most complex projects. A stakeholder of the project notices that some of the downstream data is duplicative. The analysis team identifies table_bronze as the source of the duplication.
Which of the following queries can be used to deduplicate the data from table_bronze and write it to a new table table_silver?
A)
CREATE TABLE table_silver AS
SELECT DISTINCT *
FROM table_bronze;
B)
CREATE TABLE table_silver AS
INSERT *
FROM table_bronze;
C)
CREATE TABLE table_silver AS
MERGE DEDUPLICATE *
FROM table_bronze;
D)
INSERT INTO TABLE table_silver
SELECT * FROM table_bronze;
E)
INSERT OVERWRITE TABLE table_silver
SELECT * FROM table_bronze;
A data analysis team is working with the table_bronze SQL table as a source for one of its most complex projects. A stakeholder of the project notices that some of the downstream data is duplicative. The analysis team identifies table_bronze as the source of the duplication.
Which of the following queries can be used to deduplicate the data from table_bronze and write it to a new table table_silver?
A)
CREATE TABLE table_silver AS
SELECT DISTINCT *
FROM table_bronze;
B)
CREATE TABLE table_silver AS
INSERT *
FROM table_bronze;
C)
CREATE TABLE table_silver AS
MERGE DEDUPLICATE *
FROM table_bronze;
D)
INSERT INTO TABLE table_silver
SELECT * FROM table_bronze;
E)
INSERT OVERWRITE TABLE table_silver
SELECT * FROM table_bronze;
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제9
A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.
Which of the following relational objects should the data engineer create?
A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.
Which of the following relational objects should the data engineer create?
정답: C
설명: (ExamPassdump 회원만 볼 수 있음)