Free Certified Data Analyst Associate Exam braindumps download (Certified Data Analyst Associate exam dumps Free)

QUESTION: 17

The stakeholders.customers table has 15 columns and 3,000 rows of data. The following command is run:

After running SELECT * FROM stakeholders.eur_customers, 15 rows are returned. After the command executes completely, the user logs out of Databricks.

What is the status of the stakeholders.eur_customers view after logging back in two days later?

The view is not available in the metastore, but the underlying data can be accessed with SELECT * FROM delta.'stakeholders.eur_customers'.
The view remains available but attempting to SELECT from it results in an empty result set because data in views are automatically deleted after logging out.
The view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.
The view has been dropped.

Answer(s): D

Show Answer Next Question

QUESTION: 18

A data analyst created and is the owner of the managed table my_table. The data analyst now wants to change ownership of the table to a single other user using Data Explorer.

Which approach can the analyst use to complete the task?

Edit theOwner field in the table page by selecting the new owner's account.
Edit theOwner field in the table page by selecting the Admins group.
Edit theOwner field in the table page by selecting All Users.
Edit theOwner field in the table page by removing their own account.

Answer(s): A

Show Answer Next Question

QUESTION: 19

A data analyst has a managed table table_name in database database_name. The data analyst wants to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist.

Which command can the analyst use to complete the task without producing an error?

DROP TABLE table_name FROM database_name;
DROP TABLE database_name.table_name;
DELETE TABLE database_name.table_name;
DELETE TABLE table_name FROM database_name;

Answer(s): B

Show Answer Next Question

QUESTION: 20

A data analyst runs the following command:

Which table represents the output of this command?

Answer(s): D

Show Answer Next Question

QUESTION: 21

A data analyst runs the following command:

INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;

What is the result of running this command?

The suppliers table now contains both the data it had before the command was run and the data from the new_suppliers table, including any duplicate data.
The suppliers table now contains both the data it had before the command was run and the data from the new_suppliers table, and any duplicate data is deleted.
The suppliers table now contains only the data from the new_suppliers table.
The suppliers table now contains the data from the new_suppliers table, and the new_suppliers table now contains the data from the suppliers table.

Answer(s): A

Explanation:

The INSERT INTO ... TABLE statement adds all rows from the new_suppliers table into the suppliers table. This operation does not check for duplicate records unless constraints (such as PRIMARY KEY or UNIQUE) are explicitly defined in the table schema. If no such constraints exist, all data from new_suppliers will be appended to suppliers, even if it results in duplicates.

Show Answer Next Question

QUESTION: 22

A data analyst is working with a nested array column products in table transactions. The analyst wants to expand the table so each unique item in products for each row has its own row where the transaction_id column is duplicated as necessary.

The data analyst is using the following incomplete command:

Which line of code should the data analyst use to fill in the blank in the above code block so that it successfully completes the task?

array distinct(products)
explode(products)
flatten(products)
array(products)

Answer(s): B

Show Answer Next Question

QUESTION: 23

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?

CREATE TABLE table_silver AS

SELECT DISTINCT *
FROM table_bronze;
INSERT OVERWRITE TABLE table_silver
SELECT * FROM table_bronze;
CREATE TABLE table_silver AS
MERGE DEDUPLICATE *
FROM table_bronze;
INSERT INTO TABLE table_silver
SELECT * FROM table_bronze;

Answer(s): A

Show Answer Next Question

QUESTION: 24

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?