Free Qlik Sense Data Architect Certification Exam – 2024 Exam QSDA2024 Exam Practice Test

A startup company is about have its Initial Public Offering (IPO) on the New York Stock Exchange.This startup company has used Qlik Sense for many years for data-based decision making for Sales and Marketing efforts, as well as for input into Financial Reporting. The startup's Qlik Sense applications use variables that have different values at different points in time.Due to the increased rigor required in record keeping for public companies, these variables must be clearly recorded in the script reload logs of the Qlik Sense applications. These logs are refreshed daily.The data architect wants to have the variables names, with their current values, written into the script reload logs. Which script statement should the data architect use?

• LogDetail
• Trace
• Tag
• REM

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?

• Four
• Two
• Three
• Five

A data architect needs to acquire social media data for the past 10 years. The data architect needs to track all changes made to the source data, include all relevant fields, and reload the application four times a day.What information does the data architect need?

• A field with social media source, a set of key fields to sort out updated records, configure reload task to load four times a day
• A field with record creation time, a secondary key field to remove deleted records, configure reload task to load four times a day
• A field with ModificationTime, a primary key field to sort out updated records, insert and append records, update records
• A field with ModificationTime, a primary key field to sort out updated records, insert and update records, remove records

A Chief Information Officer has hired Qlik to enhance the organization's inventory analytics. In the initial meeting, the client's focus was determined to be forecasting inventory levels.Which stakeholder should be consulted first when gathering requirements?

• Product Buyer
• SQL Developer
• Vice President of Marketing
• Chief Information Officer

A data architect receives an error while running script. What will happen to the existing data model?

• The data model will be removed from the application.
• The latest error-free data model will be maintained.
• Newly loaded tables will be merged with the existing data model until the error is resolved.
• The data model will be replaced with the tables that were successfully loaded before the error.

A data architect needs to retrieve data from a REST API. The data architect needs to loop over a series of items that are being read using the REST connection.What should the data architect do?

• Recreate the SQL Statement with the correct parameters
• Use the REST Connector with pagination mechanism
• Use pagination of the REST Connector to create a template of the desired data
• Use With Connection to pass a parameter to the REST URL

A data architect inherits an app that takes too long to load and overruns the data load window.The app pulls all records (new and historical) from three large databases. The reload process puts a heavy load on the source database servers. All of the data is required for analysis.What should the data architect do?

• Make sure the individual reload tasks in the QMC are not running in parallel
• Implement Direct Discovery with partial load
• Implement incremental load on each database using QVD files
• Implement ODAG to split out the app into smaller chunks

The data architect has been tasked with building a sales reporting application.Part way through the year, the company realigned the sales territoriesSales reps need to track both their overall performance, and their performance in their current territoryRegional managers need to track performance for their region based on the date of the sale transactionThere is a data table from HR that contains the Sales Rep ID, the manager, the region, and the start and end dates for that assignmentSales transactions have the salesperson in them, but not the manager or region.What is the first step the data architect should take to build this data model to accurately reflect performance?

• Implement an "as of calendar against the sales table and use ApplyMap to fill in the needed management data
• Create a link table with a compound key of Sales Rep / Transaction Date to find the correct manager and region
• Use the IntervalMatch function with the transaction date and the HR table to generate point in time data
• Build a star schema around the sales table, and use the Hierarchy function to join the HR data to the model

A company generates l GB of ticketing data daily. The data is stored in multiple tables. Business users need to see trends of tickets processed for the past 2 years. Users very rarely access the transaction- level data for a specific date. Only the past 2 years of data must be loaded, which is 720 GB of data.Which method should a data architect use to meet these requirements?

• Load only 2 years of data in an aggregated app and create a separate transaction app for occasional use
• Load only 2 years of data and use best practices in scripting and visualization to calculate and display aggregated data
• Load only aggregated data for 2 years and use On-Demand App Generation (ODAG) for transaction data
• Load only aggregated data for 2 years and apply filters on a sheet for transaction data

A data architect needs to load large amounts of data from a database that is continuously updated.New records are added, and existing records get updated and deleted.Each record has a LastModified field.All existing records are exported into a QVD file.The data architect wants to load the records into Qlik Sense efficiently. Which steps should the data architect take to meet these requirements?

• 1. Load the existing data from the QVD.
• 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.
• Load all records from the key field from the database and use an INNER JOIN on the previous table.
• 1. Use a partial LOAD to load new and updated data from the database.
• 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.
• Use the PEEK function to remove the deleted rows.
• 1. Load the new and updated data from the database.
• 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.
• 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.
• Load new and updated data from the database. Concatenate with the table loaded from the QVD.
• Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records.