New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best70

Dumpsbuddy Logo
  1. Home
  2. Qlik
  3. Qlik Sense Data Architect
  4. QSDA2021
  5. Qlik Sense Data Architect Certification Exam - February 2021 Release Questions and Answers

QSDA2021 Qlik Sense Data Architect Certification Exam - February 2021 Release Questions and Answers

Questions 4

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?

Options:

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 the Original 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

Buy Now
Questions 5

Refer to the exhibits.

An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.

The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.

How should the data architect modify the data model to correct this issue?

Options:

A.

Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

B.

Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship

C.

Join the Departments and Salespeople tables to resolve the many-to-many relationship

D.

Join the Transactions and Salespeople tables to resolve the many-to-many relationship

Buy Now
Questions 6

Refer to the exhibit.

A data architect executes the script.

What will be the value of the first row for Field_1?

Options:

A.

A

B.

D

C.

Null

D.

4

Buy Now
Questions 7

Refer to the exhibits.

A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is

An existing master calendar exists in the datamodel that contains a full set of dates.

Which technique should the data architectuse to meet this requirement?

Options:

A.

Utilize INTERVALMATCH to load the currency conversion rate between dates the conversation changed

INNER JOIN the resultant table back into the master calendar

B.

OUTER JOIN the calendar with the currency conversion table

ORDER BY the date and use the PEEK function to fill in blank values

C.

Leverage a FOR loop between the start date and end date of the master calendar

Use the MATCH function to add the currency conversion rates to the master calendar

D.

Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table

Buy Now
Exam Code: QSDA2021
Exam Name: Qlik Sense Data Architect Certification Exam - February 2021 Release
Last Update: Dec 22, 2024
Questions: 50

PDF + Testing Engine

$134.99
buy now QSDA2021 pdf + testing engine

Testing Engine

$99.99
buy now QSDA2021 testing engine

PDF (Q&A)

$84.99
buy now QSDA2021 pdf