최신Databricks Certified Data Analyst Associate - Databricks-Certified-Data-Analyst-Associate무료샘플문제
문제1
A data analyst is using Databricks Unity Catalog. The datasets are tagged by sensitivity, and confidential data is marked with the tag key confidential. The data analyst needs to quickly find all tables tagged as confidential to review their access permissions in the Databricks workspace search bar.
Which search key text should the data analyst use to find these tables?
A data analyst is using Databricks Unity Catalog. The datasets are tagged by sensitivity, and confidential data is marked with the tag key confidential. The data analyst needs to quickly find all tables tagged as confidential to review their access permissions in the Databricks workspace search bar.
Which search key text should the data analyst use to find these tables?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제2
A data analyst is processing a complex aggregation on a table with zero null values and the query returns the following result:
Which query did the analyst execute in order to get this result?
A data analyst is processing a complex aggregation on a table with zero null values and the query returns the following result:
Which query did the analyst execute in order to get this result?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제3
Which of the following data workloads will utilize a Gold table as its source?
Which of the following data workloads will utilize a Gold table as its source?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제4
A data analyst wants to generate insights from large, complex datasets. The analyst needs to quickly understand the meaning of various data columns, ask questions in natural language, and receive AI-driven recommendations for optimizing data queries and workflows.
Which Databricks component is primarily responsible for enabling these capabilities?
A data analyst wants to generate insights from large, complex datasets. The analyst needs to quickly understand the meaning of various data columns, ask questions in natural language, and receive AI-driven recommendations for optimizing data queries and workflows.
Which Databricks component is primarily responsible for enabling these capabilities?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제5
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?
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?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
A table named user_ltv is being used to create a view that will be used by data analysts on various teams.
Users in the workspace are configured into groups, which are used for setting up data access using ACLs.
The user_ltv table has the following schema:
email STRING, age INT, ltv INT
The following view definition is executed:
CREATE VIEW user_ltv_no_minors AS
SELECT email, age, ltv
FROM user_ltv
WHERE
CASE
WHEN is_member( " auditing " ) THEN TRUE
ELSE age > = 18
END;
An analyst who is not a member of the auditing group executes the following query:
SELECT * FROM user_ltv_no_minors;
Which statement describes the results returned by this query?
A table named user_ltv is being used to create a view that will be used by data analysts on various teams.
Users in the workspace are configured into groups, which are used for setting up data access using ACLs.
The user_ltv table has the following schema:
email STRING, age INT, ltv INT
The following view definition is executed:
CREATE VIEW user_ltv_no_minors AS
SELECT email, age, ltv
FROM user_ltv
WHERE
CASE
WHEN is_member( " auditing " ) THEN TRUE
ELSE age > = 18
END;
An analyst who is not a member of the auditing group executes the following query:
SELECT * FROM user_ltv_no_minors;
Which statement describes the results returned by this query?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)