QlikView QSDA2018 Online Practice Questions and Exam Preparation

QlikView QSDA2018 Online Questions & Answers

• Question 11:

  Refer to the exhibit.

  

  A QlikView app was converted to a Qlik Sense app using the Dev Hub converter.

  The new Qlik Sense app was reloaded without editing the script or the server settings, which created a script error.

  What should a data architect do to resolve the issue?

  A. Delete the Qualify statement
  B. Add fields to the Qualify statement
  C. Use a folder connection
  D. Check the QVDs
  C. Use a folder connection

• Question 12:

  A data architect needs to develop three separate apps (Sales, Finance, and Operations). The three apps share numerous identical calculation expressions. The data architect wants to reduce duplicate script and stores it on a file server that Qlik Sense can access.

  How should the data architect complete requirements?

  A. Call batch file
  B. Macro on server
  C. Execute server script
  D. Include script function
  D. Include script function

• Question 13:

  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?

  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.
  A. Build an On-Demand Application Generation template app and a selection app, and allow vendors to access anonymously.

• Question 14:

  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. Option A
  B. Option B
  C. Option C
  D. Option D
  B. Option B

• Question 15:

  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 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
  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.

• Question 16:

  Refer to the exhibit.

  

  An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data. When trying to manually reload the original script, the data architect receives an error. What should be done to make sure the script runs correctly?

  A. Add the line LIB CONNECT TO `SQL (abc_qservice)'; before the LOAD for the OrderDetail table.
  B. Give the data architect the Read rights on the data connections in the QMC.
  C. Make the data architect the owner of the app in the QMC.
  D. Add the LIB CONNECT TO `QVD (abc_qservice/OrderData.qvd)'; before the LOAD for the OrderData table.
  A. Add the line LIB CONNECT TO `SQL (abc_qservice)'; before the LOAD for the OrderDetail table.

• Question 17:

  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. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 18:

  A data architect has a QVD file that contains data from many countries. The data architect must write a script that loads only data from France, and make sure the reload occurs as fast as possible. Which script should the data architect use to meet these requirements?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

• Question 19:

  Refer to the exhibit.

  

  A global company recently released an app that uses mush more memory than similar apps have used. When reviewing data in the data manager, the data architect observes that several fields use Globally Unique Identifiers (GUIDs).

  There is one key field. other fields are used to different KPIs to count the number records. The data architect must reduce the memory used as much as possible.

  Which steps should a data architect take to meet these requirements?

  A. 1. Use the AutoNumber function to convert the linking GUIDs to numbers 2. Replace the non-key GUID fields with a flag, and use them to get a unique count for KPIs
  B. 1. Replace the non-key field GUIDs with RowNo() to maintain a field that can be used to get a unique count 2. Split the linking GUID fields into five sections using the SubField function to reduce the uniqueness.
  C. 1. Use the AutoNumber function to convert the linking GUIDs to numbers 2. Use Indexing for non-key GUID fields to create an Index field and use to get a unique count for KPIs
  D. 1. Use the IterNo() function to convert the linking GUIDs to numbers 2. Replace the non-linking GUID fields with RowNo() to create an Index field and use to get a unique count for KPI
  D. 1. Use the IterNo() function to convert the linking GUIDs to numbers 2. Replace the non-linking GUID fields with RowNo() to create an Index field and use to get a unique count for KPI

• Question 20:

  Two companies have merged and full database integration is planned for next year. The data architect needs an interim solution to view all employee data from both companies.

  The tables come from different systems

  Both companies have similar Employees tables

  Both tables have identifiers for Employee and some other attributes (e.g., geographical information)

  The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)

  Which problem occurs when the two tables are loaded into Qlik Sense?

  A. Link tables are created
  B. Synthetic keys are created
  C. An auto concatenation occurs
  D. A circular reference occurs
  B. Synthetic keys are created