Skip to main content

QSDA2022 Real Exam Questions

Qlik Sense Data Architect Certification - 2022

77 questions available · Page 1 of 8

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

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?

  1. A

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

  2. B

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

  3. C

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

Show answer and explanation

Correct answer: B

Question 2 Single choice

A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects.

What should the data architect do?

  1. A

    Save the unconverted objects as extensions and import them into Qlik Sense

  2. B

    Remove the set analysis statements from the unconverted objects

  3. C

    Re-create the unconverted objects

  4. D

    Save the unconverted objects as master items

Show answer and explanation

Correct answer: C

Explanation

Explanation: After migrating an app from QlikView to Qlik Sense, there may be some unconverted objects.
In this case, the data architect should re-create the unconverted objects in order to ensure that the app works properly in Qlik Sense. The other options will not work, as saving the unconverted objects as extensions or master items will not ensure that the app works properly, and removing set analysis statements will not help either.

qlik-sense-certification-exam-study-guide-en.pdf
https://www.qlik.com/us/-/media/files/training/global-us/qlik-sense-certification-exam-study-guide-en.pdf?la=en&hash=9DA9DEBC7D27BF1CA8373E81F2614C85

Talk to Experts Tuesday - Migrating from QlikView to Qlik Sense FAQ
https://community.qlik.com/t5/Support-Knowledge-Base/Talk-to-Experts-Tuesday-Migrating-from-QlikView-to-Qlik-Sense/ta-p/1746935

Certifications & Qualifications | Qlik
https://www.qlik.com/us/services/training/certifications-and-qualifications

Question 3 Single choice

A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies

Source 1 Contains frequently updated data and must be refreshed hourly Source 2 Contains data that is transferred from a partner and must be refreshed weekly Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs

Which tasks should be created to meet these requirements'?

  1. A

    1. Schedule Task 1 to run hourly and refresh data from Source 1

    2. Schedule Task 2 to run weekly and refresh data from Source 2
    3. Schedule a task for the app that is dependent on completion of Tasks 1 or 2 that loads the two QVDs

  2. B

    1. Schedule Task 1 to run hourly and refresh data from Source 1
    2. Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
    3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

  3. C

    1. Schedule Task 1 to run hourly and refresh data from Source 1
    2. Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
    3. Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two
    QVDs

  4. D

    1. Schedule Task 1 to run hourly and refresh data from Source 1
    2. Schedule Task 2 to run weekly and refresh data from Source 2
    3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

Show answer and explanation

Correct answer: C

Explanation

Explanation: This option ensures that the data in the two data sources is always up-to-date by scheduling the data refresh tasks to run at the appropriate frequencies. Task 1 runs hourly to refresh data from Source 1, and Task 2 is dependent on Task 1 so that it runs only after Task 1 is completed. This ensures that the data from Source 2 is loaded only after the most current data from Source 1 is loaded.

Question 4 Single choice

A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table.

Which script code should the data architect use?

  1. A

    Option A

  2. B

    Option B

  3. C

    Option C

  4. D

    Option D

Show answer and explanation

Correct answer: C

Question 5 Single choice

Refer to the exhibits.

While debugging an app, a developer loads data from an application layer QVD file.

In the process of separating a concatenated key into two parts, some split results are missing data

What should the data architect do?

  1. A

    Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components

  2. B

    In the SUBFIELD function, replace the `_' with a `|' or `_' character.

  3. C

    Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components

  4. D

    In the SUBFIELD function, replace the '- with a `|' or '-' character

  5. E

    Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

  6. F

    Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character

  7. G

    Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

  8. H

    Wrap an IF() function around the SUBFIELD() functions to check and adapt to null values

Show answer and explanation

Correct answer: D

Question 6 Single choice

A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.

The OrderDate and ShipmentDate are located in different tables.

The user needs to identify the data type and must be able to:

Show trends for orders and shipments
Use a single filter for both date fields Analyze data over fiscal periods

Which steps should the data architect take to build the data model?

  1. A

    1. Create a link table with master calendar fields
    2. Create a single filter using fields from the master calendar

  2. B

    1. Load the Shipments and Orders table via the data manager
    2. Create a single filter using fields from the Orders table

  3. C

    1. Create a master calendar and join into the Shipments and Orders table
    2. Create a single filter using fields from the Shipments table

  4. D

    1. Create a master calendar table as a data island
    2. Create a single filter using fields from the master calendar

Show answer and explanation

Correct answer: A

Question 7 Single choice

A data architect executes the following script:

What will Field_1 contain after this script is executed?

  1. A

    Abed, abed, ABCD

  2. B

    abcd

  3. C

    Abcd, abcd

  4. D

    Abed, abed, ABCD, ABCDABCD

Show answer and explanation

Correct answer: A

Question 8 Single choice

A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails.

Which statement should the data architect use?

  1. A

    $<Include=lib://TextFiles/Variables.txt);

  2. B

    $(Must_Include=lib://TextFiles/Variables.txt);

  3. C

    (Must_Include=lib://TextFiies/Variables.txt);

  4. D

    (Includs=lib://TextFiles/Variables.txt);

Show answer and explanation

Correct answer: B

Explanation

Explanation: The MustInclude statement provides an error if the include fails and is used when including files in Qlik Sense. The other statements do not provide an error if the include fails.

qlik-sense-certification-exam-study-guide-en.pdf
https://www.qlik.com/us/-/media/files/training/global-us/qlik-sense-certification-exam-study-guide-en.pdf?la=en&hash=9DA9DEBC7D27BF1CA8373E81F2614C85

Talk to Experts Tuesday - Migrating from QlikView to Qlik Sense FAQ
https://community.qlik.com/t5/Support-Knowledge-Base/Talk-to-Experts-Tuesday-Migrating-from-QlikView-to-Qlik-Sense/ta-p/1746935
Certifications & Qualifications | Qlik
https://www.qlik.com/us/services/training/certifications-and-qualifications

The $(Must_Include) statement is used to load a file or a set of files and generate an error if the load fails.
The "Must_Include" function will stop the script execution if the file is not found or cannot be loaded. The correct syntax for using the "Must_Include" statement is $(Must_Include=lib://TextFiles/Variables.txt);

Question 9 Single choice

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?

  1. A

    Use where exists (ID, StorelD)

  2. B

    Use where exists (ID)

  3. C

    Use Concatenate before loading the Stores table

Show answer and explanation

Correct answer: B

Question 10 Single choice

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?

  1. A

    Two

  2. B

    Five

  3. C

    Four

  4. D

    Three

Show answer and explanation

Correct answer: D