Qlik Sense Data Architect Certification - QSDA2019 Exam Questions
QUESTION NO: 1
Refer to the exhibit.
A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name.
Which line number should the data architect use?
Refer to the exhibit.
A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name.
Which line number should the data architect use?
Correct Answer: C
QUESTION NO: 2
Refer to the exhibits.
Executives need to see the total sales by region for the current year. The data architect inherits App1 from a former employee who tried to address this requirement. Two Excel spreadsheets, Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region.
How should the data architect resolve the errors?
Refer to the exhibits.
Executives need to see the total sales by region for the current year. The data architect inherits App1 from a former employee who tried to address this requirement. Two Excel spreadsheets, Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region.
How should the data architect resolve the errors?
Correct Answer: B
QUESTION NO: 3
A data architect executes the following script:
What will Field_1 contain after this script is executed?
A data architect executes the following script:
What will Field_1 contain after this script is executed?
Correct Answer: C
QUESTION NO: 4
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 which maps these keys to one 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 from both systems now and in the future Which function should the data architect use to meet these requirements?
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 which maps these keys to one 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 from both systems now and in the future Which function should the data architect use to meet these requirements?
Correct Answer: D
QUESTION NO: 5
A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze dat a. Some fields must NOT appear in any field list.
How should a data architect meet these requirements?
A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze dat a. Some fields must NOT appear in any field list.
How should a data architect meet these requirements?
Correct Answer: A
QUESTION NO: 6
Refer to the exhibit.
A data architect needs to analyze the number of orders by customer. The data is stored in two Excel files: Orders and Customers The data architect creates a bar chart, but the data is obviously incorrect. What should the data architect do to resolve this issue?
Refer to the exhibit.
A data architect needs to analyze the number of orders by customer. The data is stored in two Excel files: Orders and Customers The data architect creates a bar chart, but the data is obviously incorrect. What should the data architect do to resolve this issue?
Correct Answer: A
