Qlik Qlik Sense Data Architect QSDA2018 Questions & Answers

• Question 11:

  Refer to the exhibits.

  

  Which values of the REGION field will be visible for User C when the user opens the app?

  A. EAST, WEST, and SOUTH

  B. NORTH, EAST, and WEST

  C. NORTH, EAST, WEST, and SOUTH

  D. EAST and WEST

  Correct Answer: C

• Question 12:

  Refer to the exhibit.

  

  Each order can have multiple products. The data architect needs to make sure the Amount can be analyzed by order Type and product Category.

  The Order Number field data always contains the order Type in the first three characters. Product, Product Category, and Sales Channel data are available in an Excel spreadsheet called "Categories" in the file PaperProducts.xlsx.

  Which way can the data architect use to make additions to the existing script and meet the requirements?

  

  A. B.

  

  C.

  

  D.

  Correct Answer: AB

• Question 13:

  Refer to the exhibits.

  

  The two tables have been loaded by the script shown. This script creates a synthetic key, which is not desired. The Dept code in the Employee table is incorrect for EmpID=3. The data architect must change line 27 to create a single table in the data model that is accurate.

  Which LOAD statement should the data architect use?

  A. JOIN LOAD EmpID, ManagerID, Level

  B. KEEP LOAD EmpID, ManagerID, Level

  C. JOIN LOAD *

  D. CONCATENATE LOAD EmpID, ManagerID, Level

  Correct Answer: A

• Question 14:

  A customer must create a production app that pulls data from two sources.

  Source 1 is large legacy system. It takes more than one hour to read and save the data to QVD. reading from the QVD only takes 20 seconds. The data only needs to be refreshed every month because it does not change very often.

  Source 2 is small online data source. reloading this data takes less than one minute. The production app must be refreshed every hour to see the most updated data and needs both data sets to meet te analysis requirements.

  How should the data architect set up the data reload?

  A. 1. Create two QVD generation apps

  2.

  Create two scheduled tasks: one runs every month and one runs every hour

  3.

  Load the data in the production app from the QVDs

  4.

  Create a task to run every hour to reload the production app

  B. 1. create a QVD generation app to pull both data sources in different script sections

  2.

  Create two reload schedules from the QVD app based on the script section

  3.

  Build the production app using the QVD files

  4.

  Create a task to run every hour to reload the production app.

  C. 1. Create the production app to connect to both data sources

  2.

  Create a variable and set this to the last reload time using ReloadTime() function

  3.

  Use an IF() statement and only load the legacy data when Today() > 30 days from last reload

  4.

  Create a task to run every hour to reload the production app

  D. 1. Create a QVD generation app for the legacy system only

  2.

  Create a scheduled task to generate the QVD every month

  3.

  Build the production app using the QVD and use ADD LOAD prefix to connect to the online data source

  4.

  Create a task to run every hour to perform a partial reload on the production app

  Correct Answer: A

• Question 15:

  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

  Correct Answer: A

• Question 16:

  Refer to the exhibit.

  

  A fashion retail company needs to analyze data product inventory. The company needs to filter by attributes by such as color, material, and size.

  Which strategy should a data architect use to meet these requirements?

  A. Turn data rows into fields by using a generic load

  B. Use the hierarchy load statement to expand hierarchy levels

  C. Use crosstable in the load statement to unpivot

  D. Loop through the table to transpose fields

  Correct Answer: A

• Question 17:

  A data architect must break down a 13-character ShipmentID code in the following format, # ### ## ## #. Separate fields must be created from the numeric values separated by the hyphen (-). The data architect must extract five sub-fields (ShipmentLoc, Quantity, CategoryID, StoreLoc, and Division) from the 13character code.

  How should the data architect meet this requirement?

  A. In the data manager, use the data profiling card to replace the `-` characters in the ShipmentID

  B. In the data load editor, load the ShipmentID field and apply the PurgeChar9ShipmentID,'-`) function

  C. In the data manager, use the data profiling card to split the ShipmentID by the `-` character

  D. In the data load editor, load the ShipmentID field and apply the KeepChar() and Trim() functions

  Correct Answer: C

• Question 18:

  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

  Correct Answer: A

• Question 19:

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

  Correct Answer: B

• Question 20:

  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

  Correct Answer: D