Databricks-Certified-Data-Analyst-Associate Exam Question 26
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;
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;
Databricks-Certified-Data-Analyst-Associate Exam Question 27
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?
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?
Databricks-Certified-Data-Analyst-Associate Exam Question 28
A data analyst has two data sources that are providing similar but complementary information. The analyst wants to combine these sources of data into a single, comprehensive dataset for ongoing use for their team in a variety of different projects.
Which term is used to describe this type of work?
Which term is used to describe this type of work?
Databricks-Certified-Data-Analyst-Associate Exam Question 29
A data analyst filters rows where the tags array includes the value ' sql ' using this query:
SELECT *
FROM main.analytics.articles
WHERE tags = ' sql ' ;
This query returns no results.
How should the analyst query to filter for rows where the tags array contains ' sql ' ?
SELECT *
FROM main.analytics.articles
WHERE tags = ' sql ' ;
This query returns no results.
How should the analyst query to filter for rows where the tags array contains ' sql ' ?
Databricks-Certified-Data-Analyst-Associate Exam Question 30
A data analyst has written and saved a series of queries that reveal trends that need to be monitored by several stakeholders.
Which tool should the data analyst use to share the results of all of the queries to be viewed at once?
Which tool should the data analyst use to share the results of all of the queries to be viewed at once?
