Qlik Sense Data Architect certification questions and exam summary helps you to get focused on the exam. This guide also helps you to be on QSDA2019 exam track to get certified with good score in the final exam.
Qlik Sense Data Architect (QSDA2019) Certification Summary
● Exam Name: Qlik Sense Data Architect
● Exam Code: QSDA2019
● Exam Duration: 120 minutes
● Exam Questions: 50
● Passing Score: 58%
● Exam Price: $250 (USD)
● Books:
● Exam Registration: Pearson VUE
● Sample Questions: Qlik Sense Data Architect Certification Sample Question
● Practice Exam: Qlik Sense Data Architect Certification Practice Exam
Qlik Sense Data Architect (QSDA2019) Certification Exam Syllabus
01. Identify Requirements for Data Models (16% of the exam)
- Identify the data load and refresh requirements (e.g., tiered architecture, multiple data sources, varying refresh times)
- Given a scenario, identify Qlik Sense features to meet customer needs (e.g., associative data model, master items, ODAG, GeoAnalytics)
- Outline steps to implement security requirements
02. Design Data Models (28% of the exam)
- Determine an appropriate data model design to meet customer needs
- Decide on an appropriate data model that prioritizes reuse, scalability, and efficiency (e.g., tiered architecture, data governance)
- Determine how to manage complex scenarios (e.g., calendar, set analysis, flags, functions)
03. Build Data Models (34% of the exam)
- Create data models (e.g., join, keep, resident load, where clause, incremental load, purge strategy, variable)
- Given a scenario, use data transformation techniques with both data load editor and data manager
- Manage security using section access
- Use the Qlik Converter to migrate QlikView documents to Qlik Sense applications
- Use appropriate data connections
04. Validate Data (22% of the exam)
- Validate data models against source information using Qlik Sense visualizations
- Resolve data modeling issues (e.g., synthetic keys, circular references, scripting errors, debugging)
- Resolve data issues (e.g., null values, data formatting)
Qlik Sense Data Architect (QSDA2019) Certification Questions
01. A data architect is building an app for a large healthcare organization, and is given these requirements:
- Load data from SQL Server for eight hospitals
- Load data from Oracle for six hospitals
- All data must be refreshed once per day
- Users must see details of each transaction
- Most users should only see data for their hospital
- Some users will have access to all data
Which approach should the data architect take?
a) Create a task that runs daily to load data from each system
Use an incremental load strategy to add the daily data
Create security rules in the QMC
b) Create a task that runs daily to load data from each system
Use an incremental load strategy to add the daily data
Use section access
c) Build a data warehouse from all sources
Create a task that runs daily to load data from each system
Create security rules in the QMC
d) Create a task that runs daily to load data from each system
Use a binary load process to load the data
Use Section access
02. A data architect creates a new Finance app in Qlik Sense Desktop and is ready to publish it so that Finance users and Executives are able to access it.
The app contains a single data connection called PRODDB. The Qlik Sense Enterprise hub has several streams configured and secured: Sales, HR, Finance and Executive, IT, and Everyone.
Which instructions should the data architect provide to the system administrator to make sure that the app can be reloaded daily and accessed by the right users?
a) 1. Import the new Finance app and publish to the 'Finance and Executive' stream
2. Create the data connection called PRODDB
b) 1. Publish the app QVF file to the 'Finance and Executive' stream
2. Publish the data connection, PRODDB, to the 'Finance and Executive" stream
c) 1. Import the new Finance app and publish to the 'Finance' stream
2. Import the data connection called PRODDB
d) 1. Copy the app QVF file to the 'Finance and Executive' directory
2. Create a new data connection called PRODDB
03. A data architect is using the Qlik View converter to load a Qlik View document into Qlik Sense. The convertor does not load the Qlik View document correctly.
Which two reasons will cause the convertor to fail?
(Select two)
a) Show/hide conditions are used in the Qlik View document
b) The Qlik View document contains hidden scripts
c) The Qlik View document has section access applied
d) Variables have been used in the Qlik View load script
e) The Qlik View document contains charts not found in Qlik Sense
04. A data architect must load data from an online source using the REST connector. The REST endpoint must be called several times and pass different values into a query parameter each time to retrieve all required data.
The URL and the other query parameters do NOT change between calls. The parameter values are stored in an existing table in the data model. These values have been previously loaded and may change during each data reload.
A REST connector has already been set up with the appropriate URL and static query parameters.
Which steps should the data architect use to retrieve all data?
a) 1. Select the Add missing query parameters checkbox in the REST connector
2. Use a FOR loop, No Of Rows () and Peek() functions
3. Use WITH CONNECTION to add the relevant query parameter
b) 1. Amend the REST connector and add the new query parameter with a value of *
2. Ensure the association field matches the previous table
3. Perform a LEFT KEEP to ensure only the needed results are loaded
c) 1. Create a new REST connection for each query value
2. Use a FOR loop, No Of Rows () and Peek () functions
3. Call the appropriate REST connection dynamically for each loop iteration
d) 1. Copy the URL from the REST connector and create a Web File connector
2. Use a FOR loop, No Of Rows () and Peek () functions
3. Amend the Web File connector URL in each iteration
05. A data architect notices an issue with a measure in the master items. Item '5126' is used only for testing and must be excluded from the total.
Which is the correct expression to meet this requirement?
a) =Sum({$<ltemNumber -= {5126}>}[Total Value))
b) =Sum({$-ltemNumber = {" 5126"}>}[Total Value))
c) =Sum({$<ltemNumber = {}5126}>}[Total Value))
d) =Sum({$<ltemNumber != {"5126"}>}[Total Value))
06. A data architect makes changes to a data model in an app that has 123 million rows of data. Each time the data is loaded, it takes 30 minutes. The data architect must limit the time required to validate changes to the data model.
What should the data architect do?
a) Open the debugger, set number of lines to 100, and click Run
b) Insert a breakpoint at the LOAD command, open the debugger, and 0 step through the code
c) Open the debugger, check Limited Load, and click Run
d) Create a smaller data set in the database to load into the app
07. A sales team has access to a Sales Performance app. The app contains the Sales Goal metric, which is a complex calculation used in multiple visualizations. Individual users must drag and drop the Sales Goal metric into their own analyses.
What should a data architect create to store the formula to calculate the Sales Goal?
a) A master item in the assets panel
b) A variable in the assets panel
c) A variable in the data load editor
d) A master item in the data load editor
08. The Human Resources department sends the data architect an Employees table with newly hired employees in a monthly spreadsheet.
The spreadsheet always has the same data structure and fields, but sometimes includes duplicates of previously hired employees. The data architect must load the Employees table into the data model each month, without duplication of the records.
Which action should the data architect take to meet this requirement?
a) Load the first Employees table and perform a full OUTER JOIN with the latest Employees table to the original.
b) Load the first Employees table, updating the next month's Employees table using WHERE NOT EXISTS clause
c) Load the Employees table by concatenating the latest Employees table to the previous month's table.
d) Load the Employees table each month and LEFT JOIN the current table to the previous month's table.
09. An analyst needs to review sales information for the previous year-to-date and the current year. The data in the sales app is refreshed daily.
The Date field contains both past and future dates. The data architect decides to create two flags as master items.
Which two functions will meet these requirements?
(Select two)
a) YearToDate(Date)
b) SetDateYear(Date,1)
c) InYear(Date,Today0,0)
d) YearToDate(Date,-1)
e) InYearToDate(Date-365,Today())
10. User A is the owner of a Qlik Sense app that uses section access. User A is NOT included in the Section. Access table of the app. The app is published in the Sales stream. A security rule grants User A access to the Sales stream.
User A accesses the Sales stream in the hub to open the app. What is the result?
a) User A sees the app in the Sales stream, but is unable to open it and sees an "Internal Error" message
b) User A does NOT see the app in the Sales stream
c) User A sees the app in the Sales stream and is able to open the app
d) User A sees the app in the Sales stream, but is unable to open it and sees an "Access Denied" message
Answers:
Question: 01: Answer: b
Question: 02: Answer: b
Question: 03: Answer: b, c
Question: 04: Answer: a
Question: 05: Answer: a
Question: 06: Answer: c
Question: 07: Answer: a
Question: 08: Answer: b
Question: 09: Answer: a, d
Question: 10: Answer: d
Commentaires