Online Access Free QSDA2024 Practice Test

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?

• A.Use the REST Connector with pagination mechanism
• B.Recreate the SQL Statement with the correct parameters
• C.Use With Connection to pass a parameter to the REST URL
• D.Use pagination of the REST Connector to create a template of the desired 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?

• A.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.
• 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. 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.

A data architect needs to load Table_A from an Excel file and sort the data by Reld_2.
Which script should the data architect use?

• A.
• B.
• C.
• D.

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

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

Refer to the exhibit.
A data architect needs to create a data model for a new app. Users must be able to see:
* Total sales for each customer
* Total sales for a given state
* Customers that have not had any sales
* Names of salesperson and regional account managers
* Total number of sales by date
Which steps should the data architect perform to meet these requirements?
Which steps should the data architect perform to meet these requirements?

• A.1. Use a Mapping Load for the Employees table
  2. Load the Sales table and use ApplyMap to get the names for SalesPersonID and RegionalAcctMgrlD
  3. Use a Left Join Load to add the customer details for the Sales table
• B.1. Load the Customers table and alias the CustID field as CustomerlD
  2. Load the Employees table
  3. Load the Sales table and alias the SalesPersonID and RegionalAcctMgrlD fields as EmployeelD
• C.1. Load the Sales table
  2. Load the Customers table
  3. Load the Employees table twice; name it and alias the EmployeelD field appropriately each time
• D.1. Load the Customers table and alias the CustID field as CustomerlD
  2. Use a Mapping Load for the Employees table
  3. Load the Sales table and use ApplyMap to get the names for SalesPersonID and RegionalAcctMgrlD