We're so confident of our products that we provide no hassle product exchange.
Qlik QSDA2018 Exam Overview:
| Certification Vendor: | Qlik |
|---|---|
| Exam Name: | Qlik Sense Data Architect Certification Exam - June 2018 Release |
| Exam Number: | QSDA2018 |
| Exam Duration: | 60 minutes |
| Exam Format: | Multiple Response, Multiple Choice |
| Related Certifications: | Qlik Sense System Administrator Certification Qlik Sense Business Analyst Certification |
| Certificate Validity Period: | 2 years |
| Real Exam Qty: | 60 (approx.) |
| Passing Score: | 70% |
| Exam Price: | 250 USD (approx.) |
| Available Languages: | English |
| Recommended Training: | Qlik Sense Data Architect Training |
| Exam Registration: | Qlik Certification Registration |
| Sample Questions: | Qlik QSDA2018 Sample Questions |
| Exam Way: | Online proctored or authorized test center (Pearson VUE) |
| Pre Condition: | Recommended: experience with Qlik Sense data loading script and data modeling concepts |
| Official Syllabus URL: | https://www.qlik.com/us/services/training/certification |
Qlik QSDA2018 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Data Connections | - Data source authentication - Connecting to databases and files |
| Data Modeling | - Star and snowflake schema design - Associations and synthetic keys - Conceptual and logical data models |
| Data Loading and Transformation | - Incremental load strategies - Data transformation functions - Qlik load script fundamentals |
| Application Design | - Data layer vs presentation layer separation - Performance optimization considerations |
| Data Quality and Governance | - Handling nulls and duplicates - Data validation techniques |
Qlik Sense Data Architect Certification Exam - June 2018 Release Sample Questions:
Refer to the exhibits.
A data architect needs to build a Project Management dashboard. The ProjectStatus table lists all indexes in the fields. Descriptions for the indexes are stored in a single Master table.
To build the dashboard, all descriptions should be in a single table:
Which function should the data architect use to meet this requirement?
- A. ApplyMap
- B. Join
- C. Keep
- D. PurgeChar
Refer to the exhibit.
The data architect is using section access to meet the security requirements of an app After the first draft, the data architect discovers that users can NOT see the right subset of data Which solution should a data architect use to fix this issue?
- A. Capitalize only field values
- B. Associate the Section Access table with the data model
- C. Name the field for data reduced as SectionAccess'
- D. Capitalize field names and values
Refer to the exhibit.
A data architect needs to build a sales dashboard. Data is stored in a legacy database. The extracted data contains the date in the format, 'YYYYDDMM' Due to the source date format, the dates are being loaded as numbers.
Which function should the data architect use to fix this issue?
- A. Timestamp
- B. Date
- C. Timestamp#
- D. Date#
Refer to the exhibit.
How should the account that runs the Qlik Sense Services be configured in the Section Access table?
- A. ADMIN, DOMAIN\QLIK_SERVICES, *
- B. ADMIN, QLIK_SERVICES, *
- C. ADMIN, DOMAIN\QLIK_SERVICES.
- D. ADMIN, QUK_SERVICES,
Refer to the exhibit.
A data architect has two tables that contain Sales and Target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeelD.
The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for Target are too high, and employees with NO sales should be excluded Which function should the data architecwise to resolve these issues?
- A. Outer Join
- B. Left Keep
- C. Left Join
- D. Inner Join
By Linda
