Answer Asm 652

NOR FARAHIN BINTI MD SHARIF
2018682752
ASM 654
REVIEW QUESTION
1. List all types of statistics collected for monitoring the data warehouses
 Physical disk storage space utilization
 Number of times the DBMS is looking for the space in blocks or
causes fragmentation
 Memory buffer activity
 Buffer cache usage
 Input- output performance
 Memory management
 Size of each database table
 Access to fact table records
 Usage statistics relating to subject areas
 Numbers of completed queries by time slots during the day
2. Describe any six different types of action for growth plan collected statistic
 Allocate more disk space to existing databases tables
 Plan for new disk space for additional tables
 Modify file block management parameters to minimize fragmentation
 Create more summary tables to handle large number of queries
looking for summary information
 Reorganize the staging area files to handle more data volume
 Add more memory buffers and enhance buffer management
 Upgrade database survers
2018682752
ASM 654
3. How do the statistics help in fine- tuning the data warehouse

 The data statistic help in fine – tuning the data warehouse by
 Query performances
 Query formulation
 Incremental loads
 Frequency of OLAP loads
 OLAP system
 Data warehouse content browsing
 Report formatting
 Report generation
4. Do you think publishing the statistics and similar data for the users is
helpful? If so why?
 Yes, publishing the statistics and similar data for the users is helpful
because its provide the ability to inquire the dataset where the statistic
are kept
2018682752
ASM 654
5. What are the three main subjects in user training content? Why are these
essential?
 Data content
 The users must get a good grasp of what is available for them in
the warehouse
 The users must clearly understand the data content and how to
get to the data
 The user know the business terms and meanings
 Application
 The user can use the predefined queries and reports.
 The data feeds to downstream applications
 OLAP summaries and multidimensional analysis
 Works as executive Information system
 Tools
 You must train the users on the tools they need to employ to
access the information
 The users do not comprehend with the divisions of the training
program data content, applications and tools.
 Use of tools to formulate queries and obtain the results.
 Use of tools to runs report.
2018682752
ASM 654
6. Describe any four major task needed to prepared a training program.
 Remember to include the topics on data content , applications, and

tool usage
 Make a list of all current users to be trained.
 Place these users into logical groups based on the knowledge
and the logical skills. Determine what each group needs to be
trained on. By doing this exercise, you will be able to tailor the
training program to exactly match to the requirements of the
organizations.
 Determine how many different training courses would actually
help the users.
 A good set of courses consists of introductory courses, are in –
depth courses and a specialized courses.
 The introductory courses usually runs for one day.
7. What are the responsibilities of the training administrator?

 The responsibilities of the training administrator is
- schedules the courses
- matches the courses with the trainers
- make sure the training materials are ready
2018682752
ASM 654
8. Do you think a multitier user support structure is suitable for the data
warehouse environment? What are the alternatives?
Yes, multitier user support structure is suitable because the support structure
must be in place before the deployment of the first version of the data
warehouses.
9. What role can the company’s intranet play in training and user support?
 The role of company intranets is provide all the training needed
and provide the sources for the users supports
10.List any five factors to be part of ETL management?

 Run daily extraction jobs on schedule
 Ensure the results of the replication process is checked out
 Make sure all defined the paths for the data transformation and
cleansing are traversed correctly
 Ensure that all reconciliation is compile between source system
records counts and records counts in extracted files.

Answer Asm 652

Uploaded by

Copyright:

Available Formats

Answer Asm 652

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Answer Asm 652

Uploaded by

Copyright:

Available Formats

NOR FARAHIN BINTI MD SHARIF

3. How do the statistics help in fine- tuning the data warehouse

6. Describe any four major task needed to prepared a training program.

 Remember to include the topics on data content , applications, and

7. What are the responsibilities of the training administrator?

10.List any five factors to be part of ETL management?

You might also like