We're so confident of our products that we provide no hassle product exchange.
QlikView QV12DA Exam Overview:
| Certification Vendor: | Qlik |
| Exam Name: | QlikView 12 Data Architect Certification Exam |
| Exam Number: | QV12DA |
| Real Exam Qty: | 50 |
| Related Certifications: | QlikView 12 Developer (QV12DE) Qlik Sense Data Architect (QSDA2018) Qlik Sense Business Analyst (QSBA2018) |
| Certificate Validity Period: | 2 years |
| Exam Format: | Multiple Choice, Multiple Response, Scenario-based |
| Exam Price: | $250 USD |
| Exam Duration: | 120 minutes |
| Passing Score: | 70% |
| Available Languages: | English |
| Sample Questions: | QlikView QV12DA Sample Questions |
| Exam Way: | Online proctored exam or at Pearson VUE testing center |
| Pre Condition: | Recommended: 6-12 months hands-on experience with QlikView 12 and completion of QlikView Data Architect training course |
| Official Syllabus URL: | https://www.qlik.com/services/training/certification |
QlikView QV12DA Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Data Architecture and Design | 20-25% | - Circular references and solutions - Balance between data model complexity and performance - Understanding dimensional data models - Link tables and concatenated tables - Star schema and snowflake schema design |
| Topic 2: Security and Governance | 15-20% | - Data reduction techniques - Section Access implementation - Security best practices - Field-level and row-level security |
| Topic 3: Performance Optimization | 15-20% | - Data model optimization techniques - Join types and their impact - Synthetic keys identification and resolution - Table viewer analysis - Memory management |
| Topic 4: Data Load Design | 20-25% | - RESIDENT loads and preceding loads - QVD files creation and optimization - Incremental load strategies - LOAD statements and transformations - Scripting fundamentals - Handling different data sources |
| Topic 5: Data Transformation | 20-25% | - Data cleansing techniques - Interval matching - Cross-tables and pivot tables - Mapping tables and ApplyMap - Data quality and validation |
QlikView 12 Data Architect Certification Sample Questions:
1. A system administrator finds this error message in the event log file
500 Warning WorkingSet: Virtual Memory is growing beyond parameters - 22.761(22.393) GB Which is the cause of the error?
A) QlikView Server memory is above the Cache limit for the Working Set
B) QlikView Server memory is above the High limit for the Working Set
C) QlikView Server memory is below the Low limit for the Working Set
D) QlikView Server memory is above the Low limit for the Working Set
2. A system administrator upgrades to QlikView 12. Tasks no longer start or trigger. The administrator uses Windows Task Manager to look at the environment and notices the overall CPU usage is above 75%.
Which QVDistributionService.exe.config setting should be changed to allow tasks to start?
A) Adjust the QvbWaitTimeoutMinutes value from the default value of 45 to 85
B) Adjust the FileSizelnMbToCheckForFullDisc value from the default value of 20 to 85
C) Adjust the CpuOverLoadLimit value from the default value of 75 to 85
D) Adjust the MemoryOverloadLimit value from the default value of 90 to 85
3. A system administrator needs to configure IIS to allow any user to access QlikView content What should the administrator do?
A) Change the QlikView IIS application pool identity to the local administrator
B) Disable Anonymous Authentication on the QlikView virtual paths
C) Disable Anonymous Authentication and enable Windows Authentication on the QlikView virtual paths
D) Enable Anonymous Authentication and disable Windows Authentication on the QlikView virtual paths
4. A company has a QlikView developer that needs to license QlikView Personal Edition Which CAL type should a system administrator assign to the developer?
A) Usage CAL
B) Document CAL
C) Named User CAL
D) Session CAL
5. A QlikView document contains Section Access and reduces the data to the users based on usernames When opening the documents all users are still able to see all data without any reductions.
Which QlikView Desktop setting is causing this result?
A) Initial Selection Based on Section Access is unchecked
B) Initial Data Reduction Based on Section Access is unchecked
C) Initial Selection Based on Section Access is checked
D) Strict Exclusion is unchecked
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: C | Question # 3 Answer: C | Question # 4 Answer: C | Question # 5 Answer: D |
By Dorothy
