Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home QlikView QSDA2018

QlikView QSDA2018 Exam Practice Questions (P. 3)

  • Full Access (50 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #11
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?
  1. 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
  2. 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.
  3. 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
  4. 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

Correct Answer:
B

Question #12
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.


Correct Answer:
A

Question #13
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.)
  1. A
    Right('$(vSalesSheet)' as SalesYear
  2. B
    Left($(vSalesSheet)' 4) as SalesYear
  3. C
    SubField($(vSalesSheet)',' ',2) as SalesYear
  4. D
    LTrim('$(vSalesSheet)') as SalesYear
  5. E
    SubField($(vSalesSheet)',' ',1 ) as SalesYear

Correct Answer:
AC

Question #14
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?
  1. A
    Build an On-Demand Application Generation template app and a selection app, and allow vendors to access anonymously.
  2. 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.
  3. C
    Build a Direct Discovery app that enables users to view their individual content using dynamic QVDs.
  4. D
    Build a Direct Discovery app that enables users to view their individual content using Section Access.

Correct Answer:
A

Question #15
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.


Correct Answer:
B

Previous Questions Next Questions

All Pages