We're so confident of our products that we provide no hassle product exchange.
Qlik Sense Data Architect Certification Exam - June 2018 Release Sample Questions:
1. Refer to the exhibit.
The Country field in a CRM app is a free-form text field. More spelling variations and countries are expected in the future. A data architect must create a field called CountryCode based on the value in the Country field Which script should the data architect create to perform this task?
A)
B)
C)
D)
A) Option D
B) Option C
C) Option B
D) Option A
2. Refer lo the exhibit.
A data architect loads order data for a global sales organization. The Order Details contains 100 million rows.
The data architect must load only the data for the North America division Which WHERE clause should the data architect use in the Order Details LOAD script?
A) WHERE Division = 'North America';
B) WHERE OrderNum = [Order Header].[OrderNum";
C) WHERE Exists('North America');
D) WHERE Exists{OrderNum);
3. Refer to the exhibits
Which corrective action should be taken to achieve the expected view?
A) Add a link table.
B) Alias one of the fields in the Orders table.
C) Use upper () to align the Salesperson fields
D) Use distinct in the LOAD statement.
4. Sales managers need to see an overview of historical performance and highlight the current year's metrics App requirements:
* Display the current year's total sales
* Total sales displayed must respond to the user's selections
Which variables should a data architect create to meet these requirements?
A)
B)
C)
D)
A) Option D
B) Option C
C) Option B
D) Option A
5. Two companies have merged and a full database integration is planned for next year. The data architect needs an interim solution to view all employee data from both companies
* The tables come from different systems
* Both companies have similar Employees tables
* Both tables have identifiers for Employee and some other attributes (eg , geographical information)
* The tables also have some fields that do NOT match (e.g.: Social Security Number and Bank Account) Which problem occurs when the two tables are loaded into Qlik Sense?
A) A circular reference occurs
B) Synthetic keys are created
C) Link tables are created
D) An auto concatenation occurs
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: D | Question # 3 Answer: B | Question # 4 Answer: D | Question # 5 Answer: B |
By Gustave
