• DBA Exam

  • DBA Exam–Available mid-July!

    Exam Details

    Teradata Database Release Number

    16.10

    Purpose of the Exam

    A successful candidate has core knowledge and skills necessary to; manage archives, plan capacity requirements, identify optimal database and table design including indexing options, use database tools and utilities, manage performance and usage data, produce security auditing reports, monitor and manage database space, administer users, manage system logging options, manage database privileges, and identify relevant workload management components.

    Credentials Earned

    Prerequisites and Recommended Experience

    Prerequisite

    Minimum of 1 to 3 years hands-on experience with Teradata Database and applications is recommended.

    Recertification Requirements

    The Teradata Database Certified DBA Certification has a three-year expiration date. Maintain this certification by either passing the DBA Exam or earning the Teradata Database Certified Advanced DBA Certification prior to the expiration date.

    Earning the Teradata Database Certified DBA Certification extends the expiration date of the earned Teradata Database Certified Associate Certification.

    Exam Duration

    To be announced at a later date*

    * The exam duration shown is the amount of time allowed for answering exam questions. The test delivery provider may add time to your total appointment to provide the opportunity to get seated, read the Non-Disclosure Agreement (NDA), complete the tutorial, and participate in a survey.

    Language

    English

    Cost

    The cost of Teradata exams varies by exam, location and currency. Please visit www.pearsonvue.com/teradata to find the price of an exam.

    Bulk discount vouchers for 10 or more exams testing, can be purchased through Pearson VUE.

    Teradata employees should visit the TCPP Connections Group to obtain an employee discount voucher. (You must be behind the Teradata firewall to access this page)

    How to Register

    Registration will open in early July. 

    Online at www.pearsonvue.com/teradata.  Select:  TDBL2-16.10 DBA Exam.

    For a list of regional phone numbers visit www.pearsonvue.com/teradata/contact/

    Retake Policy

    A failed exam may be retaken after a twenty-one calendar day waiting period. The twenty-one day waiting period begins from the date of the failed exam attempt.

    You will be required to schedule a new appointment and pay for the exam.

    Candidates may attempt an exam a maximum of three times during a six month period.

    DBA Exam Objectives and Section Weightings

    The exam objectives and section weightings describe the content and focus covered on the exam.

    Archive Management — 7%

    • Identify the considerations that should be evaluated when scheduling an archive through Backup and Recovery (BAR) management.
    • Given a scenario including a type of archive error, troubleshoot the error.
    • Identify the features and functionality available with archive facilities (for example: DSA, DSU, and BAR.)
    • Given a scenario, identify the optimal restore strategy for a database object or system.

    Capacity Planning — 8%

    • Identify the source of disk space data for capacity planning and the limitation of the data.
    • Identify the source of system CPU and system I/O data for capacity planning.
    • Identify the source of AWT usage data for capacity planning.
    • Identify the source of session data for capacity planning.

    Database Design and Indexing — 9%

    • Identify the features and functionality of row and/or column partitioning. 
    • Identify the features and functionality of temporal offerings (for example: Teradata and ANSI.)
    • Given a scenario, identify the proper indexing strategy for a table.
    • Identify the types and effectiveness of various compression options.
    • Identify the key concepts and implications of various modeling techniques (dimensional modeling, data vault, object oriented, standard entity-relation (ER).)

    Database Tools and Utilities — 8%

    • Given a scenario, identify the optimal tool or utility to remediate a problem or accomplish a task (for example: Visual Explain and Compare, Teradata Workload Analyzer, and TSET.)
    • Identify the features, implementation options, and benefits of using Data Labs.
    • Identify the features and functionality of the Teradata Studio Suite (for example: Studio and Studio Express.)
    • Given a scenario, identify the Viewpoint portlet that should be used to investigate or remediate a system condition.

    Performance Management — 14%

    • Identify options, features, and functionality of statistics collection.
    • Given a scenario, identify the optimal DBQL logging options that should be implemented.
    • Given a scenario identify the columns to use to produce a required report or analysis (for example: default/log table, objects, SQL, Step, Explain, Utility, Parameter, Summary).
    • Identify the features, functionality, and setup of ResUsage collection and logging.
    • Identify locking levels and their effects (for example: row, table, database, and partition.)
    • Identify lock types, their usage and implications (for example: access, write, read, exclusive, and load isolation.)
    • Identify methods to find sub-optimal queries.

    Security Management and Auditing — 10%

    • Identify features, functionality and benefits of access logging.
    • Identify features, functionality and benefits of the logonoff view.

    Space Management — 8%

    • Identify the methods and processes to manage and monitor perm space.
    • Identify the methods and processes to manage and monitor temp space.
    • Identify the methods and processes to manage and monitor spool space.
    • Identify the rationale for reserving a percentage of permspace for spool usage.

    User Administration — 11%

    • Given a scenario, identify how to meet user security requirements using roles.
    • Identify the limitations of using roles.
    • Identify the benefits to assigning privileges to roles vs user.
    • Identify the features, functionality, and benefits of profiles.
    • Given a scenario, identify when changes to profiles affect users.
    • Identify situations when a user needs to be removed from a profile.
    • Identify the purpose, functionality and components of account strings.
    • Given a scenario, identify the attributes that should be set for a new user.

    Database Management — 12%

    • Given a scenario, identify the access rights that should be granted to a database, table or view.
    • Identify the benefits, types, and reasons for logging.
    • Given a scenario, identify types of privileges that would be granted (for example: explicit, implicit, automatic and inherited privileges).
    • Identify the considerations of using database and object level privileges.
    • Given a scenario, identify the metrics that should be used to investigate a performance issue.
    • Given a scenario, identify the system performance indicators that should have alerts.
    • Identify the effects on a user session of changing a DBS control parameter.
    • Identify the benefits, features, and functionality of QueryGrid.
    • Given a scenario, identify the optimal load strategy (for example: mini-batch, TPT LOAD/ UPDATE, TPT STREAM, etc,).

    Workload Management — 13%

    • Given a scenario, identify the TIWM workload management component(s) that should be used.
    • Given a scenario, identify the TASM workload management component(s) that should be used.

    Click for the Printable Exam Objectives.

    Recommended Courses

    The Teradata Certified Professional Program partners with the Teradata Education Network to provide Teradata courseware and curriculum that specifically relate to each exam. You can view course descriptions and schedules, and enroll online.

    Courses to be announced later.

    Teradata Employees only: visit the Teradata internal TCPP Connections site for more information on recommended Teradata training. (You must be logged in to the Teradata network).

    Sample Questions 

    Coming soon!