QlikView QSDA2024 - Qlik Sense Data Architect Certification Exam - 2024 Exam
Page: 3 / 10
Total 50 questions
Question #11 (Topic: Exam A)
The data architect has been tasked with building a sales reporting application.
• Part way through the year, the company realigned the sales territories
• Sales reps need to track both their overall performance, and their performance in their current territory
• Regional managers need to track performance for their region based on the date of the sale transaction
• There is a data table from HR that contains the Sales Rep ID, the manager, the region, and the start and end dates for that assignment
• Sales transactions have the salesperson in them, but not the manager or region.
What is the first step the data architect should take to build this data model to accurately reflect performance?
• Part way through the year, the company realigned the sales territories
• Sales reps need to track both their overall performance, and their performance in their current territory
• Regional managers need to track performance for their region based on the date of the sale transaction
• There is a data table from HR that contains the Sales Rep ID, the manager, the region, and the start and end dates for that assignment
• Sales transactions have the salesperson in them, but not the manager or region.
What is the first step the data architect should take to build this data model to accurately reflect performance?
A. Implement an "as of" calendar against the sales table and use ApplyMap to fill in the needed management data
B. Create a link table with a compound key of Sales Rep / Transaction Date to find the correct manager and region
C. Use the IntervalMatch function with the transaction date and the HR table to generate point in time data
D. Build a star schema around the sales table, and use the Hierarchy function to join the HR data to the model
Answer: C
Question #12 (Topic: Exam A)
A data architect inherits an app that takes too long to load and overruns the data load window.
The app pulls all records (new and historical) from three large databases. The reload process puts a heavy load on the source database servers. All of the data is required for analysis.
What should the data architect do?
The app pulls all records (new and historical) from three large databases. The reload process puts a heavy load on the source database servers. All of the data is required for analysis.
What should the data architect do?
A. Make sure the individual reload tasks in the QMC are not running in parallel
B. Implement Direct Discovery with partial load
C. Implement incremental load on each database using QVD files
D. Implement ODAG to split out the app into smaller chunks
Answer: C
Question #13 (Topic: Exam A)
A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales. The sort order of the values of the fields is unknown. When two or more sales people have sold the same amount, the expression should return all of those sales people.
Which expression should the data architect use?
Which expression should the data architect use?
A. Concat(DISTINCT IF(Aggr(Rank(Sum(Sales),4),SalesPerson)=1,SalesPerson),' ')
B. FirstSortedValue(DISTINCT SalesPerson,-Aggr(Sum(Sales),SalesPerson))
C. FirstSortedValue(SalesPerson,-Aggr(Sum(Sales),SalesPerson))
D. Concat(DISTINCT IF(Aggr(Rank(Sum(Sales),1),SalesPerson)=1,SalesPerson),' ')
Answer: D
Question #14 (Topic: Exam A)
A data architect in the Enterprise Architecture team wants to develop a new application summarizing Qlik Sense usage by all company employees. They also want to gather usage metrics for other systems.
Who should the data architect contact to be granted access to the data?
Who should the data architect contact to be granted access to the data?
A. IT Security Director, Human Resources Director, Qlik Sense Administrator
B. IT Security Manager, Qlik Sense Account Manager, Enterprise Architecture Director
C. IT Security Analyst, Qlik Sense Developers, Solutions Architect
D. IT Security Vice President, Human Resources Analyst, Qlik Sense Developers
Answer: A
Question #15 (Topic: Exam A)
Refer to the exhibit.
A data architect must load the two tables without creating a synthetic key. The data architect also must make sure expressions like Sum([Budgeted Sales]) are calculated correctly.
Which load script meets these requirements?
A data architect must load the two tables without creating a synthetic key. The data architect also must make sure expressions like Sum([Budgeted Sales]) are calculated correctly.
Which load script meets these requirements?
A. 
B. 
C. 
D. 
B.
C.
D.
Answer: D
