Online Access Free DA0-002 Practice Test

A data analyst creates a report, and some of the fields are empty. Which of the following conditions should the analyst add to a query to provide a list of all the records with empty fields?

• A.WHERE [ColumnName] IS NOT NULL
• B.WHERE [ColumnName] = NULL
• C.WHERE [ColumnName] = 'NULL'
• D.WHERE [ColumnName] IS NULL

A data analyst is creating a new dataset that involves bringing together the following datasets:
Name
ID
Date of birth
Frank
23525
3/19
Martha
11290
6/13
Ellen
12141
11/4
ID
Address
City
State
23525
1234 Harding
Chicago
IL
11040
935 Terrace Hills
Chino
CA
11290
2 Speedway
Miami
FL
Which of the following would be the output if the data analyst does a FULL JOIN?

• A.Name
  ID
  Date of birth
  Address
  City
  State
  Frank
  23525
  3/19
  1234 Harding
  Chicago
  IL
  Martha
  11290
  6/13
  2 Speedway
  Miami
  FL
  Ellen
  12141
  11/4
  11040
  935 Terrace Hills
  Chino
  CA
• B.Name
  ID
  Date of birth
  Address
  City
  State
  Frank
  23525
  3/19
  1234 Harding
  Chicago
  IL
  Martha
  11290
  6/13
  935 Terrace Hills
  Chino
  CA
  Ellen
  12141
  11/4
  2 Speedway
  Miami
  FL
• C.Name
  ID
  Date of birth
  Address
  City
  State
  Frank
  23525
  3/19
  1234 Harding
  Chicago
  IL
  Martha
  11290
  6/13
  935 Terrace Hills
  Chino
  CA
  Ellen
  12141
  11/4
  2 Speedway
  Miami
  FL
• D.Name
  ID
  Date of birth
  Address
  City
  State
  Frank
  23525
  3/19
  1234 Harding
  Chicago
  IL
  Martha
  11290
  6/13
  2 Speedway
  Miami
  FL
  Ellen
  12141
  11/4
  935 Terrace Hills
  Chino
  CA

Which of the following is found in metadata?

• A.Data lineage
• B.Variable types
• C.Syntax
• D.Transformations

A data analyst is evaluating all conditions in a query. Which of the following is the best logical function to accomplish this task?

• A.AND
• B.OR
• C.NOT
• D.IF

Which of the following is the best reason for a company to use a CSV file to share data instead of an Excel file?

• A.CSV files are easier to change in text editors.
• B.CSV files are not vendor-specific.
• C.CSV files can store different types of encoding.
• D.CSV files are smaller in size.