Da Notes - 70-019 - A

Personal notes on the MCDBA tests. These notes are from the various resources I used to pass the MCDBA exams including the MCDBA sample exams from Transcender.

Passing Score: 620, Questions: 50,  Time: 150 Min.

Da Notes Index 

[ 70-019 - A ] [ 70-019 - B ] [ 70-019 - C ] [ 70-019 - D ] [ 70-019 - E ] [ 70-019 - F ] [ 70-019 - H ] [ 70-019 - I ] [ 70-019 - L ] [ 70-019 - M ] [ 70-019 - N ] [ 70-019 - O ] [ 70-019 - P ] [ 70-019 - R ] [ 70-019 - S ] [ 70-019 - U ] [ 70-019 - V ] [ 70-019 - W ]

ADO

ActiveX Data Objects (ADO) is a data access interface used to communicate with OLE DB-compliant data sources, such as SQL Server. Applications can use ADO to connect to, retrieve, manipulate, and update data from SQL Server.

ADO MD

ActiveX Data Objects (Multidimensional) (ADO MD) library contains a number of objects you can use with the PivotTable Service. 

ADO MDX

ADO MDX (ActiveX Data Objects Multidimensional) is used to build your application that prints out the dimensions and hierarchies within an existing cube. Define a Catalog object to connect to the database, define a CubeDef object to retrieve the cube definition, iterate through the Dimensions and Hierarchies collections, and print out the results.