Qlik QSDA2024 : Qlik Sense Data Architect Certification Exam - 2024

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?

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

A company needs to analyze daily sales data from different countries. They also need to measure customer satisfaction of products as reported on a social media website. Thirty (30) reports must be produced with an average of 20,000 rows each. This process is estimated to take about 3 hours.
Which option should the data architect use to build this solution?

• A. Microsoft SQL Server
• B. Mailbox IMAP
• C. Qlik GeoAnalytics
• D. Qlik REST Connector

A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload. When data is updated, a new file is placed into a folder mapped to E:\486396169. The data connection points to this folder.
The data architect plans a script which will:
1. Verify that the file exists
2. If the file exists, upload it Otherwise, skip to the next piece of code.
The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure. Which option should the data architect use to meet these requirements?

• A. FileExists, FOR EACH, IF
• B. FilePath, IF, THEN, Drop
• C. FilePath, FOR EACH, Peek, Drop
• D. FileSize, IF, THEN, END IF

Exhibit.

Refer to the exhibit.
A business analyst informs the data architect that not all analysis types over time show the expected data.
Instead they show very little data, if any.
Which Qlik script function should be used to resolve the issue in the data model?

• A. TimeStamp(OrderDate) AS OrderDate in both the table "Orders" and "Master Calendar"
• B. Date(OrderDate) AS OrderDate in both the table "Orders" and "Master Calendar"
• C. TimeStamp#(OrderDate, 'M/D/YYYY hh.mm.ff') AS OrderDate in both the table "Orders" and "Master Calendar"
• D. DatefFloor(OrderDate)) AS OrderDate in both the table "Orders" and "Master Calendar"

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?

• A. Product Buyer
• B. Vice President of Marketing
• C. SQL Developer
• D. Chief Information Officer