Month End Special - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

QSDA2022 Questions and Answers

Question # 6

The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.

Which method should the data architect use to manage the modifications in all apps?

A.

Create a variable repository and load them using INCLUDE statements in the apps where needed

B.

Create a selection app with all the master items and use an on-demand app generation method.

C.

Create a core app with all the master items needed and use a BINARY load in the other apps.

D.

Create only a single app with allthe master items needed and protect it with SECTION ACCESS.

Full Access
Question # 7

Refer to the exhibit

A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe

The script runs successfully, but the Stores table does not have any values.

What should the data architect do?

A.

Use where exists (ID, StorelD)

B.

Use where exists (ID)

C.

Use Concatenate before loading the Stores table

Full Access
Question # 8

A data architect executes the following script:

What will Field_1 contain after this script is executed?

A.

Abed, abed, ABCD

B.

abcd

C.

Abcd, abcd

D.

Abed, abed, ABCD, ABCDABCD

Full Access
Question # 9

Refer to the exhibits.

The first table shows the source table (Original table).

This data represents the stocks stored every month for each product:

• The relevant fields are productid, qty, and date.

• The date field represents the calendar months using

• The qty field shows the product stock fluctuation from the current month versus the previous month. If there is no fluctuation between months, there are no new entries in the table.

The second table shows a Pivot table visualization the data analyst needs to create in the app displaying per each product the monthly trend of available stock.

For performance reasons, the data analyst requests the data architect to calculate the running stock quantity of each product for every month in the script.

Which approach should the data architect use?

A.

1 Generate a Cartesian JOIN between productid and date in a Combined table

2 RIGHT JOIN the Combined table with the Original table to populate the missing qty values

3. Use PREVIOUS() and RANGESUMQ functions to create the running quantity totals for each product for every month

B.

1. Generate a Cartesian JOIN between productid and date in a Combined table

2. LEFT JOIN the Combined table with theOriginal table to populate the missing qty values

3. Use PREVIOUSO and SUM() functions to create the running quantity totals for each product for every month

C.

1. Generate a Calendar table with all dates between the minimum and maximum date values in an Original table

2. RIGHT JOIN the Calendar table back to the Original table to populate the missing qty values

3. Use PEEK() and RANGECOUNTO functions to create the running quantity totals for each product for every month

D.

1 Generate a Calendar table with all dates between the minimum and maximum date values in an Original table

2. LEFT JOIN the Calendar table back to the Original table to populate the missing qty values

Full Access
Question # 10

A company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 11

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