| |
|
|
|
Da Notes -
70-019 - S
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
|
|
|
SCHEMAS
|
· Schema parts: Cube, dimension, member, hierarchy, and level
· Schema objects: CubeDef, Dimension, Hierarchy, and Level objects
· See star and snowflake schemas
|
Security
|
· Security is set via access control rights that are managed using roles. Enabled only if NTFS is used.
· 3 levels of access control:
· Read - Browsing of data and data structures (metadata). Does not allow modifying data and processing of data.
· Read/Write - Read and capable of modifying data in cubes designated and enabled for write-back.
· Admin - Default user account used to install the server. Only admin members can start the OLAP Manager and use admin functions (e.g. security management)
· Changing a User's Access Rights
· if the Auto Synch Period property is null or 0 (zero), synchronization occurs due to users' actions.
· if the Auto Synch Period property is set to a value, the ast synchronization takes effect immediately
Roles
· Map NT user accounts and user groups to security category assignments for cubes
· Use Manage Roles dialog box to create and manage at the database level
· MSSQLServerOLAPService is the service name for OLAP Services. Logon account associated with this service must have permissions to access data sources that OLAP Services administrators can access through the OLAP Manager
|
SCHEMAS
|
· Schema parts: Cube, dimension, member, hierarchy, and level
· Schema objects: CubeDef, Dimension, Hierarchy, and Level objects
· See star and snowflake schemas
|
SELECT INTO
|
Selecting data from an existing SQL Server table to be added to another table; SELECT INTO creates a new table, and INSERT SELECT requires an existing table
|
SNOWFLAKE SCHEMA
|
· More levels of dimensional tables (not always direct relationship to fact table)
· Foreign keys link lower level detail tables to dimensional tables.
· More normalized, more complex, more joins
· Lower row count
· Cannot drill down further from the lowest level of detail
|
SQL DMO
|
SQL-DMO allows applications written in languages that support Automation or COM to administer all parts of a SQL Server installation. A SQL-DMO program could monitor a database data and log size (check the size property).
|
SQL NS
|
SQL Namespace (SQL-NS) is a set of COM interfaces that allow a Microsoft® Visual Basic® or C++ application to invoke wizards, property sheets, dialog boxes and other SQL Server Enterprise Manager components.
|
SQLOLEDB
|
The OLE DB Provider for SQL Server (SQLOLEDB) is a native, high performance provider that accesses the SQL Server TDS protocol directly. OLE DB is a low-level, COM API that is used for accessing data. OLE DB is recommended for developing tools, utilities, or low-level components that need high performance.
|
SQL Server Profiler
|
· Monitor stored procedures. Capture SQL server events to be replayed on another server. Find the longest running queries or users running the longest queries.
|
STAR SCHEMA
|
· Most popular
· One central fact table
· Fact table uses multi-part key, can contain pre-calculated summarized value
· Larger fact table can be fast as it contains more pre-calculated value, but at the expense of higher storage and maintenance cost
· Dimension table has a 1-to-many relationship-to-fact table. Can be updated, while fact table is more long term.
|
System Requirements
|
Hardware/Software Requirements
Computer DEC Alpha AXP or Pentium 133 X86
Memory 32 megabytes (MB) minimum (64 MB recommended)
Hard disk space 35 - 50 MB (85 MB including common files and samples)
Server Operating system Microsoft Windows NT® Server 4.0 with Service Pack 4 or later
Windows NT Workstation 4.0 with Service Pack 4 (2)
Client Operating system: Windows 95 + DCOM95, Windows 95 OSR2 + DCOM95, Windows 98
Internet Explorer is required for Microsoft Management Console (MMC) and HTML Help
|
|
|
|
