QlikView QSDA2018 Online Practice Questions and Exam Preparation

QlikView QSDA2018 Online Questions & Answers

• Question 41:

  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 13-character 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
  C. In the data manager, use the data profiling card to split the ShipmentID by the `-` character

• Question 42:

  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
  A. Turn data rows into fields by using a generic load

• Question 43:

  Refer to the exhibit.

  

  A chart for monthly hospital admissions and discharges incorrectly displays the month and year values on the x-axis. The date format for the source data field "Common date" is M/D/YYYY. This format was used in a calculated field named "Month-Year" in the data manager when the data model was first built.

  Which expression should the data architect use to fix this issue?

  A. Date (MonthsStart ([Common Date]), `MMM-YYY')
  B. Date (MonthStart ([Common Date]), `MMM-YYY')
  C. Date ([Common Date], `MMM-YYY')
  D. Date (InMonth([Common Date]), MMM-YYYY')
  B. Date (MonthStart ([Common Date]), `MMM-YYY')

• Question 44:

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

• Question 45:

  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
  A. JOIN LOAD EmpID, ManagerID, Level

• Question 46:

  Stocks levels are stored online in a system that keeps information for the current period only. What should the data architect do to enable analysis of the trends of the stock levels?

  A. Use On-Demand App Generation (ODAG) to create new apps from the selected period
  B. Capture the periodic information in an incremental QVD file for use in an app
  C. Create an app for each period as it changes and use document chaining
  D. Create an app for each period and use a binary load task to create a single app
  B. Capture the periodic information in an incremental QVD file for use in an app

• Question 47:

  Refer to the exhibit.

  

  An organization stores sales data in SQL Server. A database administrator creates a view to show the transaction data. The data architect must:

  Create a data model that shows the total sales for each salesperson by month

  Create an indicator that shows whether the total monthly sales meet or exceed the monthly quota, which is always $1,200

  Which script should the data architect use to meet these requirements?

  

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

• Question 48:

  A car manufacturer has several QlikView apps. The manufacturer decides to migrate some specific apps to Qlik Sense. The manufacturer decides to migrate some specific wants to reuse front-end variables from the previous QlikView app. Which strategy should a data architect use to meet these requirements?

  A. Use the QlikView converter within the Dev Hub of Qlik Sense
  B. Drag and drop a QVM file into the Qlik Sense hub and create a new app
  C. Export the existing LOAD script into a QVS file for later reuse in Qlik Sense
  D. Copy and paste the LOAD script of the existing QlikView app into the new app.
  A. Use the QlikView converter within the Dev Hub of Qlik Sense

• Question 49:

  Refer to the exhibit.

  

  How should the account that runs the Qlik Sense Services be configured in the Section Access table?

  A. ADMIN, QLIK_SERVICES,
  B. ADMIN, DOMAIN/QLIK_SERVICES,
  C. ADMIN, QLIK_SERVICES,*
  D. ADMIN, DOMAIN\QLIK_SERVICES,*
  C. ADMIN, QLIK_SERVICES,*

• Question 50:

  Refer to the exhibit.

  

  A data architect needs to resolve a synthetic key and make sure that users can see the unique department name and hospital name for each order. Which action should the data architect take?

  A. Remove DepartmentID from the LOAD statement for the Orders table
  B. Remove HospitalID from the LOAD statement for the Orders table
  C. Remove the Departments table from the LOAD script
  D. Remove the Hospitals table from the LOAD script
  B. Remove HospitalID from the LOAD statement for the Orders table