|
| |
FREQUENTLY ASKED QUESTIONS:
ANSWER: In the USA or Canada, please call Prometric to register by phone 800-792-EXAM or online at: https://www.2test.com.
If you are from a country other than the US or Canada, follow your normal registration procedures through your local exam center or your Prometric Regional Service Center. To find out about registration procedures for your region (select 'Sybase' from the 'Client/Program' drop-down box.)
ANSWER: It is recommended you work with PowerDesigner 12.1* for at least 12 months before taking the exam. If you have taken a corresponding course, it is suggested you review all of the content, especially topics that you have yet to master.
*This exam is based on the PowerDesigner 12.1 GA version. Any functionality that is new or changed in later releases are not included in this exam.
We also recommend preparing by:
- Spending a minimum of 40 hours thoroughly covering all topics listed in the exam study guide
Taking the following recommended courses:
- Logical Database Design (SYB144)
- Physical Database Design (EDB110)
- Data Modeling with PowerDesigner 12 (DEV326)
ANSWER: Each candidate will have one hour and thirty minutes to complete the exam which consists of 60 multiple-choice questions. The passing grade is 70% (42 questions answered correctly).
ANSWER: Space your time accordingly and do not spend too much time on each question. When answering a question, you'll have the opportunity to mark an answer "for review". Keep this in mind, as it will allow you to revisit your marked questions later, before finally submitting your exam.
|
|
| |
STUDY GUIDELINES
Section 1 - General Data Modeling with PowerDesigner (12 questions - 20%)
- PowerDesigner Modeling Environment
- Define a Workspace in PowerDesigner
- Core Working Areas in the PowerDesigner Interface: Toolbars, Browser Tree View, Diagram Window, Output
- Window, Result List, Tool Palette, etc.
- PowerDesigner Preferences and Options: General Options
- Compare Models and using the Comparison Window
- Use the Merge Window
- Move Objects from one Package to Another During Merge
- Manually Synchronize Objects
- Model Management
- Model templates
- Saving models
- Object Management
- Working with Property Sheets
- Working with Object Lists
- Impact Analysis
- Changing/setting default impact analysis propagation rules
- Navigating the report, manually expanding by adding propagations ad-hoc
- Naming Conventions and Conversion Tables
Section 2 - Conceptual Data Model (12 questions - 20%)
- Conceptual Data Model Overview
- Conceptual Data Model Creation:
- Create New
- From CDM
- From PDM
- CDM Model Options/Display Preferences
- CDM Model Properties
- Define Entities & Attributes
- Attributes
- Identifiers
- Requirements
- Normalization Theory
- Derive Business Rules
- Store the Business Rules
- Look for Business Rules
- Create Data Items
- Forms of Data Item Reuse/Duplicate
- Controlling Reuse Rules/Standards through Options
- Conceptual Data Types
- Numeric Data Types
- Character Data Types
- Time Data Types
- Serial Data Types
- Define Domains
- Managing Domain synchronization rules
- Define Relationships
- Role
- Cardinality
- Mandatory Existence
- Dependency
- One-to-many
- Recursive Relationships
- Many-to-many
- One-to-one
- Convert to Entity Wizard – purpose and technique
- Define Inheritance Links
- Generalizing and Specifying Attributes
- Using the Inheritance Property Sheet
- Check Conceptual Data Models
Section 3 - Physical Data Model (12 questions - 20%)
- Physical Data Model Overview
- Create PDM
- Create New
- Generate a PDM from a PDM (logical model)
- Generate a PDM from a CDM
- Object naming options (detail tab)
- PDM Model options
- Transformations
- Select Model Objects for Generation
- PDM Model Options/Display Preferences
- Generation from CDM objects into PDM objects
- Entities into PDM Tables
- Relationships into PDM References
- Inheritance Links into PDM Tables
- Identifiers into Keys
- Modify CDMs and PDMs
- Update an Existing PDM from a CDM
- Preserve Modifications
- Data Integrity and Consistency Data Integrity Constraints
- Generate a Check Constraint Using a Validation-type
- Denormalization Wizards use and techniques
- Preserving Modifications with use of a Denormalization – how does that work…
- Define Referential Integrity
- Create a View for Tables Selected in the PDM
- Indexes:
- Create and Delete Indexes
- Designate an Alternate Key
- Link to Requirements
- Generate the Database or Database Creation Script
- DBMS Definition Editor
- Database Generation
- Generating a Database Using ODBC
- Object Selection
- Synchronize from a PDM to an Existing Database
- By Script
- By ODBC
- By Archive
- By Repository Version
- Synchronize from a Database to an Existing PDM
- Default Physical options - Generic
- Defaults
- Sequences, Identity, Auto-increment, etc… columns
- Storages
- Test Data Generation
- Test data profiles
- Column fill parameters
- Change Target DBMS
- Business Rules
- Check Model
Section 4- Creating Triggers, Stored Procedures, and Functions (2 questions – 3%)
- Advantages of triggers, stored procedures and functions
- Create Triggers, Stored Procedures, and Functions
- Working with Macros and Variables
- Macro Language Basics
- Use of Business Rules Macros in trigger Definitions
- Templates:
- Use Templates to Define Stored Procedures and Functions
- Define Customized Templates
- Modify Trigger Templates and Items
- Create Triggers Automatically
- Generate Trigger SQL Script - Generation Parameters and Options
Section 5- Reverse Engineering with PowerDesigner (3 questions – 5%)
- Reverse Engineering a PDM from a Database Creation Script
- Reverse Engineering a PDM from a Database Catalog using ODBC
- Reverse Engineering a CDM from a PDM
- Options Tab
- Target Models
Section 6- Packages and Diagrams (4 questions – 7 %)
- Define Models, Diagrams, and Packages
- Decompose a Large Model
- Create Diagrams
- Format Objects/ Sub-objects
- Work with and Manage Packages
- Convert a Diagram to a Package
- Work with Objects in Models and Packages
- Define the differences between packages and Diagrams
- Work with Shortcuts
- Delete Objects from Models and Packages
- Work with Object Replications
- Define the Differences between Shortcuts and Replicas
- Graphical Synonyms
- Printing Diagrams
Section 7- The PowerDesigner Repository (4 questions – 7%)
- Introduction to the Repository
- Set Up the PowerDesigner Repository
- repository definition
- general errors
- use of a proxy
- Repository User Interface
- Repository General Options
- Connect to the Repository
- Administer Repository Users & User/Group Rights
- Identify User Rights
- Identify Permission Levels
- Understanding the behavior of nested rights/permissions through groups and folders
- Consolidate Documents in the Repository
- Extract Documents from the Repository
- Version Configuration Management
- Versioning Repository Documents
- Consolidate and/or Extract a Document Version
- Managing Repository Branches
- Other Repository Features
- Repository Proxy
- Repository Access Permission
- Branch Management
- Merge vs. Consolidate
Section 8- Customizing the PowerDesigner API – Customization and Extension (3 questions - 5%)
- The PowerDesigner MetaModel - attributes, collections, methods, etc
- The Ways to Access PowerDesigner via API - Theoretical level – external access capabilities, scriptable
- features and objects, languages to use and how (via COM only, etc…)
- The embedded VBScript environment – using the customization on Menus
- Extended Model Definitions
- Profiles
- Stereotypes
- Extended Attributes
- Forms
- Custom Checks (theory more than VBScripting of the code…)
- Resource Editor
- Transformation Profile
Note: This exam does not cover VBScript. A PowerDesigner Professional should have some theoretical knowledge about the capability for extending the environment. You should know enough as a Data Modeler to give a VBScript developer the framework from PowerDesigner so between the two of you, an effective extension can be built.
Section 9- REPORTING (6 questions – 10%)
- Report Templates
- List reports
- Report Options
- HTML/RTF reports
- Multi-Model reports
- Report Object Selection
- Reporting on Packages
- Report Languages
- Report Wizard
Section 10- Data Warehousing (2 questions – 3 %)
- Using the Mapping Editor
- Data sources
- Facts
- Dimensions
- Cubes
- Multi -dimensional diagram
- Measures
- Hierarchies
- Extraction scripts
|
