DA0-001 Practice Questions

A.  

Alphanumeric

B.  

Symbolic

C.  

Numeric

D.  

Float

E.  

Boolean

F.  

String

A.  

Views reduce the need for repetitive, complex data joins.

B.  

Views allow for the storage of temporary data. whereas tables do not.

C.  

Views allow for the joining of multiple data sources, whereas tables do not.

D.  

Views can be used to restrict sensitive information.

A.  

A real-time monitor that allows the manager to view performance the day the campaign was launched

B.  

A sell-service dashboard that allows the manager to look at the company's annual budget performance

C.  

A spreadsheet of the raw data from all marketing campaigns and channels

D.  

A summary with statistics, conclusions, and recommendations from the data analyst

A.  

transactional schema.

B.  

star schema.

C.  

non-relational schema.

D.  

snowflake schema.

A.  

JSON is quicker to read and write.

B.  

JSON has to use an end tag.

C.  

JSON strings are longer

D.  

JSON is much more difficult to parse.

A.  

Non-parametric data

B.  

Missing data

C.  

Duplicate data

D.  

Invalid data

E.  

Redundant data

F.  

Normalized data

A.  

Q2 2020 and Q4 2019

B.  

YTD 2020 and YTD 2019

C.  

Q2 2020 and Q2 2019

D.  

Q2 2020 and Q2 2021

A.  

Creation of a data dictionary

B.  

Compliance with regulations

C.  

Standardization of data field names

D.  

Consolidation of multiple data fields

A.  

CSV

B.  

XLSM

C.  

XML

D.  

JSON

A.  

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

B.  

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

C.  

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.

D.  

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.