Qlik Qlik Sense Data Architect QSDA2018 Questions & Answers

• Question 31:

  Refer to the exhibit.

  

  One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet. The Region field only was values for the first record for the region. The data architect must perform a transformation so that each row contains the correct Region.

  Which function should the data architect implement to resolve this issue?

  A. CrossTable

  B. IntervalMatch

  C. Above

  D. Previous

  Correct Answer: B

• Question 32:

  Refer to the exhibit.

  

  A data architect is reviewing an app that is under development. The app as NOT been published. All data has been validated in all charts and KPIs. The data architect notices that the data model has two fact tables with common field names that cause a synthetic join.

  Which step should the data architect take to correct the data model without affecting the app?

  A. Concatenate LOAD the data from the Sales and Budget tables to combine into a single table.

  B. Create a composite key in the Sales and Budget tables that consists of the Year, EmployeeID, and ProductID

  C. Perform a composite key in the Sales and Budget tables instead of loading Year, EmployeeID, and ProductID

  D. Perform a mapping load for the Employees table and use ApplyMap in the Sales and Budget tables.

  Correct Answer: D

• Question 33:

  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

  Correct Answer: C

• Question 34:

  Refer to the exhibits.

  

  

  A company notices that product sales have decreased. A data architect needs to create an app to show the correlation between the decreased revenue and the latest customer survey results.

  Which Qlik Sense feature should the data architect use to meet this requirement?

  A. Section access

  B. On-demand App Generation

  C. Master item library

  D. Associative data model

  Correct Answer: C

• Question 35:

  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

  Correct Answer: A

• Question 36:

  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.

  Correct Answer: A

• Question 37:

  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

• Question 38:

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

  Correct Answer: AC

• Question 39:

  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: D

• Question 40:

  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

  Correct Answer: B