data warehouse Exam....NEED ANSWERS IN ONE HOUR..MUST BE ALL CORRECT!
macly.
final_new.pdf
6/8/2016 Take Test: Week 11 Final Exam – CIS429002VA0161164001
https://blackboard.strayer.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_668775_1&course_id=_180206_1&content_id=_19069596_1&ste… 1/10
Week 11 Take Test: Week 11 Final ExamH
Take Test: Week 11 Final Exam
Test Information Description Instructions The Final Exam will consist of 40 multiple choice and true/false questions. You will
have 2 hours to complete it. Good Luck! Timed Test This test has a time limit of 2 hours.This test will save and submit automatically when
the time expires. Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain.
Multiple Attempts
Not allowed. This test can only be taken once.
Force Completion
Once started, this test must be completed in one sitting. Do not leave the test before clicking Save and Submit.
Question Completion Status:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
Save All Answers Save and Submit
Which of the following options relate to the immediate data extraction technique of ETL functions in the data warehouse?
QUESTION 1 2 points Save Answer
?
My Institution Tutoring Resource Center Career Resources Help
Remaining Time: 1 hour, 53 minutes, 07 seconds.
Machly Destin 22
6/8/2016 Take Test: Week 11 Final Exam – CIS429002VA0161164001
https://blackboard.strayer.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_668775_1&course_id=_180206_1&content_id=_19069596_1&ste… 2/10
functions in the data warehouse? Data capture through transaction logs Data capture through database triggers Data capture in source systems ALL OF THE ABOVE
Which of the following are major steps in the ETL process in the data warehouse? I.Determine all the data sources, both internal and external II.Establish data transformation and cleansing rules III.Plan for aggregate or summary tables IV.Write procedures for all data loads V.Plan datafeeds from the data warehouse to downstream MDDBs
I, II, III, IV II, III, IV, V I, III, IV, V I, II, III, V
QUESTION 2 2 points Save Answer
Which of the following applies to the methods for data capture based on date and time stamping from source systems as part of the ETL functions in the data warehouse?
Transaction logs must be set up Major revisions to existing source applications likely Performance of source systems greatly affected NONE OF THE ABOVE
QUESTION 3 2 points Save Answer
As part of storage management during the growth and maintenance phase of the data warehouse project, if it is a distributed environment with multiple servers having individual pools, it is preferable to connect the servers to a single storage pool that can be accessed intelligently.
True False
QUESTION 4 2 points Save Answer
Similar to OLTP systems, executive and senior management staff are excluded from user training.
True False
QUESTION 5 2 points Save Answer
With respect to user training courses in the data warehouse project, which of the following is NOT suitable for an introductory course?
Browsing of warehouse contents Predefined queries
QUESTION 6 2 points Save Answer
6/8/2016 Take Test: Week 11 Final Exam – CIS429002VA0161164001
https://blackboard.strayer.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_668775_1&course_id=_180206_1&content_id=_19069596_1&ste… 3/10
Predefined queries Details of source system platforms Data warehousing overview
With regard to physical model components of the data warehouse, which of the following is the correct matching of physical data structure and the corresponding data storage area?
Load image flat file Data Warehouse Repository Virtual sequential access file Data Staging Area Proprietary matrix file OLAP Source system extract flat file Downstream application
QUESTION 7 2 points Save Answer
With regard to using RAID technology for data storage in the data warehouse, which of the following refers to the basic features of this technology? I.Disk aggregating II.Disk mirroring III.Disk duplexing IV.Parity checking V.Disk striping
I, II, III, IV II, III, IV, V I, II, IV, V I, II, III, V
QUESTION 8 2 points Save Answer
Bitmapped indexes are more suitable for the data warehouse environment than for an OLTP system.
True False
QUESTION 9 2 points Save Answer
The following are significant objectives of the physical design process of the data warehouse EXCEPT:
Ensuring performance Managing storage Providing scalability Establishing source system data extractions
QUESTION 10 2 points Save Answer
Which of the following refers to characteristics of data quality in the data warehouse? A data item is exact fit for the purpose business users have defined it Enables quick and easy data retrieval
QUESTION 11 2 points Save Answer
6/8/2016 Take Test: Week 11 Final Exam – CIS429002VA0161164001
https://blackboard.strayer.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_668775_1&course_id=_180206_1&content_id=_19069596_1&ste… 4/10
Enables quick and easy data retrieval Relates to the system as a whole BOTH A and C
Which of the following is the correct matching of data quality dimension in the data warehouse and the corresponding meaning?
Domain integrity values of a data item same across all source systems Consistency duplication of records completely resolved Data anomaly a data field not used only for the purpose for which it is defined Completeness same data not stored in more than one place in the system
QUESTION 12 2 points Save Answer
Which of the following is the correct matching of type of data quality problem in the data warehouse and the corresponding example of the problem?
Dummy values in fields value 99999 in zip code field for European customer Contradicting values store codes and product codes in the same field Inconsistent values user comments entered in the field for contact name Multipurpose fields a California state code and New Jersey zip code for the same customer
QUESTION 13 2 points Save Answer
In the initial user support arrangement that is set up during the deployment phase of the data warehouse project, which of the following is the correct matching of point of support and its corresponding support role?
Hotline support first point of contact within department Managerial support information on query templates and how to use them Technical support provide support on hardware, system software, and tools User representative resolve issues not resolved by technical support
QUESTION 14 2 points Save Answer
The following represent actions during user acceptance testing for the deployment of the data warehouse EXCEPT:
Users in each department to run and test typical queries and reports Each user group to test a subset of predefined queries and preformatted reports Users to test data clustering in the database Users to test thirdparty frontend tools and interfaces
QUESTION 15 2 points Save Answer
In order to speed up the initial data load of the data warehouse, it is a good practice to suspend referential integrity verification during the load process.
True False
QUESTION 16 2 points Save Answer
6/8/2016 Take Test: Week 11 Final Exam – CIS429002VA0161164001
https://blackboard.strayer.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_668775_1&course_id=_180206_1&content_id=_19069596_1&ste… 5/10
False
Among the many different definitions for metadata in the data warehouse, which of the following does NOT indicate what metadata is?
Data warehouse atlas Data warehouse tools
Data warehouse roadmap Data warehouse directory
QUESTION 17 2 points Save Answer
Which of the following types of information from metadata indicate that metadata in the data warehouse is essential for endusers?
Query templates Navigation paths Hardware/software of source systems BOTH A and B
QUESTION 18 2 points Save Answer
For performing data extraction/transformation/loading functions in the data warehouse, which of the following types of questions are answered by metadata? I.How to improve query performance? II.How to determine external sources? III.Where to cleanse the data? IV.How to switch to new data transformation techniques? V.How to apply ongoing changes in source systems?
I, II, III, IV I, II, III, V I, III, IV, V II, III, IV, V
QUESTION 19 2 points Save Answer
Which of the following is NOT a characteristic of the Decision Trees technique of data mining?
Applies to classification and prediction Always each lowest level branch ends up in a classification of the input record Each node has a rule to split the subsets flowing through the branches Suitable to trace back decision paths to ascertain reasons for the flow
QUESTION 20 2 points Save Answer
While comparing OLAP and Data Mining which of the following represents the right matching of the technology and an example of questions answered? I.OLAP Who are the top 100 customers for the last 3 years? Data Mining Which top 100
QUESTION 21 2 points Save Answer
6/8/2016 Take Test: Week 11 Final Exam – CIS429002VA0161164001
https://blackboard.strayer.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_668775_1&course_id=_180206_1&content_id=_19069596_1&ste… 6/10
I.OLAP Who are the top 100 customers for the last 3 years? Data Mining Which top 100 customers offer the best profit potential? II.OLAP Which salespersons exceeded their quota during last 3 quarters? Data Mining Which salespersons are likely to exceed their quota next year? III.OLAP Which customers switched to other phone companies last year? Data Mining Which customers are likely to switch next year? IV.OLAP Which customers are likely to be bad risks? Data Mining Which customers defaulted on their mortgages last two years? V.OLAP Last year, which stores exceeded the prior year sales? Data Mining For next two years which stores are likely to have best performances?
I, II, III, IV II, III, IV, V I, II, IV, V I, II, III, V
Which of the following represent the major steps in the knowledge discovery process of data mining? I.Run queries in interactive analysis sessions II.Preprocess data III.Mine data IV.Select promising patterns from output V.Apply results to create actionable items in the business
I, II, III, IV II, III, IV, V I, II, IV, V I, II, III, V
QUESTION 22 2 points Save Answer
Which of the following is the correct matching of tables and attributes in the dimensional data model for automaker sales?
Fact table Single Brand Flag CUSTOMER dimension table Income Range PRODUCT dimension table Day of Week DEALER dimension table Interest Rate
QUESTION 23 2 points Save Answer
A dimension table in a dimensional data model is generally said to be wide because it contains large number of rows of data.
True False
QUESTION 24 2 points Save Answer
Which of the following relates to a factless fact table in the dimensional data model? Has no attributes apart from the primary key Has a combination of metrics and dimensions as attributes Serves as another fact table in addition to the regular fact table
QUESTION 25 2 points Save Answer
6/8/2016 Take Test: Week 11 Final Exam – CIS429002VA0161164001
https://blackboard.strayer.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_668775_1&course_id=_180206_1&content_id=_19069596_1&ste… 7/10
Serves as another fact table in addition to the regular fact table Has miscellaneous dimensions as attributes
Which of the following are guidelines for consideration of applying changes to dimension tables in a dimensional data model? I.Most dimensions are generally constant over time
II.Even those dimension attribute values that change, they change slowly III.Overwriting of dimension attribute values is not always appropriate IV.Applying changes to dimension attribute values is exactly similar to how changes are made in source OLTP systems V.Applying changes to dimension attribute values depends on what must be preserved in the data warehouse
I, II, III, IV II, III, IV, V I, III, IV, V I, II, III, V
QUESTION 26 2 points Save Answer
In a dimensional data model, the options for handling "junk" dimensions, such as flags and texts are the following EXCEPT:
Place the "junk" dimensions, unchanged, in the fact table Make each "junk" dimension into a separate dimension table Discarding others and keep all the meaningful "junk" dimensions in a single dimension table Exclude and discard all "junk" dimensions from the data model
QUESTION 27 2 points Save Answer
SALESPERSON dimension table in a dimensional data model has the attribute values Old Region Name: (null), Current Region Name: North East, Effective Date: January 1, 2011. A type 3 change is applied on January 1, 2012 to change the region to MidWest. Which of the following represents the attribute values after this type 3 change is applied?
Old Region Name: North East, Current Region Name: MidWest, Effective Date: January 1, 2012 Old Region Name: (null), Current Region Name: MidWest, Effective Date: January 1, 2012 Old Region Name: (null), Current Region Name: North East, Effective Date: January 1, 2012 Old Region Name: North East, Current Region Name: MidWest, Effective Date: January 1, 2011
QUESTION 28 2 points Save Answer
The CUSTOMER dimension table in the dimensional data model for a nationwide telecommunication company has nearly a million rows. This is a rapidly changing dimension with this dimension table having some attributes changing frequently and others slowly. Which of the following techniques is appropriate for applying changes to the CUSTOMER dimension table?
QUESTION 29 2 points Save Answer
6/8/2016 Take Test: Week 11 Final Exam – CIS429002VA0161164001
https://blackboard.strayer.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_668775_1&course_id=_180206_1&content_id=_19069596_1&ste… 8/10
dimension table? Apply the changes as corrections without preserving history Apply the changes as type 2 changes Break off the rapidly changing attributes into another dimension table Have regular downtime for the data warehouse to apply the changes
In the OLAP system of a data warehouse, the results of a query are displayed as follows: Rows Months; Columns Products; Pages Stores. Which of the following represents the display after one sliceanddice (rotation) operation?
Rows Products; Columns Months Rows Stores; Columns Products Rows Months; Columns Stores NONE OF THE ABOVE
QUESTION 30 2 points Save Answer
In the OLAP system of the data warehouse, which of the following does NOT refer to the feature known as transparency?
Provide true open system approach Allow sparse matrix handling Hide details of diverse nature of source data Avoid exposure of users to the complexities of underlying data repository
QUESTION 31 2 points Save Answer
In an OLAP system, the multidimensional data model for a department store has the SALES fact table and the following dimension tables: STORE, PRODUCT, TIME, PROMOTION, and CUSTOMERDEMOGRAPHICS. If you represent this as an MDS (multidimensional domain structure), you will have a fivedimensional MDS with a total of five vertical lines.
True False
QUESTION 32 2 points Save Answer
The multidimensional database of an OLAP system has the following sales data: STORE: Ohio; PRODUCT: Shirt; MONTH: March; Sale Units: 250. Then, the sale units may be represented by a physical cube whose edges parallel to the X, Y, and Z axis represent the particular store (Ohio), the specific product (Shirt), and the corresponding sale month (March).
True False
QUESTION 33 2 points Save Answer
In a managed query environment at the data warehouse, aggregate awareness refers to which of the following?
Parsing incoming queries and recasting them to work more efficiently
QUESTION 34 2 points Save Answer
6/8/2016 Take Test: Week 11 Final Exam – CIS429002VA0161164001
https://blackboard.strayer.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_668775_1&course_id=_180206_1&content_id=_19069596_1&ste… 9/10
Parsing incoming queries and recasting them to work more efficiently Presenting results of a query in multiple formats Making complexity of query formulation transparent to users Ability to redirect queries to summary tables for faster retrieval
In the data warehouse environment, the user has equal control over getting information
through preformatted reports and obtaining information through queries he or she can formulate.
True False
QUESTION 35 2 points Save Answer
With regard to skilled analysts (users classified as explorers), which of the following is a consideration for information delivery to them from the data warehouse?
Availability of large data volumes to analyze and mine Support for long analysis sessions Ability to format simple reports Ability to produce customer invoices
QUESTION 36 2 points Save Answer
In a Webenabled data warehouse, which of the following refers to important information derivable from clickstream data for identifying and retaining ecommerce customers? I.Mental condition of the customer II.Affinity between products likely to be bought together III.Referring partner links IV.Site navigation resulting in sales or otherwise V.Customer demographics
I, II, III, IV II, III, IV, V I, II, IV, V I, II, III, V
QUESTION 37 2 points Save Answer
A Webenabled data warehouse can have no downtime; it is expected to be up and available all the time. This is a major implementation consideration.
True False
QUESTION 38 2 points Save Answer
In a Webenabled data warehouse, communication with users takes place only through HTML or XML pages.
True False
QUESTION 39 2 points Save Answer
6/8/2016 Take Test: Week 11 Final Exam – CIS429002VA0161164001
https://blackboard.strayer.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_668775_1&course_id=_180206_1&content_id=_19069596_1&st… 10/10
Save All Answers Save and Submit
False
In a Webenabled data warehouse, because of its wide openness, basic architectural coherence among the distributed units is achieved by adopting dimensional modeling as the basic data modeling technique.
True
False
QUESTION 40 2 points Save Answer
