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: 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 3: Architecture and Installation | 20% | - Server installation and configuration - Sybase IQ architecture and components - Multiplex setup and configuration - Database creation and initialization |
| Topic 4: 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 5: Performance and Optimization | 20% | - System and session-level options - Index advisor and statistics management - Memory, cache, and resource configuration - Query optimization and execution plans |
Sybase IQ Administrator Professional Certification (Version 15.2) Sample Questions:
Question #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
Correct Answer: A,B 🗳️
Question #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
Correct Answer: A 🗳️
Question #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
Correct Answer: B 🗳️
Question #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
Correct Answer: A,C 🗳️
Question #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.
Correct Answer: A,B,D 🗳️
By Nicholas
