Free QSDA2022 – Qlik Sense Data Architect Certification Exam-2022 Practice Test Question

Select all that apply, then click Submit answer.

• ○

  Canonical calendar

• ○

  Generic load

• ○

  Data island

• ○

  Multiple calendars

• ○

  Link table

Select all that apply, then click Submit answer.

• ○

  Define Location as a master item, and set the tag to Sgeodata

• ○

  Add GeoProject{' Point' , Lat&Long) AS Point to the preceding load

• ○

  Add GeoKakePoint (Lat, Long} as Point to Location's preceding load

• ○

  Add the following to the end of the script:
  TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;

• ○

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

Select all that apply, then click Submit answer.

• ○

  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
   

• ○

  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
   

• ○

  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
   

• ○

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

Select all that apply, then click Submit answer.

• ○

  OQIikGeoAnalytics

• ○

  ODAG

• ○

  QIikDataMarket

• ○

  Qlik Storytelling

• ○

  QIik NPrinting
  

Select all that apply, then click Submit answer.

• ○

  The Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.

• ○

  In the Orders table, some CustomerlD values are null because there are orders with no customer.
  and needs to be incorporated in the table using the Calendar table, null because there are orders with no customer

• ○

  In the Orders table, some values in the CustomerlD field do not exist in the Customers table.

• ○

  The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table

Select an option, then click Submit answer.

• ○

  IntervalMatch

• ○

  Peek

• ○

  ApplyMap

• ○

  Inner Join
  

Select an option, then click Submit answer.

• ○

  Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

• ○

  Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship

• ○

  Join the Departments and Salespeople tables to resolve the many-to-many relationship

• ○

  Join the Transactions and Salespeople tables to resolve the many-to-many relationship

Select an option, then click Submit answer.

• ○

  1. Load the existing data from the QVD
  2. Load the new and updated data from the database without the rows that have just been loaded from the QVD and concatenate with data from the QVD
  3. Load all records from the key field from the database and use an INNER JOIN on the previous table
   

• ○

  1. Load the existing data from the QVD
  2. Load new and updated data from the database Concatenate with the table loaded from the QVD.
  3. Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records
   

• ○

  1. Use a partial LOAD to load new and updated data from the database.
  2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records
  3. Use the PEEK function to remove the deleted rows
   

• ○

  1. Load the new and updated data from the database.
  2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records.
  3. Load all records from the key field from the database and use an INNER JOIN on the previous table.

Select an option, then click Submit answer.

• ○

  Option A

• ○

  Option B

• ○

  Option C

• ○

  Option D

Select an option, then click Submit answer.

• ○

  3

• ○

  1

• ○

  6

• ○

  4