|
| |
| |
|
|
|
Da Notes -
70-019 - B
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
|
|
|
Backup and Restore
|
· Backs up an entire database, transaction log, or one or more files or file groups.
· Full database backup - backs up the entire database including the transaction log.
· Differential database backup - performed between full database backups.
· Transaction log backup - Use when changes made since the last differential or full database backup are important to maintain.
|
BCP (Bulk Copy Program)
|
SQL command prompt utility that can import or export to or from a data file and a SQL database
|
BULK INSERT
|
SQL statement that copies a data file into a database table or view in a user-specified format. Cannot export data (use BCP)
|
BUSINESS ANALYSIS PROCESS
|
Roles yield analytical processes, analytical processes yield information objects and events, and events yield KPIs.
Analysis of the data lifecycle - Periodicity (how often is the data changed), volume (how much data is
there), data quality/integration (how reliable is the data), and complexity (how difficult is it to get at the
data).
What activities are used to collect information during the opportunity evaluation phase?
Facilitated sessions with senior-level business and technical representatives
Review of the enterprise-level documentation and related materials
Your organization wants to set up a data warehouse. This warehouse will have inputs from seven different operational systems and will ultimately contain many subject areas. It is a big project. How do you make it manageable?
Prioritize the subject areas and limit the scope of the initial iteration. After the initial iteration is successful, implement the remaining subject areas in a series of phased projects.
Or:
Break up the subject areas into data marts that roll up into an enterprise data warehouse. Coordinate the data mart design by taking an enterprise-level perspective on design. After the data mart designs are coordinated, treat each as a separate project.
Analyzing Business Requirements
· Analyze the scope of a project.
· Identify the major subject areas that will be incorporated into the data warehouse.
· Analyze the extent of a business requirement.
Analyze security requirements.
Analyze performance and scalability requirements.
Analyze maintainability requirements.
Analyze human factors requirements, such as target audience, localization, accessibility, roaming users, Help, and special needs.
· identify objectives (e.g. the need to know which factor led to a drop in sales)
· gather and analyze information; find out from workers what sort of information is needed for the data warehouse
· identify only one segment at first to build a data mart
· create conceptual data model by pencil
· identify data sources that have integrity
· determine the duration of data kept in warehouse - recommended: 2 years (multi-duration for different data mart)
|
|
|
|
|
