最新的Data Analyst認證 Databricks-Certified-Data-Analyst-Associate考試題庫

問題1

A data scientist wants to tune a set of hyperparameters for a machine learning model. They have wrapped a Spark ML model in the objective function objective_function, and they have defined the search space search_space.
As a result, they have the following code block:
num_evals = 100
trials = SparkTrials()
best_hyperparam = fmin(
fn=objective_function,
space=search_space,
algo=tpe.suggest,
max_evals=num_evals,
trials=trials
)
Which of the following changes do they need to make to the above code block in order to accomplish the task?

A. Reduce num_evals to be less than 10

B. Change fmin() to fmax()

C. Change SparkTrials() to Trials()

D. Remove the trials=trials argument

E. Remove the algo=tpe.suggest argument

正確答案: C

說明：（僅 VCESoft 成員可見）

問題2

A data analyst has a series of queries in a SQL program. The data analyst wants this program to run every day. They only want the final query in the program to run on Sundays. They ask for help from the data engineering team to complete this task.
Which of the following approaches could be used by the data engineering team to complete this task?

A. They could automatically restrict access to the source table in the final query so that it is only accessible on Sundays.

B. They could wrap the queries using PySpark and use Python's control flow system to determine when to run the final query.

C. They could redesign the data model to separate the data used in the final query into a new table.

D. They could submit a feature request with Databricks to add this functionality.

E. They could only run the entire program on Sundays.

正確答案: B

說明：（僅 VCESoft 成員可見）

問題3

In which of the following situations will the mean value and median value of variable be meaningfully different?

A. When the variable contains a lot of extreme outliers

B. When the variable contains no missing values

C. When the variable is of the boolean type

D. When the variable contains no outliers

E. When the variable is of the categorical type

正確答案: A

說明：（僅 VCESoft 成員可見）

問題4

A data analyst has come across a column in a table that contains personally identifiable information (PII). The data analyst should not have access to this type of PII data.
How should the data analyst proceed?

A. Drop the column containing PII data and continue with the project without notifying anybody.

B. Stop working with the data and proceed with the project using other data.

C. Stop working with the data and delete the table and any existing metadata or data files.

D. Stop working with the data and notify their supervisor to ensure the data is handled following organizational and legal best practices.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題5

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. search tag = ' confidential '

B. tag=confidential

C. confidential:true

D. tag:confidential

正確答案: D

說明：（僅 VCESoft 成員可見）

問題6

Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?

A. Use Delta Live Tables to establish a cluster for Fivetran to interact with

B. Use Workflows to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with

C. Use Partner Connect ' s automated workflow to establish a cluster for Fivetran to interact with

D. Use Workflows to establish a cluster for Fivetran to interact with

E. Use Partner Connect ' s automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with

正確答案: C

說明：（僅 VCESoft 成員可見）

問題7

Which statement describes descriptive statistics?

A. A branch of statistics that uses summary statistics to categorically describe and summarize data.

B. A branch of statistics that uses quantitative variables that must take on a finite or countably infinite set of values.

C. A branch of statistics that uses summary statistics to quantitatively describe and summarize data.

D. A branch of statistics that uses a variety of data analysis techniques to infer properties of an underlying distribution of probability.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題8

What is an advantage of using a Delta Lake-based data lakehouse over classic enterprise data warehouse solutions?

A. Open-source formats

B. Generic optimizations

C. ACID transactions

D. Schema enforcement

正確答案: A

說明：（僅 VCESoft 成員可見）

最新的Databricks Certified Data Analyst Associate - Databricks-Certified-Data-Analyst-Associate免費考試真題

最新更新

站內鏈接

聯系我們