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 |
| Certificate Validity Period: | 2 years |
| Real Exam Qty: | 115–124 |
| Available Languages: | English |
| Exam Format: | Multiple Choice, Multiple Response |
| Exam Price: | USD 150–200 / EUR 129 (varies by region) |
| Related Certifications: | Sybase IQ Administrator Professional Certification 12.6 (510-701) |
| Exam Duration: | 90 minutes |
| Passing Score: | 584 / 1000 |
| 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: Data Loading and Management | 20% | - Transaction control and isolation levels - Bulk load methods and options - Dbspaces, dbfiles, and storage management - Incremental load and data refresh |
| Topic 2: Monitoring, Security, and Recovery | 15% | - Monitoring stored procedures and utilities - User management, roles, and permissions - Troubleshooting and common issues - Backup, restore, and recovery procedures |
| Topic 3: Database Objects and Indexing | 25% | - Index types: HG, LF, FP, HNG, CMP, TEXT - Tables, views, constraints, and data types - Index selection, creation, and maintenance - Schema design best practices |
| Topic 4: Performance and Optimization | 20% | - System and session-level options - Index advisor and statistics management - Memory, cache, and resource configuration - Query optimization and execution plans |
| Topic 5: Architecture and Installation | 20% | - Server installation and configuration - Sybase IQ architecture and components - Multiplex setup and configuration - Database creation and initialization |
Sybase IQ Administrator Professional Certification (Version 15.2) Sample Questions:
1. How can you start a Sybase IQ server? (Choose 2)
A) Start server from Sybase Central
B) Use thestart_iq utility on command line
C) Use thestartserver command on command line
D) Use thestart_asiq utility on command line
2. Based on this report, how much memory (in MB) is this Sybase IQ server using?
A) 922 MB
B) 900 MB
C) 250 MB
D) 923 MB
E) 1292 MB
3. Which mode of sp_iqcheckdb should be used to see if the values in the FP index are consistent with the values in the other indexes?
A) DROPLEAKS
B) CHECK
C) VERIFY
D) ALLOCATION
4. Which of these actions will help keep table versioning to a minimum? (Choose 2)
A) Enable a database event to disconnect users who have not issued any command after a set period of time
B) Set the database optionPublic.Force_No_Scroll_Cursors = N
C) Configure ODBC database connections to issue commits immediately before or after queries
D) Revoke Resource Authority from all users except the DBA
E) Revoke DBA Authority from all users except the DBA
5. Which is TRUE about table partitioning? (Choose 3)
A) Partition key must exist and cannot be NULL.
B) Partition column may not be changed.
C) Partition columns can be any data type.
D) All existing data must lie within the first declared partition range.
E) Sybase IQ supports up to a maximum of 2048 partitions for range partitioning.
Solutions:
| Question # 1 Answer: A,B | Question # 2 Answer: A | Question # 3 Answer: B | Question # 4 Answer: A,C | Question # 5 Answer: A,B,D |
By Malcolm
