ISDS 556 Final
Which of these are true about Facts in Fact Tables? A. Usually numeric B. Describe tangible objects C. Usually text based D. None of the Above
A. Usually numeric
1. Business Dimensional Life cycle lays out the _________________ flow that occurs during a data warehouse implementation. A. detailed B. general C. specific D. restricted
A. detailed
The time taken to process rows in a data warehouse is an example of _________________ A. process metadata B. business metadata C. technical metadata D. front room metadata
A. process metadata
Service level metrics that help determine success include ______? Availability Data Quality Support Responsiveness All of the above
All of the above
1. Based on the matrix for major drivers of an architecture effort _______ weeks would be considered functionally complex. A. 1-4 B. 8-12 C. 12 + D. None of the above
B. 8-12
1. What is the difference between Data Warehousing and Business Intelligence? A. Data Warehousing refers to the overall process of providing information to support business decision making, while Business Intelligence refers only to the reporting and analysis part of those stored data. B. Business Intelligence refers to the overall process of providing information to support business decision making, while Data Warehousing refers only to extracting and storing data. C. There are no differences between them. The terms are often written together as "data warehouse/business intelligence" to signify the readers that they mean the same thing. D. Any answer above can be correct depending on the person using the terms and the context they use them in due to the lack of consensus in the industry.
B. Business Intelligence refers to the overall process of providing information to support business decision making, while Data Warehousing refers only to extracting and storing data.
2. Approximately 70 percent of the warehouse development hours are spent on this: A. User Interviews B. ETL Process C. Data Analysis D. Report Building
B. ETL Process
_______________ is the process of altering a message with a secret code so that it can be read only by people who know the code. A. Integration B. Encryption C. Authentication D. Filtering
B. Encryption
Q2. _________ are characterized by a multipart key made up of foreign keys from the intersecting dimension tables involved in a business process: A. Dimension Tables B. Fact Tables C. Operational Data store D. Metadata
B. Fact Tables
Q2. A data model can have as many Fact and Dimension tables as required? A. True B. False
B. False
2. Data can cause significant feasibility issue in a successful warehouse plan if it is _________________. A. Fully collected B. Filthy C. Easy for the initial effort D. Consolidated
B. Filthy
What is NOT a step of platform evaluation? A. Design and Implement routines to collect test results B. Flag requirements as "must have" or "nice to have" C. Design the physical database, including disk layout, indexes, and striping D. Load test data
B. Flag requirements as "must have" or "nice to have"
Q1. When interviewing a business manager/analyst, what should not be the main concern? A. Clearly defining success metrics B. Focusing on technical details C. Demarcating key business issues D. Obtaining relevant domain knowledge
B. Focusing on technical details
1. A ____________ is a part of the interview team who's primary responsibility is to take copious notes during the interview. A. Lead Interviewer B. Scribe C. Observer D. DBA
B. Scribe
Which of the following is NOT one of the parallel tracks the Business Dimensional Lifecycle focuses on? A. Technology B. Speed C. Data D. End-User
B. Speed
How many tiers is the ROLAP Application layer? A. Two B. Three C. Four D. One
B. Three
2. What is one of the areas the project manager needs to focus on after the initiative is funded? A. Digging into the Data B. Timeline Planning C. Status Monitoring D. Manage the Metadata
B. Timeline Planning
2. Which is not a unique characteristic of the data warehouse project? A. Cross-functional implementation team B. Elevated visibility C. External resources D. Iterative development cycle
C. External resources
2. _____________ is a semantic layer in DW/BI architecture that helps anticipate as may issues as possible. A. Planning B. Learning C. Flexibility and Maintenance D. Productivity and Reuse
C. Flexibility and Maintenance
1.Program/Project Management activities DO NOT focus on which of the following: A. Monitoring project status B. Issue tracking C. Funding for projects D. Changing scope control to preserve scope boundaries
C. Funding for projects
Which member of the interview team is responsible for compiling the questionnaire? A. Scribe B. Interviewee C. Lead Interviewer D. Observer
C. Lead Interviewer
Question 1: What factors are considered in a two-by-two prioritization grid A. Profitability and Feasibility B. Potential Business Growth and Profitability C. Potential Business Impact and Feasibility D. Total Cost and Potential Business Impact
C. Potential Business Impact and Feasibility
__________ metadata is event measurement data for the processes of building and using the DW/BI system. A. Technical B. Business C. Process D. Functional
C. Process
Kick-off Meeting Agenda items should include all these items except ______. Introductions Project Detail Project Overview Objections
Objections
The Core Project Team (Full-time and Part-time) consist of all these members except _________? Business systems analyst Data Modeler Security Architect Data Staging system designer
Security Architect
The ___ slowly changing dimension response is the most popular and powerful technique for accurately tracking changes in attribute values a. Type 2 b. Type 3 c. Type 1 d. Type 4
a. Type 2
2. When creating the metadata strategy, the main recommendation by the Kimball Lifecycle team is to concentrate on ____________ first. a. viewing major metadata stores b. securing the development environment c. business metadata d. create routers and firewalls for metadata
c. business metadata
Which of the following is the most important factor for a successful data warehouse? a. Compelling business motivation b. feasibility c. strong business management sponsor d. current analytic culture
c. strong business management sponsor
Chapter 6 Question: When dealing with Junk Dimensions, what situations should be avoided? a. Leave them in the fact tables b. Eliminate them c. Make them into separate dimensions d. All of the above
d. All of the above (Correct)
In the perspective of Data Track in Project management, Dimensional Modeling identifies which of the following? a. Fact table grain b. Attributes and Associated dimensions c. Hierarchical drill paths and facts d. All of the above.
d. All of the above.
2. Which of these can serve as financial justification for a project? a. ROI b. Opportunity cost c. Changing market conditions d. All of these
d. All of these
1. Which of the below is a major area for the typical warehouse evaluation? a. Hardware platform b. DBMS platform c. Data access tools d. All the above
d. All the above
2. What are the benefits of dimensional modeling? a. Understandability b. Query Performance c. Each dimension has an equivalent entry point into fact table d. All the above
d. All the above
2. All of the below project roles are identified as part of potential special teams except _________? a. Technical Architect/Technical Support Specialist. b. Lead Tester c. Security Manager d. Business Analyst
d. Business Analyst
1. When identifying business processes, these common characteristics and patterns emerge EXCEPT: a. Business processes are frequently expressed as action verbs b. Business processes are typically supported by an operational system or module c. Business processes generate key performance metrics d. Business processes refer to a business department, organization, or function
d. Business processes refer to a business department, organization, or function
Dimensional models stored in multidimensional online analytical processing (OLP) structures are called: (a) Star joins. (b) Star schemas. (c) Cubes. (d) Fact tables.
(c) Cubes.
From a DW/BI system application perspective, architecture development process is a ------------ Process. (a) Down-top. (b) Multi dimensional. (c) Top-down. (d) cross sectional.
(c) Top-down.
1. Which of these options would you receive from your vendor for support? a. Documentation b. Training c. All of these d. Consulting
*c. All of these
The ___________ Lifecycle ensures that the project pieces are brought together in the right order and at the right time. A - Kimball B - SDLC C - Development D - Project
A - Kimball
1. Once the DW/BI architecture is in place, you have the two key components that drive the product selection process: A) Business and Functional Requirements B) DBMS Platforms and ETL Tools C) Hardware and Software Surveys D) Documentation and Change Control
A) Business and Functional Requirements
Which of the following is one of the three parallel "tracks" mentioned in the Kimball Lifecycle Diagram? A) Data B) Analytics C) Deployment D) Project Management
A) Data
Question 2: Regarding DW/BI readiness, if your data is filthy, overly complex, or not even collected then you are likely to have a ________ issue. A) Feasibility B) Data Quality C) Consistency D) Structural
A) Feasibility
1. How many pages should an Interview Questionnaire fit in? A. 1 B. 2 C. 3 D. As many pages as needed
A. 1
What is a drawback of breaking off rapidly changing attributes into their own separate dimension from original dimension? A. Attributes are limited to a range of discrete values B. Separate dimension can grow too large C. Easier to browse between original and new separated dimension tables D. There are now multiple ways, besides the Fact Table record, to link the original and separate dimensions.
A. Attributes are limited to a range of discrete values
Which of the following is NOT an advantage of an interview approach when it comes to collecting requirements? A. Can gather information from a larger group B. Easier to schedule C. Ensures that every voice is heard D. Information gathered is detailed
A. Can gather information from a larger group
2. Who leads the architecture task force? A. DW/BI technical architect. B. Project Manager C. Business Analyst D. Business Project Lead
A. DW/BI technical architect.
Which of these IS a threat to business continuance? A. Denial of service attack B. Economic Slowdown C. Power Outage D. Untrained employees.
A. Denial of service attack
Which of the following is not a part of Plan the Project? A. Determine the financial returns and benefits B. Establish the project identity C. Staff the project D. Develop the project plan
A. Determine the financial returns and benefits
2) What is NOT a strength of Dimensional Modeling? A. Facilitates Record Updates B. Withstands changes in user behavior C. Easily adaptable D. Presentation Tool Facilitation
A. Facilitates Record Updates
Which of the following methods is best for collecting requirements? A. Interviewing B. Questionnaires C. Procuring largest binder D. Surveys
A. Interviewing
Q2. _________ systems are centralized facilities designed to hold master copies of key entities, such as customers or products.: A. Master Data Management B. DW/BI C. Operational Data store D. Metadata
A. Master Data Management
2. Which is NOT an Application Server Consideration (as part of this book)? A. Metadata B. Disk C. Platform Sharing D. Bottlenecks
A. Metadata
2. Business requirements set up the foundation for three parallel tracks that are focused on? A. Technology, Data, and Business Intelligence Applications B. Technology, Growth and Deployment C. Deployment, Maintenance and Growth D. Speed, Scope, impact
A. Technology, Data, and Business Intelligence Applications
2. What is one of the responsibilities of a Business Analyst in a Core Project Team? A. The business analyst is responsible for leading the business requirements definition activities and then representing those requirements as the technical architecture, dimensional model, and BI applications are specified. B. The business analyst is responsible for developing the overall data architecture strategy of the Data Warehouse/Business Intelligence system, ensuring reusability, integration, and optimization. C. The business analyst is responsible for the end-to-end design of the production process to extract, transform, and load the data. D. The business analyst has overall responsibility for the front room of the Data warehouse/Business Intelligence system, ensuring that the BI environment is optimized to address the business' requirements.
A. The business analyst is responsible for leading the business requirements definition activities and then representing those requirements as the technical architecture, dimensional model, and BI applications are specified.
Q1. _______ is one of the primary reasons that dimensional modeling is the widely accepted best practice for structuring the data presented to the business intelligence layer: A. Understandability B. Query Performance C. Reduced Redundancy D. Adaptability
A. Understandability
The two primary constructs of a dimensional model are ______ tables and dimension tables. A - project B - fact C - Kimball D - database
B - fact
2) During the interview process, the number of interviews typically grows from ___ to ___ percent. A) 5,15 B) 10, 20 C) 20, 30 D) 30, 40
B) 10, 20
Question 2: When dimensions are exactly the same or a perfect subset of one another with matching row headers are known as: A) Standardized dimensions B) Conformed dimensions C) Granular dimensions D) Consolidated dimensions
B) Conformed dimensions
_____________ are the temporary or permanent landing places for data across the DW/BI system. A) Data Delivery Services B) Data Stores C) Data Marts D) Data Warehouse
B) Data Stores
In reference to step 5, "Evaluate the Candidates", in the product selection process, meetings that are set up with each candidate vendor are called _________ sessions because you must control the agenda. A) Fire B) Grill C) Short D) Concise
B) Grill
Question 1: The author referred ETL systems as a back room kitchen of the DW/BI environment with the following analogies EXCEPT: A) The establishment is doomed if the meals coming out of the kitchen are inconsistent, fail to meet expectations, or worse, cause food poisoning. B) Restaurant patrons can view behind the scenes to check out the food preparation or taste the sauce before ordering an entree. C) Raw materials are dropped off at the back door and then transformed into a delectable meal for the restaurant patrons by talented chefs. D) The dining room is designed and managed based on the preferences expressed by the restaurant's patrons, not the kitchen staff.
B) Restaurant patrons can view behind the scenes to check out the food preparation or taste the sauce before ordering an entree.
Dimension tables contain the descriptive attributes and characteristics associated with _____________. A) Business Intelligence B) Tangible measurement events C) Metadata D) Project Management
B) Tangible measurement events
Which of the following is not a characteristic that Dimension attributes should have A) Discretely valued B) Verboten C) Quality assured D) Descriptive
B) Verboten
2. Choosing the business process, declare the grain, identify the dimensions and identifying the facts are 4 steps of the ______ ______ process A) data warehouse B) dimensional design C) business model D) change control
B) dimensional design
1. What is an overbooked user? A. Users who respond to your classic open-ended questions with monosyllabic, one-word responses. B. Uncooperative business users who are simply too busy to meet anytime soon C. An uncooperative business user who has been interviewed in the past but have yet to see anything result from their efforts. D. When members of IS organizations say they know what the business users need.
B. Uncooperative business users who are simply too busy to meet anytime soon
A data mart contains: A. technical operational tasks that keep the system performing optimally, including monitoring, performance tuning, index maintenance, and system backup. B. summarized departmental, independent non-architected datasets C. reporting and analysis of the data stored in the data warehouse. D. the broader, ongoing coordination or resources, infrastructure, timelines, and communication across multiple projects.
B. summarized departmental, independent non-architected datasets
The challenge in the extract process is determining what data to extract and ______________. A. what to delete B. what kinds of filters to apply C. how to clean it D. None of the above
B. what kinds of filters to apply
The DW/BI application architecture design process culminates in the creation of the _______________. A) Technology direction infrastructure B) Infrastructure process document C) Architecture plan document D) Design implementation plan
C) Architecture plan document
_____________ is the technical analysis of data to describe its content, consistency, and structure. A) Preliminary scope planning B) Technical feasibility analysis C) Data profiling D) Content Development
C) Data profiling
1) Which component IS NOT a part of the combination that allows users from any part of the business to transparently query the data at any level of detail for any available business process? A) atomic level business process dimensional models B) performance aggregates C) MDM systems D) an aggregate navigator
C) MDM systems
What is a dimension called when it has redundant attributes and decodes are removed to separate tables and linked back into the original table with artificial keys? A) Data Extraction B) Conformed Dimension C) Snowflaked D) Fixed Hierarchies
C) Snowflaked
Which of the following is NOT considered a "Readiness Deal Breaker" when assessing DW/BI readiness? A) Strong Senior Business Management Sponsor(s) B) Feasibility C) Technology D) Compelling Business Motivation
C) Technology
After each business process-focused opportunity is placed on the prioritization grid, in which quadrant should the team begin with? See the diagram below for visual assistance. A) Upper Left Quadrant B) Bottom Right Quadrant C) Upper Right Quadrant D) Lower Left Quadrant
C) Upper Right Quadrant
2)Most dimensional models end up with somewhere between ___ and ___ dimension tables. A)4,12 B)1,6 C)8,15 D)10,12
C)8,15
Collecting business requirements considering business needs relative to a program perspective set with senior management is done at the a)Business Level. b) Micro Level. C)Macro Level. d)Management Level
C)Macro Level.
Even when all the other tasks have been well planned and executed, ___ percent of the risk and effort in the DW/BI project comes from the design and development of the extract, transform, and load (ETL) system. A. 10% B. 30% C. 70% D. 90%
C. 70%
It is suggested to tell your vendor that you want a ____-day trial period or longer if possible. A. 30 B. 60 C. 90 D. 120
C. 90
Which IS NOT a listed benefit of using surrogate keys A. Performance B. Mapping to integrate disparate sources C. Applications Require it. D. Track Changes in dimension attribute values.
C. Applications Require it.
Q1. The _________ is responsible for requirements definition and serve as a bridge between IT and the business facing units: A. Technical Architect B. Quality Assurance Analyst C. Business Analyst D. Business Intelligence (BI) Architect
C. Business Analyst
2. Which is NOT a level of detail in the architecture framework? A. Architecture models B. Business requirements C. Caveats D. Detailed models
C. Caveats
1. Users may not be able to articulate precisely which data elements in which source systems interest them, but nearly all the time, they can clearly describe what they do. This describes what type of user? A. Know-It-All User B. Abused User C. Clueless User D. Comatose User
C. Clueless User
Question 2: What are some considerations for desktop machines when building the infrastructure of front room? A. Chipset, hard drive, keyboard, mouse, and monitor B. Memory, power supply, drivers, and cloud support C. Cross-platform support, memory, desktop operating system, and software D. Desktop operating system, cloud support, cross-platform support, and drivers
C. Cross-platform support, memory, desktop operating system, and software
_______ are often regarded as sophisticated clients or the data warehouse, fitting architecturally after the data warehouse, but before business intelligence. A. Lead Tester B. Technical Architect/Technical Support Specialist C. Data Mining/Statistical Specialist D. ETL Architect/ETL Developer
C. Data Mining/Statistical Specialist
2. Which of the following deliverables is NOT key to designing the dimensional model? A. Issues list B. Attribute and metrics list C. Detailed requirement document D. High level model diagram
C. Detailed requirement document
Q2. _________ contain the descriptive attributes and characteristics associated with specific, tangible measurement events: A. Master Data B. Fact Tables C. Dimension Tables D. Metadata
C. Dimension Tables
1. Which procedure below is NOT how companies secure their hardware and operating system? A. Restrict network access B. Keep the operating system up-to-date with security patches C. Purchase enterprise antivirus licenses for both hardware and operating system D. Restrict login access to only system administrators for DW/BI components
C. Purchase enterprise antivirus licenses for both hardware and operating system
Which of these is NOT a role of the interview Team A. Scribe B. Lead Interviewer C. Senior Manager D. Observer
C. Senior Manager
Which of these is NOT part of defining the project A.Evaluate Readiness Factors B. Determine the financial returns and benefits C. Staff the project D. Build business justification
C. Staff the project
Which of these activities to not fall in managing the program: A. Establishing governance responsibilities and processes B. Communicating C. Staffing the Project D. Conducting periodic assessments
C. Staffing the Project
1) What is NOT a major area to cover in the Infrastructure Plan? A. Desktop B. Server Hardware C. Storage D. Network
C. Storage
1. What are the three concurrent tracks in the Kimball Lifecycle after the business requirements definition? A. Technical Architecture Design, Product Selection & Installation, Physical Design B. Dimensional Modeling, BI Application Development, ETL Design & Development C. Technical Architecture Design, Dimensional Modeling, BI Application Design D. Dimensional Modeling, BI Application Design, Physical Design
C. Technical Architecture Design, Dimensional Modeling, BI Application Design
Which of these is NOT part of the application architecture document. A. Methodology B. Architecture Overview C. User List D. Architecture Development Process
C. User List
There are two basic interactive techniques for gathering requirements: interviews and ___________ A. virtual meetings B. questionnaires C. facilitated sessions D. presentations
C. facilitated sessions
Which one does not belong to four major areas for the typical warehouse? A. Hardware platform B. DBMS platform C.Data server hardware D. Data staging tool E. Data access tools
C.Data server hardware
The enterprise data warehouse bus architecture and associated matrix serves the purpose of ____________. A) Architecture planning B) Data Integration coordination C) Organizational communication D) All of the above
D) All of the above
Business Processes are: A) Fundamental building blocks of your DW/BI system B) Typically represent a manageable sized implementation of data and analysis C) Lowest level event or activity that the business performs. D) All of the above.
D) All of the above.
All of these are benefits of gathering requirements from Interviews over facilitated sessions EXCEPT: A) Schedules are a relatively limited amount of time as opposed to all-day meetings. B) Interviews encourage a high degree of participation from interviewees. C) Interviews ensure that every voice is heard. D) Interviews require a greater commitment from each participant.
D) Interviews require a greater commitment from each participant.
1)A packet-filtering router also called a packet-filtering firewall, CANNOT provide which of the following function to secure the network? A) Reject connection attempts from unknown hosts. B) Reject attempts from the outside that are spoofing as insiders. C)Accept only traffic that comes from a single machine. D) Keep up to date with security patches for the operating system.
D) Keep up to date with security patches for the operating system.
What is referred to as 'all the information that defines and describes the structures, operations, and contents of the DW/BI system'? A) Source Data B) ETL Process C) Atomic Data D) Metadata
D) Metadata
Question 1: Which is not an advantage of recording fact tables at the lowest most detailed atomic grain: A) It allows queries to ask the most precise questions possible. B) Allows for the data to be grouped "any which way" to answer unpredictable ad hoc queries. C) Allow fact tables to be impervious to change by adding newly sourced facts, dimension attributes, and new dimensions. D) They can be determined at the end of the design process
D) They can be determined at the end of the design process
Q1. In the Business Dimensional Lifecycle, which track is the most important? A. Technology Track B. Data Track C. Application Track D. All are equally important as they run parallel but the context and field in which a company operates matters the most.
D. All are equally important as they run parallel but the context and field in which a company operates matters the most.
Attributes have following characteristics to ensure the quality of the overall data warehouse? A. Full Words, no abbreviations B.Quality Assured C. Indexed D. All of the above
D. All of the above
Which of these are key factors in establishing a successful data warehouse foundation? A. Strong Business Management Sponsor(s) B. Compelling Business Motivation C. IS/Business Partnership D. All of the above
D. All of the above
Q1. When creating an application architecture, what should be the main concern? A. Identify clear deliverables for each phase of the architecture B. Review the final architecture with key players C. Create a technical architecture plan document D. All of the options are equally important
D. All of the options are equally important
Q2. During the various phases of a Datawarehouse project such as defining, planning and managing, which aspect/s should be constantly monitored? A. Scope B. Management Support C. Feasibility D. All of these.
D. All of these.
Conformed dimensions are known as the _________ of the enterprise data warehouse. A. Value chain B. Fact tables C. Triggers D. Bus
D. Bus
1. Who sits at the center of your DW/BI universe? A. Sponsors B. IT Personnel C. Business Stakeholders D. Business Users
D. Business Users
Which of the following capabilities is not needed for the data loading process A. Entire load process support B. Load Optimization C. Support for multiple targets - load process should support variance in different data in multiple targets D. Collecting info about the entire load process
D. Collecting info about the entire load process
Q2. When defining levels of detail, in terms of business requirements what should be avoided? A. End-User Needs B. Technical Foundation C. Capital constraints D. Creating a perfect plan to address every possible aspect
D. Creating a perfect plan to address every possible aspect
Which one of these is NOT a service level metrics? A. Data Timeliness B. Data Warehouse responsiveness C. Support Responsiveness D. Data Quantity
D. Data Quantity
2. With all the steps planned and executed in Kimball Lifecycle, 70% of risk and effort in the DW/BI projects comes from which of the following steps? A. Dimensional Modeling B. Physical Design C. Product Selection and Installation D. ETL Design and Development
D. ETL Design and Development
1. Which of the following high-level tasks required for effective DW/BI design is not depicted by the lifecycle diagram? A. Design B. Development C. Deployment D. Investment & Cost
D. Investment & Cost
Each of the organization's business processes can be represented by a dimensional model that consists of a fact table containing the numeric measurements surrounded by a halo of dimension tables containing the textual context. This characteristic star-like structure is often called a star _____ A. Schema B. Cube C. Dimension D. Join
D. Join
Q1. _______ is known as all the information that defines and describes the structures, operations, and contents of the DW/BI system: A. Semantic Library B. Reporting Library C. Back Room Architecture D. Metadata
D. Metadata
Which of the following does NOT belongs to data track of the lifecycle approach: A. Dimensional modeling B. Physical design C. Data staging design and development D. Production selection and installation
D. Production selection and installation
1. The first step of Kimball Lifecycle is _________________. A.Program/Project Management B.Business Requirements Definition C.Technical Architecture Design D. Program/ Project Planning
D. Program/ Project Planning
Which one of the following is NOT one of the overall ETL system requirements? A. Productivity Support B. Usability C. Metadata driven D. Project Proposal
D. Project Proposal
Which is NOT an activity during project management lifecycle A. Monitor Project Status B. Change Control C. Issue Tracking D. Purchase Software package
D. Purchase Software package
Which one is not included in the service level metrics to determine the project's success criteria. Availability Data quantity Data timeliness Data warehouse responsiveness Support responsiveness
Data quantity
Attributes of which following characteristics can ensure the quality of the overall data warehouse? A. Highly descriptive B. Complete C. Indexed D. Equally Available E. All of the above
E. All of the above
What is not part of the application architecture plan? A. Form an architecture task force B. Gather architecture-related requirements C. Create a draft architectural implications document D. Create the architecture model E. Develop software selection
E. Develop software selection
Maintaining project ownership and development based on business requirements, are two concerns when dealing with ____________? External Consultants Information Security Project Sponsors All of the above
Information Security
The goal of the program data audit interview is to: a) assess whether the data exists to support the themes you are hearing from the business interviews b) create ad hoc reports that support business decisions across the organization c) get an overall understanding of the organization d) none of the above
a) assess whether the data exists to support the themes you are hearing from the business interviews
What is the goal of BI applications? a) to deliver capabilities that are accepted by business to support and enhance their decision making b) Transform data into dimensional models c) Increase revenue d) Create a competitive advantage for the organization
a) to deliver capabilities that are accepted by business to support and enhance their decision making
Chapter 4 Question: Of the benefits of a sound DW/BI technical architecture, which help educate management about the magnitude and complexity of the system? a. Communication b. Planning c. Flexibility d. Greater likelihood to satisfy business requirements
a. Communication
2. What is one of the five reasons to include usage monitoring capabilities in the front room architecture? a. Compliance b. Scale Up c. Aggregate navigation d. Query Management
a. Compliance
What is conformed dimension? a. Dimension that means the same thing to every fact table it is joined to. b. Dimension that are all the same length. c. Dimension that are all the same data type. d. Dimension are all related.
a. Dimension that means the same thing to every fact table it is joined to.
1) When gathering architecture related requirements, you need to understand the existing technical environment to: a. Identify elements you can leverage and any limitations or boundaries the environment may impose. b. Determine if the project should be halted because the current technical environment is not sufficient to support the project. c. Determine what additional hardware needs to be purchased for the project to be successful.
a. Identify elements you can leverage and any limitations or boundaries the environment may impose.
Which of the following is true about fact tables in dimensional modeling? a. Measures of the business are typically numerical b. Hold small volumes of data c. Never contains composite primary key d. use primary key links to dimension tables.
a. Measures of the business are typically numerical
1. Fill in the Blank: "Business Dimensional Lifecycle ensures that the project pieces are brought together in the right ______ and at the right _____." a. Order, Time b. State, Order c. Priority, Time d. Order, State
a. Order, Time
The simplest version of a query governing service lets you a. Place a limit on the number of minutes a query can run or rows it can return b. Check if a user has permission to run a long query c. Ask if the user wants to schedule it for later d. Tell the user to reformulate their query
a. Place a limit on the number of minutes a query can run or rows it can return
2. When dealing with miscellaneous flags and text attributes that don't belong in any existing dimension tables, which of the following is NOT one of the bad alternatives the designers should avoid? a. Place them into one or more junk dimensions b. Leave them in the fact table c. Make them into separate dimensions d. Eliminate them
a. Place them into one or more junk dimensions
2. Which of the following is a primary responsibility of a project manager? a. Prepare project plan b. Establish enterprise data stewardship c. Establish program best practices d. Ongoing program management
a. Prepare project plan
1. The DW/BI project scope should be _________, yet manageable. a. meaningful b. valuable c. deliverable d. doable
a. meaningful
2. The three fundamental fact table grains are: a. transactions, periodic snapshots, accumulating snapshots b. transactions, supplemental snapshots, real-time snapshots c. transactions, detailed snapshots, point-in-time snapshots d. transactions, real-time snapshots, periodic snapshots
a. transactions, periodic snapshots, accumulating snapshots
1.) Which user is typically fatal to a DW/BI initiative because they assume they know what the business user's need in a data warehouse? a.) Nonexistent User b.) Overzealous User c.) Overbooked User d.) Comatose User
a.) Nonexistent User
1. There are five main areas to cover in the infrastructure map: server hardware, disk subsystems, network, security, and desktop. What does the 'desktop' area cover? a) Mapping the locations of where each user's desktop will be. b) Detailed requirements of data access applications, such as processing power, network connectivity, and drivers. c) A summary of possible security risk presented by users using their home desktops. d) A cost/benefit analysis of using a "thin" client solution.
b) Detailed requirements of data access applications, such as processing power, network connectivity, and drivers.
One of the principles of rapid application development is to make your software from scratch to avoid the reuse of softwares that might be flawed as your job is to redo previous work to avoid future problems. a) TRUE b) FALSE
b) FALSE
Ch 3: The ________ matrix has rows that represent each business process and columns that represent major organizations and workgroups involved in the requirements process. a) Business Unit b) Opportunity c) Bus d) Data Warehouse Answer: b) Opportunity
b) Opportunity
In small group interviews, no more than __ people should be interviewed at once, representing no more than two organizational levels a. 2 b. 4 c. 6 d. 8
b. 4
1. To manage a well-meaning, but overly aggressive business sponsor, IT needs to gently lay down a guideline that each new major data source adds ______ months to the development time of the DW/BI effort: a. 3 b. 6 c. 9 d. 12
b. 6
When staffing a project, who is not part of the Front Office? a. Business Sponsor b. Business Analyst c. Program Manager d. BI Director
b. Business Analyst
1. Which Readiness factor is most heavily weighted? a. Feasibility b. Business Sponsorship c. Business Motivation
b. Business Sponsorship
2. Users who respond to your classic open-ended questions with monosyllabic, one-word responses are referred to as ................... a. Overbooked user b. Comatose user c. Overzealous user d. Nonexistent user
b. Comatose user
2. Fact tables always have one or more _______ dimensions. a. Specific b. Date c. Text d. Unstructured
b. Date
2.) Which of the following is a fable caused by premature summarization? a. When you pre-summarize information, you've presupposed the business question, but atomic data are independent of the business question. b. Dimensional models are only appropriate when there is a predictable pattern of usage. c. A single dimensional model based on the most atomic data is capable of answering all possible questions against the data. d. Dimensional star schemas are extremely scalable.
b. Dimensional models are only appropriate when there is a predictable pattern of usage.
2. The industry sometimes refers to 3NF models as ___________. a. dimensional models b. ER models c. normal form models. d. data relationships.
b. ER models
2. What is the goal of an ER model? a. Create redundancies and abnormalize data b. Eliminate redundancies and normalize data c. Create a high level view of the database. d. Eliminate an overly complicates Database Strcuture.
b. Eliminate redundancies and normalize data
1. Which of the below items is not part of the process flow for the application architecture portion of the DW/BI architecture? a. Architecture Implications and Architecture Model b. Enterprise Bus Matrix c. Subsystem Detailed Models and Specs d. Product Selection
b. Enterprise Bus Matrix
2. The ________________ systems are typically made up of dozens of modules that cover major functional areas of the business such a human resource, manufacturing, etc. a. Source systems b. Enterprise resource planning systems (ERP) c. Customer relationship management d. None of the above
b. Enterprise resource planning systems (ERP)
2. The primary method for managing expectations about the DW/BI initiative throughout the organization is? a. Sending weekly status emails to executive team b. Executing the communications plan c. Clearly defined and documented initial expectations d. Daily status calls
b. Executing the communications plan
2. ETL stands for: a. Extract, Translate, Load b. Extract, Transform, Load c. Extract, Transfer, Load d. None of the above
b. Extract, Transform, Load
2) Fact tables should contain the a. Highest, least detailed atomic grain captured by a business process b. Lowest, most detailed atomic grain captured by a business process c. Highest, most detailed atomic grain captured by a business process d. Lowest, least detailed atomic grain captured by a business process
b. Lowest, most detailed atomic grain captured by a business process
Chapter 5 Question: When appointing a Metadata Manager, what skills can be considered the most essential for success when they are working alone? a. planning skills b. SQL and DBA skills c. interview skills d. drawing skills
b. SQL and DBA skills (Correct)
1. Which is NOT a step to secure hardware and operating system in DW/BW systems? a. Restrict login access b. Simplify your processes c. Restrict network access d. Keep up to date with security patches for OS
b. Simplify your processes
1. Once the DW/BI systems is in production, technical operational tasks are necessary to keep the system performing optimally, including usage monitoring, performance turning, index maintenance, and a. Hardware upgrades b. System backup c. Software upgrades d. Server reboots
b. System backup
Which of the following is the purpose of the infrastructure plan? a. Describe the types of users and different access requirements b. To communicate infrastructure requirements to the operational groups in IS c. Decide whether your staging area will live on the source system d. Selecting specific products that can bring your architecture to life.
b. To communicate infrastructure requirements to the operational groups in IS
1. According to the Kimball Group, the data warehouse is the foundation for _____________ ? a. the enterprise data warehouse. b. business intelligence. c. data warehouse/business intelligence (DW/BI) system. d. the queryable data.
b. business intelligence.
1. Which of the following is not an advantage to using interviewing as the technique for gathering requirements? a. Takes a limited amount of time b. cost c. easy to coordinate d. high degree of participation
b. cost
1. The Kimball Lifecycle is: a. the best choice for all projects b. customizable c. prescriptive d. mandated
b. customizable
The document that explains a project's focus, business requirements, objectives, approach, anticipated data, target users, stakeholders, success criteria, assumptions, and risks is called the ____________. a. project plan b. project charter c. project description d. Kimball plan
b. project charter
Which of the following is true about metadata driven? a. Metadata cannot provide flexibility b.Having a single source for metadata within the data warehouse is crucial c. Metadata cannot drive the warehouse d. Metadata catalog does not hold the mapping information
b.Having a single source for metadata within the data warehouse is crucial
Which of the following does NOT fall under the four-step dimensional design process: a) Identify the Dimensions b) Identify the Facts c) Identify the Dependencies d) Choose the Business Process
c) Identify the Dependencies
To perform data profiling to determine the content, consistency and structure of data which of the following queries could be used: a) SELECT FROM b) INSERT INTO c) SELECT DISTINCT d) DEFINE
c) SELECT DISTINCT
The DBMS platform(s) to consider in your architecture are: a) relational engine b) OLAP engine c) both a and b d) none of the above
c) both a and b
2. How many key factors are needed to establish the foundation to ensure a successful data warehouse? a. 3 b. 4 c. 5 d. 6
c. 5
1. Which of the following is NOT a step in the process of evaluating and selecting new DW/BI Products? a. Develop the Product Evaluation Matrix b. Conduct Market Research c. Contact vendors to let them know that there is budget money d. Narrow Your Options to a Short List
c. Contact vendors to let them know that there is budget money
2. What is not a tenant of rapid application development that doesn't align with the Kimball method a. Adapt quickly to evolving requirements b. Focus on delivering business value c. Create a well documented and regimented project plan d. Value collaboration between the development team and stakeholders
c. Create a well documented and regimented project plan
2. Which of the below is not a myth/fable about dimensional modeling? a. DM will lead to stovepiped decision support systems b. No one understands DM c. DM should not be departmentally bound d. Snowflaking is an alternative to DM
c. DM should not be departmentally bound
Which of the following is NOT necessary for a project manager? a. Strong communication skills b. Organizational and leadership skills c. Database administration d. Knowledge of IT and business organization
c. Database administration
1. ________________is a logical design technique for structuring data so that it's intuitive to business users and delivers fast query performance. a. Normalized Modeling b. Modeling Primer c. Dimensional modeling d. Table Granularity
c. Dimensional modeling
1. What is the organization/workgroup that is not involved in the requirements process for Underwriting Transactions? a. Underwriting & Actuarial b. Marketing & Sales c. Finance d. Customer Service
c. Finance
1. Which of the below methods for collecting requirements IS one of the recommended approaches? a. Sending out surveys or questionnaires b. Analyzing existing reports c. Holding facilitated discussions d. Asking users to fill out a checklist of data elements that need to be included
c. Holding facilitated discussions
Chapter 3 Question: Which is NOT one of the required roles for an interview team? a. Lead Interviewer b. Observer c. IT/Security Interviewee d. Scribe
c. IT/Security Interviewee
1. Which of the following is NOT one of the general directives given by Kimball to secure a data warehouse? a. Restrict network access b. Keep security patches for operating system up to date c. Implement multifactor authentication d. Ensure that data directories and database files are secure
c. Implement multifactor authentication (answer)
1. One of the key things that a lead interviewer should do for a successful interview is: a. Use a lot of jargon to show knowledge of the company and processes. b. . Schedule about a half hour per interviewee to allow for sufficient time for the interview. c. Maintain interview schedule flexibility. d. Allow interviewees to invite coworkers to the interview.
c. Maintain interview schedule flexibility.
Which is NOT recommended information to track for a project plan? a. % Complete b. Late Days c. Precedents d. Original Estimated Effort
c. Precedents
2. Which of the following is NOT a key deliverable for program/project planning and management: a. Scope and charter b. Communication plan c. Purchase orders and invoices d. Change control logs
c. Purchase orders and invoices
1. Which step is NOT part of developing an application architecture plan? a. Create the architecture model b. Form an architecture task force c. Select the products d. Review the draft
c. Select the products
1. Which of the following is not one of the three main areas to cover in the infrastructure plan? a. Server hardware b. Network c. Staffing d. Desktop
c. Staffing
When evaluate combined readiness factors, which one of following is weighted most important? a. Culture Feasibility b. IS/Business Partnership c. Strong Business Management Sponsor d. Compelling Business Motivation
c. Strong Business Management Sponsor
1.) What is not a backroom question posed by a DW/BI system's application architecture using a top-down approach? a. What is the specific content of each data store? b. What products provide the needed capabilities and how will we hook them together? c. What are our major business opportunities? d. How will we get the data needed to address our major business opportunities?
c. What are our major business opportunities?
What is the final step in wrapping up an interview? a. say goodbye b. ask the interviewee for feedback c. determine the success criteria d. check the time
c. determine the success criteria
What does ETL stand for? a. entire, transformation, library b. entire, transaction, load c. extract, transformation, load d. extract, transfer, level
c. extract, transformation, load
1.) What are dimensional models that can be stored in online analytic processing(OLAP) databases referred to as? a.) star schema b.) conformed dimensions c.) cubes d.) triangular schema
c.) cubes
Ch 4: _______ metadata describes the contents of the data warehouse in user-accessible terms, describing what data is available, where it comes from, what it means, and what its relationship is to other data in the warehouse. a) Process b) Technical c) ETL d) Business
d) Business
Which of the following is NOT a tangible benefit of a DW/BI system?a) Increased revenue from new sales to new customers b) Reduced fraudulent claim expense c) Reduced defect rates d) Faster response to changing conditions
d) Faster response to changing conditions
2. What is an example of a semi-additive measure? a) Unit Price b) Unit Cost c) Total Profit d) Inventory Levels
d) Inventory Levels
Which of the following statements is NOT true: a) The project manager and business project lead drive the project definition activities, with heavy involvement from both the business and IT sponsors b) Ongoing project management responsibilities rest primarily on the shoulders of the project manager, with assistance from the business project lead c) Project planning is also guided by the project manager and business project lead, with active participation and input from all other team members d) The business sponsor(s) is typically responsible for major project tasks including prioritization, issue resolution and organizational change management
d) The business sponsor(s) is typically responsible for major project tasks including prioritization, issue resolution and organizational
The delivery subsytems in the ETL back room consist of: a) Surrogate key generator b) Fact table builders c) OLAP cube builder d) all of the above
d) all of the above
Which of the following concepts does successful data warehousing depend on: a) focus on the business b) dimensionally structured the data that's delivered to the business via ad hoc queries or reports c) iteratively develop the overall data warehouse environment in manageable lifecycle increments rather than attempting a galactic Big Bang d) all of the above
d) all of the above
Project requirement gathering DOCUMENTATION phase involves finding related to a)Data model b)BI reports C)Technical architecture d)All of the above
d)All of the above
1. What is not a potential drawback of of a proof-of-concept from the DW/BI Team to the business community? a. Proof of concepts are typically built in a matter of day or weeks so it can distort management's perspective why it can take weeks to months to deliver DW/BI system b. Expectations need to be managed that a demo system is not suddently moved into production c. Business motivations are more important than experimenting with new technologies d. A proof of concept may provide the business sponor some clarity of the potential business value of a BI system
d. A proof of concept may provide the business sponor some clarity of the potential business value of a BI system
The process of conducting the interview include: a. Verify Communications b. Define Terminology c. Establish Peer Basis d. All of above.
d. All of above.
1. What are some of the additional costs for enhancement and growth assuming the project was successful? a. Ongoing maintenance expenses b. Ongoing support c. Expenses to support growth d. All of the above
d. All of the above
1. What are some of the general interviewing ground rules? a. Verify communications b. Remember your Interview role c. Maintain Interview schedule flexibility d. All of the above
d. All of the above
1. What is a data staging area? a. Where added value of the DW is created b. Where Conformed dimensions are created c. Where data transformation, such as converting keys, takes place d. All of the above
d. All of the above
1. Which of the following components are necessary to develop a meaningful test suite? a. Simple/Complex functionality b. Low/High data volume c. Single/Multi-user d. All of the above
d. All of the above
2. Technical Architecture consists of which major pieces below: a. Data Architecture b. Application Architecture c. Infrastructure d. All of the above
d. All of the above
2. What are the benefits of dimensional modeling compared to normalized modeling? a. Improved query performance b. Easily extensible when new data is added. c. Greater understandability for business users d. All of the above
d. All of the above (Answer)
2. Benefits of a sound DW/BI technical architecture DOES NOT include: a. Greater likelihood of satisfying business requirements b. Communication c. Planning d. Improved Collaboration
d. Improved Collaboration
Q: A single integrated repository for a DW/BI system is valuable in several ways. What is not a primary value of metadata integration a. Impact Analysis b. Audit and Documentation c. Metadata Quality and Management d. Increased front-end performance
d. Increased front-end performance
2. Which of the following users is NOT an example of a challenging interviewee: a. Abused User b. Overzealous User c. Overbooked User d. Power User
d. Power User
1. Which of the following is not one of the 5 key factors to ensure a successful data warehouse? a. Strong Business management sponsors b. compelling business motivation c. feasibility d. analyst in every department
d. analyst in every department
Q: What is not a major query management service you will likely want in your BI/DW architecture? a. query reformulation b. query retargeting and drill across c. aggregate navigation d. query reporting
d. query reporting
2.) Which of the following is not a category of metadata for technical architecture? a.) Technical metadata b.) Business metadata c.) Process metadata d.) Linear metadata
d.) Linear metadata
2.) Which of the following is not a member of the regular lineup: core project team? a.) business analyst b.) metadata manager c.) data architect d.) project manager
d.) project manager