QlikView QSDA2018 Online Practice Questions and Exam Preparation

QlikView QSDA2018 Online Questions & Answers

• Question 21:

  Refer to the exhibit.

  

  The Country field in a CRM app is a free-form text field. More spelling variations and countries are expected in the future. A data architect must create a field called CountryCode based on the value in the Country field. Which script should the data architect create to perform this task?

  

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

• Question 22:

  A health system needs to analyze patient admission and discharges in a chart with a common date axis that looks like chart below.

  

  The initial date table (InpatientEncounters) contains a patient admission date and discharge date for each patient encounter. The data architect will use set analysis to calculate the number of admissions and discharges in the chart.

  

  The data architect needs to design a data model with a minimum number of tables. Which tables should the data architect create to meet these requirements?

  A. AdmissionCalendar, DischargeCalendar, and CommonCalendar
  B. AdmissionCalendar and DischargeCalendar
  C. DateLink, AdmisiionCalendar, and Dischange Calendar
  D. DateLink and CommonCalendar
  A. AdmissionCalendar, DischargeCalendar, and CommonCalendar

• Question 23:

  Refer to the exhibit.

  

  The data architect is using section access to meet the security requirements of an app. After the first draft, the data architect discovers that users can NOT see the right subset of data. Which solution should a data architect use to fix this issue?

  A. Associate the Section Access table with the data model
  B. Name the field for data reduced as "SectionAccess"
  C. Capitalize field names and values
  D. Capitalize only field values
  C. Capitalize field names and values

• Question 24:

  A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.

  Encounters, lab orders, and medication data are maintained in three separate tables linked by PatientID

  PatientID values in all three tables are completely accurate

  Patients may have encounters without lab orders or medications

  The data architect needs to make sure that the count of patient lab orders is correct.

  Which method should the data architect to meet this requirement?

  A. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(Distinct LabPatientID)
  B. load all three tables and use Count(Distinct PatientID)
  C. load all three tables and use Count(PatientID)
  D. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use count (LabPatientID)
  A. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(Distinct LabPatientID)

• Question 25:

  Refer to the exhibit.

  

  A data architect needs to build a Project Management dashboard. The ProjectStatus table lists all indexes in the fields. Descriptions for the indexes are stored in a single Master table. To build the dashboard, all descriptions should be in a single table:

  

  Which function should the data architect use to meet this requirement?

  A. Join
  B. PurgeChar
  C. ApplyMap
  D. Keep
  C. ApplyMap

• Question 26:

  Refer to the exhibits.

  

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

• Question 27:

  Refer to the exhibits.

  

  

  Business analytics report data issues in the Value field of a table since the latest reload of the data.

  What causing this issue?

  A. Null values in the source data
  B. Hyphen characters (`-`) in the source data
  C. Pre-aggregated data is being used
  D. Some categories do NOT exist in the Category table
  A. Null values in the source data

• Question 28:

  A company builds several apps to help analyze product performance.

  Each app is for a specific business area: Marketing, Sales, or Production

  Users must see updated data daily

  Data is taken from the enterprise data warehouse (EDW)

  Change requests for the data warehouse take approximately 6 weeks.

  One of the dimensions used across all of the apps is product group

  There are six different product groups

  To provide users with an intuitive way of working with data, the colors that present the product groups must be the same in all apps. The RGB color codes for each product group will be provided to the data architect by e-mail.

  How should the data architect add consistent colors for the product group dimension that are easy to maintain?

  A. Add the color codes using a text file
  B. Add the color codes using expressions
  C. Add the color codes in the EDW
  D. Add the color codes using variables
  A. Add the color codes using a text file

• Question 29:

  A data architect is working on a time and expense app for an organization that has Sales, Marketing, and Finance departments/ Department managers should only be able to view the data for their department's team members. Where should the data architect apply this security restriction?

  A. Data load editor
  B. Qlik Management Console
  C. Expression editor
  D. Data manager
  A. Data load editor

• Question 30:

  Refer to the exhibit.

  

  In the data load editor, the tables are loaded in the following sequence:

  1.

  OrderHeader

  2.

  OrderDetails

  3.

  Products

  The three tables CANNOT be modified as all fields are required. A data architect must create a Cost of Goods Sold (COGS) field calculated as UnitCost* Quantity. Some products may NOT have UniCost, so the COGS value must be zero for these products.

  How should the data architect meet this requirement?

  A. 1. Load the Products table as the first table 2. Create a new field in the OrderDetails table: Quantity * IsNull (UnitCost) as COGS
  B. 1. Perform a preceding load on the Product table 2. Create a new field in the OrderDetails table: if((UnitCost ?null() or ", 0) * Quantity as COGS
  C. 1. Join the Products and OrderDetails on ProductID 2. Create a new field in the OrderDetails table: Replace(Null, 0, UnitCost) * Quantity as COGS
  D. 1. Create a mapping load table as the first table from the Product table 2. Create a new field to the OrderDetails table: ApplyMap (`UnitCost_Map', ProductID, 0) * Quantity as COGS
  D. 1. Create a mapping load table as the first table from the Product table 2. Create a new field to the OrderDetails table: ApplyMap (`UnitCost_Map', ProductID, 0) * Quantity as COGS