Winter Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Login / Register

Question # 4

A data architect needs to upload different data sources. To properly handle null values, the data architect decides to set all of these values to "Missing Value".

Which syntax should the data architect use?

A.

NullAsValue*; Set NullValues = 'Missing Value';

B.

NullasNull *;

Set NullValues = 'Missing Value';

C.

NullasNull *;

Set NullValue = 'Missing Value';

D.

NullAsValue*;

Set NullValue = 'Missing Value';

Full Access
Question # 5

Refer to the exhibit.

What are the values of the variables vLoadStart and vLoadComplete after the script executes?

A.

vLoadStart; 'NOW{)'

vLoadComplete: current system date and time when the script ended

B.

vLoadStart: system date when the app was opened vLoadComplete 'now()'

C.

vLoadStart: system date when the app was opened vLoadComplete: current system date and time when the script ended

D.

vLoadStart: current system date and time when the script started vLoadComplete: 'now()'

Full Access
Question # 6

Multiple department fields in a dataset require a description

A data architect needs to add the department descriptions or a default value when the department does NOT have a description

Which strategy should the data architect use to meet these requirements?

A.

ApplyMap with two parameters after the Mapping load

B.

Left Join between tables and Description xlsx in every Department table

C.

Enter "Missing description" in the blank rows for Description xlsx then Mapping Load

D.

ApplyMap with three parameters after the Mapping load

Full Access
Question # 7

Refer to the exhibits.

A music teacher needs to know which artists are eligible to enter this year's competition.

The teacher needs to find only the artists who have a music grade rank above two and play more than one instrument.

Which expression is needed for the Number of Instruments measure in the table?

A.

Count({$=2"}, Artist={"=Grade>2"}>}Instrument)

B.

Count({S=2"}, Grades={">2"}>}Instrument)

C.

Count({$=2"}, Artist={"=Grade>2"}>}Instrument)

D.

Count ({S=2M}, Grades={">2"}>}Instrument)

Full Access
Question # 8

A data architect is creating an app using three tables. After executing the script, a warning displays

Which two steps should the data architect do to resolve this warning? (Select two.)

A.

Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.

B.

Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).

C.

Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).

D.

insert "Join (ProductDetails)" in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails

Full Access
Question # 9

A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E A439926003 The data connection points to this folder.

The data architect plans a script which will:

1. Verify that the file exists

2. If the file exists, upload it Otherwise, skip to the next piece of code

The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure.

Which option should the data architect use to meet these requirements?

A.

FileSize, IF, THEN, END IF

B.

FilePath, IF, THEN. Drop

C.

FileExists, FOR EACH, IF

D.

FilePath, FOR EACH, Peek, Drop

Full Access
Question # 10

Refer to the exhibits.

Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.

The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.

What should the data architect do to resolve this issue?

A.

Open the data manager, split the Customers table, and associate both tables on CustomerlD field

B.

Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field

C.

Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD

D.

Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

Full Access
Question # 11

Refer to the exhibit.

Which changes on the database will the script capture?

A.

Insert and Remove rows

B.

Insert. Update, and Remove rows

C.

Insert and Update rows

D.

Update and Remove rows

Full Access