Qlik QSDA2018 Actual Free Exam Questions & Community Discussion

Exam Code/Number: QSDA2018
Exam Name/Title: Qlik Sense Data Architect Certification Exam - June 2018 Release
Certification Provider: Qlik
Corresponding Certification: Qlik Sense Data Architect

Exam Questions: 52
Updated On: Oct 07, 2026

Question #1

Refer to the exhibit.

Each order can-have multiple products The data architect needs to make sure the Amount can be analyzed by Order Type and Product Category.
The Order Number field data always contains the Order Type in the first three characters Product. Product Category, and Sales Channel data are available in an Excel spreadsheet called "Categories" in the file PaperProducts xlsx.
Which two ways can the data architect use to make additions to the existing script and meet the requirements?
(Choose two.)
A)

A. Option B

B. Option D

C. Option C

D. Option A

Discussion 0

Correct Answer: C Vote an answer

Question #2

Refer to the exhibit.

A system creates log files and csv files daily and places these files in a folder. The log files are named automatically by the source system and change regularly. All csv files must be loaded into Qlik Sense for analysis.
Which method should be used to meet the requirements?
A)

A. Option B

B. Option D

C. Option C

D. Option A

Discussion 0

Correct Answer: B Vote an answer

Question #3

Refer to the exhibit.

A major healthcare organization requests a new app with the following requirements:
* Users can filter AdmissionDate and DischargeDate by all fields in the Master Calendar table
* Use an existing QVD file which includes dates 20 years into the future
* Users should not be able to filter on dates that have no associated encounters Which approach should the data architect take to meet these requirements?

A. 1. Load the Master Calendar and Encounters tables
2 Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Admission Date
3 Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Discharge Date

B. 1. Load the master calendar
2. Create two mapping tables called AdmissionCalendar anADischargeCalendar from the Resident master calendar that has all fields appropriately named
3 Load the Encounters table and use ApplyMap for the AdmissionDate and DischargeDate appropriately

C. 1. Load the master calendar as AdmissionCalendar and alias the fields to reflect they are for Admission
2. Load the master calendar as DischargeCalendar and alias the fields to reflect they are for Discharge
3. Load the Encounters table

D. 1 Load the Encounters table
2. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Admission Date
3. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Discharge Date

Discussion 0

Correct Answer: D Vote an answer

Question #4

A customer must create a production app that pulls data from two sources Source 1 is a large legacy system It takes more than one hour to read and save the data to a QVD Reading from the QVD only takes 20 seconds The data only needs to be refreshed every month because it does not change very often Source 2 is a small online data source Reloading this data takes less than one minute The production app must be refreshed every hour to see the most updated data and needs both data sets to meet the analysis requirements How should the data architect set up the data reload?

A. 1 Create the productioff app to connect to both data sources
2. Create a variable and set this to the last reload time using ReloadTimeQ function
3. Use an IF() statement and only load the legacy data when TodayO > 30 days from last reload 4 Create a task to run every hour to reload the production app

B. 1. Create a QVD generation app for the legacy system only
2. Create a scheduled task to generate the QVD every month
3 Build the production app using the QVD and use ADD LOAD prefix to connect to the online data source
4. Create a task to run every hour to perform a partial reload on the production app

C. 1 Create two QVD generation apps
2- Create two scheduled tasks one runs every month and one runs every hour
3. Load the data in the production app from the QVDs
4. Create a task to run every hour to reload the production app

D. 1. Create a QVD generation app to pull both data sources in different script sections
2. Create two reload schedules from the QVD app based on the script section
3. Build the production app using the QVD files
4. Create a task to run every hour to reload the production app

Discussion 0

Correct Answer: C Vote an answer

Question #5

Payroll managers need access to the payroll system to complete a quarterly report. A username and password is required to access the payroll system through an ODDC connection Only the system administrator should have access to the credentials and make updates as needed Each payroll manager who accesses the app should only see their own employees.
Which two actions are required to set up the appropriate security? (Select two.)

A. Make sure that the administrator applies the correct security rules to the ODBC connection

B. Apply the correct section access to restrict data visibility

C. Make sure that the administrator applies security rules to the correct stream to restrict data visibility

D. Make sure that the administrator creates appropriate sync rules to access the payroll system

E. Apply security rules to the app to restrict data visibility

Discussion 0

Correct Answer: A,B Vote an answer

Question #6

A company builds several apps to help analyze product performance
* Each app is for a specific business area: Marketing, Sales, or Production
* Users must see updated data daily
* Data is taken from the enterprise data warehouse (EDW)
* Change requests for the data warehouse take approximately 6 weeks
* One of the dimensions used across all of the apps is product group
* There are six different product groups
To provide users with an intuitive way of working with data, the colors that represent the product groups must be the same in all apps The RGB color codes for each product group will be provided to the data architect by e-mail How should the data architect add consistent colors for the product group dimension that are easy to maintain?

A. Add the color codes in the EDW

B. Add the color codes using expressions

C. Add the color codes using a text file

D. Add the color codes using variables

Discussion 0

Correct Answer: C Vote an answer

Download Free Qlik QSDA2018 Demo

Simply submit your e-mail address below to get started with our free demo of your Qlik QSDA2018 exam.