최신 Databricks-Certified-Data-Analyst-Associate 무료덤프 - Databricks Certified Data Analyst Associate
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;
정답: E
설명: (DumpTOP 회원만 볼 수 있음)
Delta Lake stores table data as a series of data files, but it also stores a lot of other information.
Which of the following is stored alongside data files when using Delta Lake?
Which of the following is stored alongside data files when using Delta Lake?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
Which of the following is an advantage of using a Delta Lake-based data lakehouse over common data lake solutions?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
A data organization has a team of engineers developing data pipelines following the medallion architecture using Delta Live Tables. While the data analysis team working on a project is using gold-layer tables from these pipelines, they need to perform some additional processing of these tables prior to performing their analysis.
Which of the following terms is used to describe this type of work?
Which of the following terms is used to describe this type of work?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
Which of the following benefits of using Databricks SQL is provided by Data Explorer?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
A data analyst has been asked to provide a list of options on how to share a dashboard with a client. It is a security requirement that the client does not gain access to any other information, resources, or artifacts in the database.
Which of the following approaches cannot be used to share the dashboard and meet the security requirement?
Which of the following approaches cannot be used to share the dashboard and meet the security requirement?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)