We're so confident of our products that we provide no hassle product exchange.
Sybase 510-702 Exam Overview:
| Certification Vendor: | Sybase (acquired by SAP) |
| Exam Name: | Sybase IQ Administrator Professional Certification (Version 15.2) |
| Exam Number: | 510-702 |
| Exam Duration: | 90 minutes |
| Related Certifications: | Sybase IQ Administrator Professional Certification 12.6 (510-701) |
| Real Exam Qty: | 115–124 |
| Passing Score: | 584 / 1000 |
| Certificate Validity Period: | 2 years |
| Exam Format: | Multiple Choice, Multiple Response |
| Available Languages: | English |
| Exam Price: | USD 150–200 / EUR 129 (varies by region) |
| Recommended Training: | Sybase IQ 15.2 Administration Training |
| Exam Registration: | Pearson VUE |
| Sample Questions: | Sybase 510-702 Sample Questions |
| Exam Way: | Proctored online or at authorized testing centers |
| Pre Condition: | No mandatory prerequisites; recommended: 6+ months of Sybase IQ administration experience |
| Official Syllabus URL: | https://infocenter.sybase.com/help/ |
Sybase 510-702 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Database Objects and Indexing | 25% | - Tables, views, constraints, and data types - Schema design best practices - Index types: HG, LF, FP, HNG, CMP, TEXT - Index selection, creation, and maintenance |
| Topic 2: Data Loading and Management | 20% | - Incremental load and data refresh - Transaction control and isolation levels - Dbspaces, dbfiles, and storage management - Bulk load methods and options |
| Topic 3: Architecture and Installation | 20% | - Database creation and initialization - Server installation and configuration - Multiplex setup and configuration - Sybase IQ architecture and components |
| Topic 4: Monitoring, Security, and Recovery | 15% | - Monitoring stored procedures and utilities - Backup, restore, and recovery procedures - User management, roles, and permissions - Troubleshooting and common issues |
| Topic 5: Performance and Optimization | 20% | - System and session-level options - Query optimization and execution plans - Index advisor and statistics management - Memory, cache, and resource configuration |
Sybase IQ Administrator Professional Certification (Version 15.2) Sample Questions:
1. Given a VARCHAR field of 100 bytes, how much space is needed to store the data in a Flat FP prior to compression?
A) 101 bytes
B) Varies based on the amount in use
C) 1 bit per distinct value
D) 100 bytes
2. Which index type is recommended for better performance on columns used in table joins?
A) LF
B) HNG
C) HG
D) DTTM
3. Which of the following need to be in place before a full database Restore can be done? (Choose 2)
A) IQ Catalog Store and Transaction Log must be recreated as empty files.
B) IQ Catalog Store and Transaction Log must exist.
C) Must have a DBA connection to a running server.
D) IQ Catalog Store and Transaction Log must not exist.
4. Which utility program is capable of listing Sybase IQ servers running on the network?
A) dblog
B) dbvalid
C) stop_iq
D) dblocate
E) start_iq
5. When you cannot write to a locked table, which of the following stored procedures can be used to identify possible causes? (Choose 2)
A) sp_iqstatus
B) sp_iqcontext
C) sp_iqconnection
D) sp_iqlocks
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: C | Question # 3 Answer: C,D | Question # 4 Answer: D | Question # 5 Answer: B,D |
By Murphy
