QSDA2022 Online Practice Questions and Answers

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 of 18,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

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?

A. 26 values for Sales Rep are null in CustomerMaster

B. 40.7% of the Sales Rep have CustomerMaster information

C. 59.3% of the Sales Rep have CustomerMaster information

D. Density is 100% while Total Distinct and Present Distinct are NOT the same

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'?

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

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

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

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

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?

A. Load only aggregated data for 2 years and use On-Demand App Generation (ODAG) for transaction data

B. Load only aggregated data for 2 years and apply filters on a sheet for transaction data

C. Load only 2 years of data in an aggregated app and create a separate transaction app for occasional use

D. Load only 2 years of data and use best practices in scripting and visualization to calculate and display aggregated data

A data architect needs to create an app to analyze 30-day re-admissions at a hospital.

The medical record system does NOT calculate re-admission data The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission" Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge date

Which action should the data architect perform first to meet these requirements?

A. Sequence patient records by hospital account ID and patient ID using the Peek function

B. Sequence patient records by patient ID using the Peek function

C. Calculate the days since previous discharge using admission date and discharge date

D. Order patient records by patient ID and admission date

Refer to the exhibit.

What are the values of the variables vLoadStart and vLoadComplete after the script executes?

A. vLoadStart; 'NOW{)' vLoadComplete: current system date and time when the script ended

B. vLoadStart: system date when the app was opened vLoadComplete 'now()'

C. vLoadStart: system date when the app was opened vLoadComplete: current system date and time when the script ended

D. vLoadStart: current system date and time when the script started vLoadComplete: 'now()'

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?

A. Update the Students table and add 16.7% of the missing records

B. Remove records from the Exams table where StudentID is null

C. Update the Exams table and add 33.4% of the missing records

D. In the LOAD script, add DISTINCT before the Students and Exams tables

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?

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

B. Remove the set analysis statements from the unconverted objects

C. Re-create the unconverted objects

D. Save the unconverted objects as master items

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 all the master items needed and protect it with SECTION ACCESS.

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