MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

1. 

What are the key SMO assemblies that need to be referenced in an SMO application?

2. 

How do you connect to a server using logon credentials?

3. 

What namespace is used by RMO to create an application that works with replication objects?

4. 

What function must be performed regardless of the type of replication you are using?

5. 

What are the main objects that can be used in an AMO application?

6. 

In an AMO application, what four objects are used to connect to a database?

7. 

What assembly enables you to connect to a client using ADOMD.NET?

Answers

1. 

For most SMO applications, you will need to reference the following assemblies:

  • Microsoft.SqlServer.Smo

  • Microsoft.SqlServer.SmoEnum

  • Microsoft.SqlServer.SqlEnum

  • Microsoft.SqlServer.ConnectionInfo

2. 

To connect to a server using logon credentials, you will need to set a reference to the Microsoft.SqlServer.ConnectionInfo assembly and a directive to the Microsoft.SqlServer.Management.Common namespace. You then specify the logon credentials using the ServerConnection object.

3. 

Even though there are two assemblies used in RMO applications, Microsoft.SqlServer.Replication and Microsoft.SqlServer.Rmo, there is only one namespace directive that you need to add to your code: Microsoft.SqlServer.Replication.

4. 

Regardless of what type of replication you are performing, you need to specify a publisher and a distributor. You also need to specify the publisher and distributor databases.

5. 

The main objects in an AMO application are Cube, Dimension, and MiningStructure. You will need to use the Server and Database objects to get to these objects.

6. 

To connect to a database with an AMO application, you need the Server and Database objects mentioned in the previous answer. You will also need DataSource and DataSourceView objects.

7. 

To connect to a client using ADOMD.NET, you will set a reference to the Microsoft.SqlServer.AdomdClient assembly. For server-based applications, you will use the Microsoft.SqlServer.AdomdServer assembly.

Related

Категории