A data analyst has been asked to create one table that has each employee's first name, last name, sales, and address. The sales and addresses are listed in the tables below: Which of the following steps should the analyst take to create the table?

Create a column that concatenates the first name and last name in each table. Use concatenate and lookup to bring the address field into Table 1.

Transpose the first name and last name in both tables. Use lookup to pull the address field from Table 2 into Table 1.

Use lookup with the first name or first name to pull the address field from Table 2 into Table 1.

Use the append formula in both tables for the first name and last name. Use lookup to pull the address field from Table 2 into Table 1.

Create a column that concatenates the first name and last name in each table. Use concatenate and lookup to bring the address field into Table 1.

The total values in this month's revenue report are twice as much as last month's. Which of the following most likely occurred during the ETL process?

The report included the previous month's data.

The data cleansing processes failed to execute.

The database connectivity failed.

The report included the previous month's data.

The data normalization processes failed.

Which of the following is the best reason for removing data outliers?

Data varies significantly from others.

Data is redundant in the table.

Data is duplicated in the whole range.

Data is missing from the table.

A data analyst who works for a government agency is required to obtain the average income of citizens. The list of citizens is given in the following table: A value for one citizen's income is missing. Which of the following approaches should the data analyst take to solve this issue?

Impute the mean of the other citizens' incomes into the field with the missing value.

Replace the missing value with the average of the rest of the unemployed citizens.

Insert the value 0 into the field with the missing value.

Impute the mean of the other citizens' incomes into the field with the missing value.

Exclude employed citizens from the analysis.

Which of the following activities occurs during the ETL process?

Reviewing and addressing missing values

Inserting a pivot table and pivot chart

CompTIA DA0-001 Practice Test 9 - Free Online Exam Prep & Questions

A database administrator is required to mask certain table columns containing Pll in order to comply with the company privacy policy. Which of the following are the most likely types of information the administrator should mask? (Select two).

Become a Premium Member for full access

Unlock Premium Member

CompTIA DA0-001 Practice Test 9

Question

CompTIA DA0-001 Practice Tests

Practice Tests