Qlik Sense Data Architect Certification Exam - 2022 - QSDA2022 Exam Practice Test
Question 1
A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.
These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key.
The Human Resources manager creates a table that maps these keys to another, called Associations.
The resultant data model must meet the following requirements:
* Associations must be valid
* The model must be optimized for performance
* The option must support multiple tables added
Which solution should the data architect use to meet these requirements?
These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key.
The Human Resources manager creates a table that maps these keys to another, called Associations.
The resultant data model must meet the following requirements:
* Associations must be valid
* The model must be optimized for performance
* The option must support multiple tables added
Which solution should the data architect use to meet these requirements?
Correct Answer: B
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 2
A data architect is developing an app that will generate QVDs for multiple business analysts. The field naming conventions on the source data are NOT business friendly. For every table loaded, multiple fields will require a name change.
An Excel file is maintained centrally that lists all source data field names and the appropriate names as they should appear in the QVDs Which strategy should the data architect use to meet these requirements?
An Excel file is maintained centrally that lists all source data field names and the appropriate names as they should appear in the QVDs Which strategy should the data architect use to meet these requirements?
Correct Answer: C
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 3
A dataarchitect 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?
What is the minimum number of data connections required?
Correct Answer: C
Question 4
Refer to the exhibit.
Which changes on the database will the script capture?
Which changes on the database will the script capture?
Correct Answer: D
Question 5
A global retailer has a large database in which millions of sales transactions are added per hour.
Each regional sales manager should only see details for customers in their region. After filtering based on criteria such as region, gender,and income level, sales managers should be able to see the most current detailed transactions.
What should a data architect do to meet these requirements?
Each regional sales manager should only see details for customers in their region. After filtering based on criteria such as region, gender,and income level, sales managers should be able to see the most current detailed transactions.
What should a data architect do to meet these requirements?
Correct Answer: D
Question 6
A company needs to analyze sales data based on the exchange rate of the different countries every day About
30 reports must be produced with an average of 20r000 rows each. This process is estimated to take about three hours.
Reports will be in Excel and distributed to business users according to defined security rules Which two products should the data architect use to build this solution? (Select two.)
30 reports must be produced with an average of 20r000 rows each. This process is estimated to take about three hours.
Reports will be in Excel and distributed to business users according to defined security rules Which two products should the data architect use to build this solution? (Select two.)
Correct Answer: A,B
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 7
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.
Whichfeatures should the data architect use to meet these requirements?
A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.
Whichfeatures should the data architect use to meet these requirements?
Correct Answer: A
Question 8
Refer to the exhibit.
A data architect is working with an app and creates some visualizations to check the data. Some visualizations showissues in the data set.
* The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.
* The Sales monthly trend bar chart does not work with the Month field.
Which two data issues should the data architect fix in the app? (Select two.)
A data architect is working with an app and creates some visualizations to check the data. Some visualizations showissues in the data set.
* The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.
* The Sales monthly trend bar chart does not work with the Month field.
Which two data issues should the data architect fix in the app? (Select two.)
Correct Answer: B,D
