Summer Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: s2p65

Easiest Solution 2 Pass Your Certification Exams

QSDA2021 Qlik Sense Data Architect Certification Exam - February 2021 Release Free Practice Exam Questions (2025 Updated)

Prepare effectively for your Qlik QSDA2021 Qlik Sense Data Architect Certification Exam - February 2021 Release certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Qlik QSDA2021 Premium Access     Download Demo    
Page: 1 / 1
Total 50 questions

Refer to the exhibit.

While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis.

The data architect runs the following script to resolve this issue:

A.

3

B.

1

C.

6

D.

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?

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

Refer to the exhibit.

A data architect is loading the tables and a synth key is generated.

How should the data architect resolve the synthetic key?

A.

Remove the LineNo field from Shipments and use the AutoNumber function on the

B.

Create a composite key using OrdertD and LineNo

C.

Remove the LineNo field from both tables and use the AutoNumber function on the OrderlC field

D.

Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments

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

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

A data architect needs to load data from two different databases Additional data will be added from a folder that contains QVDs. text files, and Excel files.

What is the minimum number of data connections required?

A.

Two

B.

Five

C.

Four

D.

Three

Refer to the exhibit.

A customer needs to load forecast data from an Excel file.

Which preceding load statement should the data architect use to load the data?

A)

B)

C)

D)

A.

Option

B.

Option

C.

Option

D.

Option

Refer to the exhibit.

A data architect needs to add a Budget table to the current Qlik Sense app. A Budget table with the fields Budget, CustomerlD, and ProductlD is loaded into the model. What will be created?

A.

A circular reference with one table disconnected

B.

A synthetic table with two synthetic keys

C.

A synthetic table with three synthetic keys

D.

A synthetic table and one synthetic key

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?

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

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

Refer to the exhibit.

A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments. To understand the table structure, the business has given the following summary:

• Every order creates a unique orderlD and an order date in the Orders table

• An order can contain one or more order lines one for each product ID in the order details table

• Products in the order are shipped (shipment date) as soon as tliey are ready and can be shipped separately

• The dates need to be analyzed separately by Year Month, and Quarter

The data architect realizes the data model has issues that must be fixed.

Which steps should the data architect perform?

A.

1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table

2. Delete the ShipmentID in the Shipments table

3. Delete the ProductID and OrderlD in the OrderDetails table

4. Concatenate Orders and OrderDetails

5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate

B.

1. Create a key with OrderlD and ProductID in the OrderDeta Is table and in the Shipments table

2. Delete the ShipmentID in the Orders table

3. Delete the ProductID and OrderlD in the Shipmi

4. Left join Orders and OrderDetails

5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

C.

1. Create a key with OrderlD and ProductID in the OrderDetails tab e and in the Orders table

2. Delete the ShipmentID in the Shipments table

3. Delete the ProductID and OrderlD in the OrderDetails

4. Left join Orders and OrderDetails

5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

D.

1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table

2. Delete the ShipmentID in the Orders table

3 Delete the ProductID and OrderlD in the Shipments table

4. Concatenate Orders and OrderDetails

A data architect needs to develop a script to export tables from a model based upon rules from an independent file. The structure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.

The TableToExport values are already verified to exist in the model.

In addition, the format will always be QVD, and the copies will be incrementally numbered.

For example, the Customer table would be exported as:

What is the minimum set of scripting strategies the data architect must use?

A.

Two loops without any conditional statement

B.

One loop and two IF statements

C.

Two loops and one IF statement

D.

One loop and one SELECT CASE statement

A data architect wants to combine data on presentand historic sales performance.The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.

Which script should the data architect use?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Refer to the exhibit

A data architect is working on an app that contains orders, invoices, and shipping data. There are three different date fields within the data:

* OrderDate

* InvoiceDate

* ShippingDate

The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.

What should the data architect do?

A.

Create a Month field for each of the three dates in the fact table and use that in the chart

B.

Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date

C.

Left Join the three date fields onto one bridge table using the key field containing KeyField and Date

Refer to the exhibit.

A data architect is working with an app and creates some visualizations to check the data. Some visualizations show issues in the data set.

*The Sales by Country table shows a total OrderValue of18,300 sales while the KPI shows a total OrderValue of 20,600.

*The Sales monthly trend bar chart does not work with the Month field.

Which two data issues should the data architect fix in the app? (Select two.)

A.

The Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.

B.

In the Orders table, some CustomerlD values are null because there are orders with no customer.

and needs to be incorporated in the table using the Calendar table, null because there are orders with no customer

C.

In the Orders table, some values in the CustomerlD field do not exist in the Customers table.

D.

The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table

Qlik QSDA2021 Premium Access     Download Demo    
Page: 1 / 1
Total 50 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved