Qlik QSDA2019 Exam Questions Instant Access

Question 1

A data architect wants to combine data on present and 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?

AOption A

BOption B

COption C

DOption D

Answer : A

Question 2

Refer to the exhibit.

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

How should the data architect resolve the synthetic key?

ACreate a composite key using OrderlD and LineNo

BRemove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field

CRemove the LineNo field from both tables and use the AutoNumber function on the OrderlD field

DCreate a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments

Answer : A

Question 3

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?

AUpdate the Students table and add 16.7% of the missing records

BRemove records from the Exams table where StudentID is null

CUpdate the Exams table and add 33.4% of the missing records

DIn the LOAD script, add DISTINCT before the Students and Exams tables

Answer : C

Question 4

Refer to the exhibit.

A clothing retailer wants to review their product pricing strategy.

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?

AIntervalMatch and use variables

BNested IFs in a calculated dimension

CClass function in a calculated dimension

DClass function in the script and use variables

Answer : C

Question 5

Refer to the exhibit.

A business department is forecasting revenue within an Excel spreadsheet.

A data architect needs to include this forecast into the existing data model, and without losing any data.

Which two sets of steps will meet these requirements? (Select two.)

A1. Load the Excel spreadsheet using the data load editor
2. Use the Unpivot function
3 Use the Sum function to group the forecast by date
4 Connect to the existing data model

B1. Load the Excel spreadsheet using the data load editor
2 Use the Crosstable function to unpivot the table
3 Create a composite key out of the date and region
4 Connect the new table to the data model

C1 Load the Excel spreadsheet using the data load editor
2. Change the sort order by date
3. Create a composite key out of the forecast and region 4 Connect to the existing data model

D1 Load the Excel spreadsheet into the data manager
2. Use the Unpivot function
3. Create a composite key from the date and region
4. Connect the new table to the data model
1 Load the Excel spreadsheet using the data manager
2 Rename the ForecastDate field to Date 3. Disable the Region
4 Connect to the existing data model

Answer : D

Question 6

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

A1 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

B1. 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

C1. 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

D1 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

Answer : D

Question 7

A human resources (HR) team manager is due to go on leave. The manager needs to assign permissions to colleague to help the HR team publish apps. Which action(s) should the manager assign to the colleague before going on leave?

AOwner Publish

BPublish

COwner Publish, Read

DPublish, Read

Answer : D

Qlik Sense Data Architect QSDA2019 Exam Questions