Changed DA0-001 Exam Questions

Page: 8 / 19

Question 32

Consider the following dataset which contains information about houses that are for sale:

Which of the following string manipulation commands will combine the address and region name columns to create a full address?

full_address------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern Metropolitan 5 Charles St, Northern Metropolitan 40 Federation La, Northern Metropolitan 55a Park St, Northern Metropolitan

Options:

SELECT CONCAT(address, ' , ' , regionname) AS full_address FROM melb LIMIT 5;

SELECT CONCAT(address, '-' , regionname) AS full_address FROM melb LIMIT 5;

SELECT CONCAT(regionname, ' , ' , address) AS full_address FROM melb LIMIT 5

SELECT CONCAT(regionname, '-' , address) AS full_address FROM melb LIMIT 5;

Question 33

Which of the following are reasons to conduct data cleansing? (Select two).

Options:

To perform web scraping

To track KPls

To improve accuracy

To review data sets

To increase the sample size

To calculate trends

Question 34

An analyst modified a data set that had a number of issues. Given the original and modified versions:

Which of the following data manipulation techniques did the analyst use?

Options:

Imputation

Recoding

Parsing

Deriving

Question 35

A data analyst is developing a dashboard to track and monitor metrics. Which of the following best practices should be taken into during the FIRST pment process?