Microsoft Exams, exam 70-029, Designing and Implementing Databases with Microsoft SQL Server 7.0.
Exam topics include Developing a Logical Data Model, Physical Design, Data Services, Creating a Physical Database, and Maintaining a Database.
Exam #: 70-029
Time Limit: 150 min.
Avg. Time: 80 min.
Passing Score: 693
# of Questions: 49
Format: Adaptive with Simulations
Certifications: MCP, MCSE, MCSE+I, MCSD, MCDBA
Microsoft Braindumps, Oracle Braindumps, Sun Braindumps, Cisco Braindumps,
Citrix Braindumps, CIW Braindumps, Comptia Braindumps, Novell Braindumps
Skills measured by exam 70-029 Course 833
Developing a Logical Data Model
Group data into entities by applying normalization rules.
Identify primary keys.
Choose the foreign key that will enforce a relationship between entities and that will ensure referential integrity.
Identify the business rules that relate to data integrity.
Incorporate business rules and constraints into the data model.
In a given situation, decide whether denormalization is appropriate.
Deriving the Physical Design
Assess the potential impact of the logical design on performance, maintainability, extensibility, scalability, availability, and security.
Creating Data Services
Access data by using the dynamic SQL model.
Access data by using the stored procedure model.
Manipulate data by using Transact-SQL cursors.
Choose the appropriate type of cursor.
Define the appropriate level of sensitivity to change.
Choose the appropriate navigation.
Choose the scope of the cursor, specifically global or local.
Create and manage explicit, implicit, and distributed transactions to ensure data consistency and recoverability.
Define the transaction isolation level.
Design transactions of appropriate length.
Avoid or handle deadlocks.
Use optimistic locking appropriately.
Implement error handling by using @@trancount.
Write INSERT, DELETE, UPDATE, and SELECT statements that retrieve and modify data.
Write Transact-SQL statements that use joins or subqueries to combine data from multiple tables.
Create scripts by using Transact-SQL. Programming elements include control-of-flow techniques, local and global variables, functions, and error handling techniques.
Design, create, use, and alter views.
Modify data through a view.
Query data through a view.
Create triggers that implement rules, that enforce data integrity, and that perform cascading updates and cascading deletes.
Implement transactional error handling.
Creating a Physical Database
Create and manage files, filegroups, and transaction logs that define a database.
Create tables that enforce data integrity and referential integrity.
Choose the appropriate data types.
Create user-defined data types.
Define columns as NULL or NOT NULL.
Define columns to generate values by using the IDENTITY property, the uniqueidentifier data type, and the NEWID function.