Weekend Special - 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: av54zq84

Exact2Pass Menu

Question # 4

Mario works with a group of R programmers tasked with copying data from an accounting system into a data warehouse.

In what phase are the group's R skills most relevant?

A.

Extract.

B.

Load.

C.

Transform.

D.

Purge.

Full Access
Question # 5

What effort has the goal of maintaining a single source of truth for the most important data elements handled by the organization?

A.

MDM (Master Data Management)

B.

IPS (Intrusion Prevention System)

C.

MAM (Mobile Application Management)

D.

DLP (Data Loss Prevention)

Full Access
Question # 6

An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

A.

Histogram

B.

Pie

C.

Line

D.

Scatter pot

E.

Waterfall

Full Access
Question # 7

Analyzing a data point, you find that the point is 1 standard deviation above the mean.

What is the z-score for this data point?

A.

-0.5

B.

0.5

C.

1

D.

-1

Full Access
Question # 8

What European law requires that organizations handling personal information designate a Data Protection Officer (DPO)?

A.

HIPAA (Health Insurance Portability and Accountability Act)

B.

GLBA (Gramm–Leach–Bliley Act)

C.

GDPR (General Data Protection Regulation)

D.

FERPA (Family Educational Rights and Privacy Act)

Full Access
Question # 9

Which of the following can be used to translate data into another form so it can only be read by a user who has a key or a password?

A.

Data encryption.

B.

Data transmission.

C.

Data protection.

D.

Data masking.

Full Access
Question # 10

You would like to combine the text in two different strings to form a single string.

What action are you performing?

A.

Trimming.

B.

Case conversion.

C.

Parsing.

D.

Concatenation.

Full Access
Question # 11

When would you show time on a standard line chart?

A.

X-axis

B.

Legend

C.

Y-axis

D.

Color

Full Access
Question # 12

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 13

How many variables may be shown in a simple pie chart?

A.

4

B.

3

C.

2

D.

1

Full Access
Question # 14

Which one of the following values will appear first if they are sorted in descending order?

A.

Aaron.

B.

Molly.

C.

Xavier.

D.

Adam.

Full Access
Question # 15

Emma is working in a data warehouse and finds a finance fact table links to an organization dimension, which in turn links to a currency dimension that not linked to the fact table.

What type of design pattern is the data warehouse using?

A.

Star.

B.

Sun.

C.

Snowflake.

D.

Comet.

Full Access
Question # 16

What SQL command is used to delete an entire table from a database?

A.

DROP.

B.

MODIFY.

C.

DELETE.

D.

ALTER.

Full Access
Question # 17

What data obfuscation technique is designed to be reversible?

A.

Hashing

B.

Tokenization

C.

Masking

D.

Deletion

Full Access
Question # 18

Which of the following contains alphanumeric values?

A.

10.1Ε²

B.

13.6

C.

1347

D.

A3J7

Full Access
Question # 19

What is the most time-consuming of the practices that authorize international data transfers under GDPR?

A.

Binding corporate rules.

B.

Standard contractual clauses.

C.

Memoranda of understanding.

D.

Privacy shield.

Full Access
Question # 20

What is NOT a characteristic of a good data steward?

A.

A good technology expert.

B.

Collaborative.

C.

A subject matter expert.

D.

Influential.

Full Access