QSDA2022 Sample Questions Answers

Refer to the exhibit.

Refer to the exhibits.

While using an app, the users report that some Sales Reps do NOT have personal details, like Division or Address Number A data architect has been called in to investigate.

The data architect uses the data model viewer to determine the relationship between the SalesRepMaster and CustomerMaster tables.

What is the cause of the issue?

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?

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 data model that contains a full set of dates.

Which technique should the data architect use to meet this requirement?

Refer to the exhibit.

The data architect needs to build a model that contains Sales and Budget data for each customer. Some customers have Sales without a Budget, and other customers have a Budget with no Sales

During loading, the data architect resolves a synthetic key by creating the composite key

For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.

What does the data architect see when selecting a month?

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?

ITALY IT001 HR

GERMANY DE002 HR

SPAIN SP03 FINANCE

FRANCE FRO04 SALES

Refer to the exhibit

A company stores the employee data within a key composed of Country UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.

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?

Refer to the exhibit.

Which changes on the database will the script capture?

A company generates 1 GB of ticketing data daily. The data is stored in multiple tables Business users need to see trends of tickets processed for the past. 2 years Users very rarely access the transaction-level data for a specific date. Only the past 2 years of data must be loaded which is 720 GB of data

Which method should a data architect use to meet these requirements?

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 data architect executes the following script:

What will be the result of Table A?

A)

B)

C)

D)

A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.

These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key.

The Human Resources manager creates a table that maps these keys to another, called Associations.

The resultant data model must meet the following requirements:

• Associations must be valid

• The model must be optimized for performance

• The option must support multiple tables added

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

Refer to the exhibit.

A data architect executes the script.

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

Refer to the exhibit.

A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam.

The data architect selects the field "StudentID" from the Students table and sees the following:

A data architect needs to fix this anomaly.

What should the data architect do to ensure data integrity?

Refer io the exhibit.

A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A. (For example, only the row containing A, 1, 456 should be loaded from Table_B.)

Which script should the data architect use?

A)

B)

C)

D)

Refer to the exhibit.

An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error

What should be done to make sure the script runs correctly?

Refer to the exhibit.

A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey.

Which script is valid to load the tables and maintain the correct association?

A)

B)

C)

D)

Refer to the exhibit.

A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.

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

Refer to the exhibit.

A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name.

Which line number should the data architect use?

Refer to the exhibit.

A data architect loads sales data and creates a table which shows only customers who made purchases in 2018 and 2019. The data architect applies the following set analysis expression on the sales measure. Count<{})>} Customer ID)

Which option shows the resulting table after the expression is applied?

A)

B)

C)

D)