QlikView QSDA2018 - Qlik Sense Data Architect Certification Exam Exam
Page: 3 / 10
Total 50 questions
Question #11 (Topic: Single Topic)
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 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 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
B. 1. Load the master calendar 2. Create two mapping tables called AdmissionCalendar and DischargeCalendar from the Resident master calendar that has all fields appropriately named 3. Load the Encounters and use ApplyMap for the AdmissionDate and DischangeDate appropriately.
C. 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
D. 1. Load the master calendar as AdmissionCalendar and alias the fields to reflect they are for Admission 2. Load the master calendar as Discharge Calendar and alias the fields to reflect they are for Discharge 3. Load the Encounters table
Answer: B
Question #12 (Topic: Single Topic)
Refer to the exhibit.
A data architect needs to build a dashboard that displays the aggregated sales for each sales representative. All aggregations on the data must be performed in
the script.
Which script should the data architect use to meet these requirements?
A.
B.
C.
D.
A data architect needs to build a dashboard that displays the aggregated sales for each sales representative. All aggregations on the data must be performed in
the script.
Which script should the data architect use to meet these requirements?
A.
B.
C.
D.
Answer: A
Question #13 (Topic: Single Topic)
Refer to the exhibit.
A data architect needs to transform the values for SalesYear from 'Sales 2016' to display only the year values '2016' and '2017' in the table.
Which two functions can the data architect use to accomplish this in the script? (Choose two.)
A data architect needs to transform the values for SalesYear from 'Sales 2016' to display only the year values '2016' and '2017' in the table.
Which two functions can the data architect use to accomplish this in the script? (Choose two.)
A. Right(ג€˜$(vSalesSheet)ג€™ as SalesYear
B. Left($(vSalesSheet)ג€™ 4) as SalesYear
C. SubField($(vSalesSheet)ג€™,ג€™ ג€˜,2) as SalesYear
D. LTrim(ג€˜$(vSalesSheet)ג€™) as SalesYear
E. SubField($(vSalesSheet)ג€™,ג€™ ג€˜,1 ) as SalesYear
Answer: AC
Question #14 (Topic: Single Topic)
An enterprise data warehouse contains 700 million records. This enterprise data warehouse has a three-tiered architecture and uses QVDs.
The Qlik Sense server contains 24 GB RAM and contains two processors with eight cores. The company needs to allow vendors to access a Qlik Sense app
anonymously to review past business transactions and current year-to-date performance.
Which method should the data architect use to meet this requirement?
The Qlik Sense server contains 24 GB RAM and contains two processors with eight cores. The company needs to allow vendors to access a Qlik Sense app
anonymously to review past business transactions and current year-to-date performance.
Which method should the data architect use to meet this requirement?
A. Build an On-Demand Application Generation template app and a selection app, and allow vendors to access anonymously.
B. Build an On-Demand Application Generation template app and a selection app, and require vendors to log into Qlik Sense to view the app.
C. Build a Direct Discovery app that enables users to view their individual content using dynamic QVDs.
D. Build a Direct Discovery app that enables users to view their individual content using Section Access.
Answer: A
Question #15 (Topic: Single Topic)
The dates are stored as strings in the database. The data architect must convert the dates to date format. The reload must be as fast as possible.
Which script should the data architect use?
A.
B.
C.
D.
Which script should the data architect use?
A.
B.
C.
D.
Answer: B
