Qlik QSDA2021 Value Pack (Frequently Bought Together)

A data architect of an organization that has implemented Qlik Sense on Windows 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 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. One loop and one SELECT CASE statement
• B. Two loops without any conditional statement
• C. One loop and two IF statements
• D. Two loops and one IF statement

A company has a stream with multiple apps One of the apps is a multi-regional sales app.
A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.
Which features should the data architect use to meet these requirements?

• A. Section access and set analysis
• B. Section access and sheet properties
• C. QMC security rules and custom properties
• D. QMC security rules and section access

Refer to the exhibit.

Refer to the exhibits.
An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.
The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.
How should the data architect modify the data model to correct this issue?

• A. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship
• B. Join the Transactions and Salespeople tables to resolve the many-to-many relationship
• C. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
• D. Join the Departments and Salespeople tables to resolve the many-to-many relationship

Refer to the exhibit.

Refer to the exhibit
A data architect is working on an app that contains orders, invoices, and shipping dat a. There are three different date fields within the data:
* OrderDate
* InvoiceDate
* ShippingDate
The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.
What should the data architect do?

• A. Create a Month field for each of the three dates in the fact table and use that in the chart
• B. Left Join the three date fields onto one bridge table using the key field containing KeyField and Date
• C. Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date