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

問題1

Which of the following layers of the medallion architecture is most commonly used by data analysts?

A. Silver

B. Bronze

C. None of these layers are used by data analysts

D. All of these layers are used equally by data analysts

E. Gold

正確答案: E

說明：（僅 Fast2test 成員可見）

問題2

A data analyst needs to create an empty managed table table_name in database database_name with a specific schema. The table needs to be recreated and empty, regardless of whether or not the table already exists.
Which command can the analyst use to complete the task?

A. CREATE OR REPLACE TABLE database_name.table_name USING (width INT, length INT, height INT);

B. CREATE TABLE database_name.table_name USING (width INT, length INT, height INT);

C. CREATE OR REPLACE TABLE database_name.table_name (width INT, length INT, height INT);

D. CREATE OR REPLACE TABLE table_name FROM database_name USING (width INT, length INT, height INT);

正確答案: C

說明：（僅 Fast2test 成員可見）

問題3

Which of the following is an advantage of using a Delta Lake-based data lakehouse over common data lake solutions?

A. Open-source formats

B. Data deletion

C. Scalable storage

D. ACID transactions

E. Flexible schemas

正確答案: D

說明：（僅 Fast2test 成員可見）

問題4

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to a data analytics dashboard for a retail use case. The job has a Databricks SQL query that returns the number of store-level records where sales is equal to zero. The data engineer wants their entire team to be notified via a messaging webhook whenever this value is greater than 0.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of stores with $0 in sales is greater than zero?

A. They can set up an Alert without notifications.

B. They can set up an Alert with one-time notifications.

C. They can set up an Alert with a new webhook alert destination.

D. They can set up an Alert with a new email alert destination.

E. They can set up an Alert with a custom template.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題5

A data engineering team has created a Structured Streaming pipeline that processes data in micro-batches and populates gold-level tables. The microbatches are triggered every 10 minutes.
A data analyst has created a dashboard based on this gold level data. The project stakeholders want to see the results in the dashboard updated within 10 minutes or less of new data becoming available within the gold- level tables.
What is the ability to ensure the streamed data is included in the dashboard at the standard requested by the project stakeholders?

A. A refresh schedule with stakeholders included as subscribers

B. A refresh schedule with an interval of 10 minutes or less

C. A refresh schedule with an always-on SQL Warehouse (formerly known as SQL Endpoint

D. A refresh schedule with a Structured Streaming cluster

正確答案: B

說明：（僅 Fast2test 成員可見）

問題6

A data engineer is maintaining a data pipeline. Upon data ingestion, the data engineer notices that the source data is starting to have a lower level of quality. The data engineer would like to automate the process of monitoring the quality level.
Which of the following tools can the data engineer use to solve this problem?

A. Unity Catalog

B. Delta Live Tables

C. Delta Lake

D. Auto Loader

E. Data Explorer

正確答案: B

說明：（僅 Fast2test 成員可見）

問題7

A business analyst has been asked to create a data entity/object called sales_by_employee. It should always stay up-to-date when new data are added to the sales table. The new entity should have the columns sales_person, which will be the name of the employee from the employees table, and sales, which will be all sales for that particular sales person. Both the sales table and the employees table have an employee_id column that is used to identify the sales person.
Which of the following code blocks will accomplish this task?

A.

B.

C.

正確答案: B

說明：（僅 Fast2test 成員可見）

問題8

Which of the following statements about a refresh schedule is incorrect?

A. A refresh schedule is not the same as an alert.

B. Refresh schedules can be configured in the Query Editor.

C. You must have workspace administrator privileges to configure a refresh schedule

D. A query being refreshed on a schedule does not use a SQL Warehouse (formerly known as SQL Endpoint).

E. A query can be refreshed anywhere from 1 minute lo 2 weeks

正確答案: C

說明：（僅 Fast2test 成員可見）

問題9

A data analyst has created a Query in Databricks SQL, and now they want to create two data visualizations from that Query and add both of those data visualizations to the same Databricks SQL Dashboard.
Which of the following steps will they need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

A. They will need to copy the Query and create one data visualization per query.

B. They will need to add two separate visualizations to the dashboard based on the same Query.

C. They will need to alter the Query to return two separate sets of results.

D. They will need to decide on a single data visualization to add to the dashboard.

E. They will need to create two separate dashboards.

正確答案: B

說明：（僅 Fast2test 成員可見）

問題10

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. Option AMERGE INTO suppliersUSING new_suppliersON suppliers.supplier_id = new_suppliers.
supplier_idWHEN NOT MATCHED THEN INSERT *;

B. Option DINSERT INTO suppliersUSING new_suppliersON suppliers.supplier_id = new_suppliers.
supplier_idWHEN NOT MATCHED THEN INSERT *;

C. Option CUPDATE suppliersUSING new_suppliersON suppliers.supplier_id = new_suppliers.
supplier_idWHEN NOT MATCHED THEN INSERT *;

D. Option BCOPY INTO suppliersUSING new_suppliersON suppliers.supplier_id = new_suppliers.
supplier_idWHEN NOT MATCHED THEN INSERT *;

正確答案: A

說明：（僅 Fast2test 成員可見）

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

聯系我們

站內鏈接

最新更新