Qlik Sense Data Architect Certification Exam - 2022 (QSDA2022) Free Practice Test
Question 1
The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.
Which method should the data architect use to manage the modifications in all apps?
Which method should the data architect use to manage the modifications in all apps?
Correct Answer: D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 2
A data architect is creating an app using three tables. After executing thescript, a warning displays Which two steps should the data architect do to resolve this warning? (Select two.)
Correct Answer: C
Question 3
Refer to the exhibit.
A customer needs to load forecast data from an Excel file.
Which preceding load statement should the data architect use to load the data?
A customer needs to load forecast data from an Excel file.
Which preceding load statement should the data architect use to load the data?
Correct Answer: D
Question 4
A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects What should the data architect do?
Correct Answer: B
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 5
Refer to the exhibit.
A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam.
The data architect selects the field "StudentID" from the Students table and sees the following:
A data architect needs to fix this anomaly.
What should the data architect do to ensure data integrity?
A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam.
The data architect selects the field "StudentID" from the Students table and sees the following:
A data architect needs to fix this anomaly.
What should the data architect do to ensure data integrity?
Correct Answer: D
Question 6
Refer to the exhibit.
The data architect needs to build a model that contains Sales and Budget data for each customer.
Some customers have Sales without a Budget, and other customers have a Budget with no Sales During loading, the data architect resolves a synthetic key by creating the composite key For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.
What does the data architect see when selecting a month?
The data architect needs to build a model that contains Sales and Budget data for each customer.
Some customers have Sales without a Budget, and other customers have a Budget with no Sales During loading, the data architect resolves a synthetic key by creating the composite key For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.
What does the data architect see when selecting a month?
Correct Answer: A
Question 7
A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies
* Source 1 Contains frequently updated data and must be refreshed hourly
* Source 2 Contains data that is transferred from a partner and must be refreshed weekly Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs Which tasks should be created to meet these requirements'?
* Source 1 Contains frequently updated data and must be refreshed hourly
* Source 2 Contains data that is transferred from a partner and must be refreshed weekly Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs Which tasks should be created to meet these requirements'?
Correct Answer: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 8
Refer to the exhibit.
Refer to the exhibits.
While using an app, the users report that some Sales Reps do NOT have personal details, like Division or Address Number A data architect has been called in to investigate.
The data architect uses the data model viewer to determine the relationship between the SalesRepMaster and CustomerMaster tables.
What is the cause of the issue?
Refer to the exhibits.
While using an app, the users report that some Sales Reps do NOT have personal details, like Division or Address Number A data architect has been called in to investigate.
The data architect uses the data model viewer to determine the relationship between the SalesRepMaster and CustomerMaster tables.
What is the cause of the issue?
Correct Answer: D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).