Звезды и С - Главная Тел: +7 495 363 36 86
e-mail: info@stars-s.ru
Москва, Ленинградский пр-кт, д. 5, стр. 2
План проезда


Условия тестирования
Microsoft тесты, экзамены
Microsoft Windows Server 2012
Microsoft Windows Server 2008
MS Windows 2003
MS Windows 7/8
MS Exchange Server
MS SQL Server
MS Internet Services
MS Visual Studio 2008
MS Visual Studio 2010/2012
MS Visual C++ и Visual C#.NET Development
MS Visual Basic 6.0 и VB.NET Development
MS Solutions Framework
MS Internet/Intranet Application Development
MS SharePoint 2010 / 2013
MS System Center
Microsoft Lync Server
Тесты, экзамены других вендоров в Prometric и Pearson VUE

Тест №70-029: Designing and Implementing Databases with Microsoft® SQL Server™ 7.0

Языки теста: English
Online тест:
Кол-во вопросов:
Мин.проходной балл:

Key to the matrix:
The course includes material to prepare you for this task.
¤ The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Skills measured by exam 70-029 Course
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. ¤
Assess the potential impact of the logical design on performance, maintainability, extensibility, scalability, availability, and security. ¤
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 and execute stored procedures to enforce business rules, to modify data in multiple tables, to perform calculations, and to use input and output parameters.
  • Implement error handling by using return codes and the RAISERROR statement.
  • Choose appropriate recompile options.
Create triggers that implement rules, that enforce data integrity, and that perform cascading updates and cascading deletes.
  • Implement transactional error handling.
Create result sets that provide summary data. Query types include TOP n PERCENT and GROUP BY, specifically HAVING, CUBE, and ROLLUP.
Configure session-level settings. ¤
Access data from static or dynamic sources by using remote stored procedures, linked servers, and OPENROWSET.
  • Evaluate where processing occurs when using OPENQUERY.
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.
  • Implement constraints.
Create and maintain indexes.
  • Choose an indexing strategy that will optimize performance.
  • Given a situation, choose the appropriate type of index to create.
  • Choose the column or columns to index.
  • Choose the appropriate index characteristics, specifically FILLFACTOR, DROP_EXISTING, and PAD_INDEX.
Populate the database with data from an external data source. Methods include the bulk copy program and Data Transformation Services (DTS).
Implement full-text search. ¤
Evaluate and optimize the performance of an execution plan by using DBCC SHOWCONTIG, SHOWPLAN_TEXT, SHOWPLAN_ALL, and UPDATE STATISTICS.
Evaluate and optimize the performance of query execution plans. ¤
Diagnose and resolve locking problems. ¤
Identify SQL Server events and performance problems by using SQL Server Profiler.  


   Тел: +74953633686 email: info@stars-s.ru

   125040, Москва, Ленинградский проспект, д. 5, стр. 2, под. 5, офис "Звезды и С"

  © Учебный центр "Звезды и С", 1991-2022, Оферта