QlikView QSDA2022 Online Practice Questions and Exam Preparation

QlikView QSDA2022 Online Questions & Answers

• Question 21:

  

  Refer to the exhibit.

  A data architect is loading two tables: Orders and Product. The Product table includes attributes and values for each ProductID such as Colour, Price, Category, and Description.

  The business analyst can filter by the value of these attributes. For performance reasons, the Data Model will use two tables.

  Which solution should the data architect apply in the Data Load Editor to build the ProductDetails table?

  For performance reasons, the Data Model will use two tables a Load Editor to build the ProductDetails table?

  A. Use a For loop to concatenate all of the Products table and apply a Generic Load to the final concatenate table
  B. Use a For loop to apply a Generic load to the Product table and concatenate the generic tables together
  C. Use a Generic Load in the Product table and a For loop to left join each Generic table
  C. Use a Generic Load in the Product table and a For loop to left join each Generic table

• Question 22:

  A data architect needs to efficiently prepare a data model for a meeting in an hour.

  The data source to be used contains five date fields The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD) The app is NOT going to be published It will only be used for this meeting

  and a single user's ad-hoc analysis.

  What should the data architect do to meet these requirements?

  A. Use the data manager
  B. Load a calendar island
  C. Create a canonical calendar
  D. Create five master calendars
  C. Create a canonical calendar

• Question 23:

  Refer to the exhibits.

  

  Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.

  The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.

  What should the data architect do to resolve this issue?

  A. Open the data manager, split the Customers table, and associate both tables on CustomerlD field
  B. Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field
  C. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD
  D. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table
  C. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD

• Question 24:

  A customer has a dataset that contains latitude and longitude data for service points around the country. The data is retrieved using the following statement:

  

  It must be clear to the end user that this is geographic data. Drag and drop, map-based visualization of this data is required. Which two steps should the data architect take to support this data? (Select two.)

  A. Define Location as a master item, and set the tag to Sgeodata
  B. Add GeoProject{' Point' , LatandLong) AS Point to the preceding load
  C. Add GeoKakePoint (Lat, Long} as Point to Location's preceding load
  D. Add the following to the end of the script: TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;
  E. Add the following to the end of the script: TAG FIELD LocationName With 'Sgeoname', @relates_Pt'; TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden';
  B. Add GeoProject{' Point' , LatandLong) AS Point to the preceding load
  E. Add the following to the end of the script: TAG FIELD LocationName With 'Sgeoname', @relates_Pt'; TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden';

  ---

  Explanation/Reference:

• Question 25:

  A data architect wants to combine data on present and historic sales performance. The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table. Which script should the data architect use?

  

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

  ---

  Explanation/Reference:

• Question 26:

  A data architect needs to develop a script to export tables from a model based upon rules from an independent file. The structure of the text file with the export rules is as follows:

  

  These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.

  The TableToExport values are already verified to exist in the model.

  In addition, the format will always be QVD, and the copies will be incrementally numbered.

  For example, the Customer table would be exported as:

  What is the minimum set of scripting strategies the data architect must use?

  A. Two loops without any conditional statement
  B. One loop and two IF statements
  C. Two loops and one IF statement
  D. One loop and one SELECT CASE statement
  D. One loop and one SELECT CASE statement

  ---

  Explanation/Reference:

  The data architect will need to use a single loop to iterate through the rows of the independent file containing the export rules. Within the loop, they will need to use a SELECT CASE statement to determine which table in the model to export based on the TableToExport value in the current row of the independent file. They can then use the StoreAsFilename value to determine the target root filename, and the NumberOfCopies value to determine the number of copies to export. This approach makes use of a single loop to iterate through the rows of the independent file, and a SELECT CASE statement to determine which table to export based on the TableToExport value in the current row. It is the most efficient way to accomplish the task with minimal scripting. You can find the Qlik scripting documentation for Store statement here:https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Store.htmand SELECT CASE statement here:https://help.qlik.com/en- US/ sense/June2020/Subsystems/Hub/Content/Scripting/ScriptStatements/Select.htm

• Question 27:

  Refer to the exhibit.

  

  A business department is forecasting revenue within an Excel spreadsheet.

  A data architect needs to include this forecast into the existing data model, and without losing any data.

  Which two sets of steps will meet these requirements? (Select two.)

  A. 1. Load the Excel spreadsheet using the data load editor 2. Use the Unpivot function 3. Use the Sum function to group the forecast by date 4. Connect to the existing data model
  B. 1. Load the Excel spreadsheet using the data load editor 2. Use the Crosstable function to unpivot the table 3. Create a composite key out of the date and region 4. Connect the new table to the data model
  C. 1 Load the Excel spreadsheet using the data load editor 2. Change the sort order by date 3. Create a composite key out of the forecast and region 4. Connect to the existing data model
  D. 1 Load the Excel spreadsheet into the data manager 2. Use the Unpivot function 3. Create a composite key from the date and region 4. Connect the new table to the data model
  E. 1. Load the Excel spreadsheet using the data manager 2. Rename the ForecastDate field to Date 3. Disable the Region 4. Connect to the existing data model
  B. 1. Load the Excel spreadsheet using the data load editor 2. Use the Crosstable function to unpivot the table 3. Create a composite key out of the date and region 4. Connect the new table to the data model
  D. 1 Load the Excel spreadsheet into the data manager 2. Use the Unpivot function 3. Create a composite key from the date and region 4. Connect the new table to the data model

  ---

  Explanation/Reference:

  Option B involves loading the Excel spreadsheet using the data load editor and then using the Crosstable function to unpivot the table, creating a composite key out of the date and region, and connecting the new table to the existing data model. Option D involves loading the Excel spreadsheet using the data manager, using the Unpivot function, creating a composite key from the date and region, and connecting the new table to the existing data model.

• Question 28:

  Refer to the exhibit.

  

  A data architect is loading the tables and a synth key is generated. How should the data architect resolve the synthetic key?

  A. Remove the LineNo field from Shipments and use the AutoNumber function on the
  B. Create a composite key using OrdertD and LineNo
  C. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlC field
  D. Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments
  D. Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments

• Question 29:

  A data architect plans to build an app that contains geographically diverse data that must be specific to user run-time selections. The source contains transactional data. The app must have minimal impact on already limited server resources.

  Which approach should the data architect use?

  A. Loop and Reduce
  B. QVDs
  C. In-memory
  D. ODAG
  B. QVDs

  ---

  Explanation/Reference:

  Using QVDs is the best approach for this scenario, as it allows the data to be stored in a highly compressed format, which will have minimal impact on server resources. Additionally, QVDs can be loaded quickly, which allows for faster access to the data based on user run-time selections. The other options, Loop and Reduce, In-memory, and ODAG, are not valid strategies for this scenario.

• Question 30:

  A data architect needs to load data from two different databases Additional data will be added from a folder that contains QVDs. text files, and Excel files. What is the minimum number of data connections required?

  A. Two
  B. Five
  C. Four
  D. Three
  D. Three