DA0-001 Exam Question 1
A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:
DA0-001 Exam Question 2
Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?
DA0-001 Exam Question 3
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
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
DA0-001 Exam Question 4
Which of the following is the correct data type for text?
DA0-001 Exam Question 5
A data analyst needs to calculate the mean for Q1 sales using the data set below:
Which of the following is the mean?
Which of the following is the mean?