Data Centric Testing Questions and Answers

Data Centric Testing | Testing | Mock Test

1
Granularity refers to
a. The level of detail of the data stored in a data warehouse.
b. The level of detail of the data descriptions held in a data warehouse
c. The number of fact tables in a data warehouse
d. The number of dimensions in a data warehouse

Answer : The level of detail of the data stored in a data warehouse.

2
Hierarchical databases are good at
a. enableing the user to develop ad hoc queries
b. analysing highly consolidated data over time
c. Structuring data
d. processing a relatively small set of pre-defined queries from a large data set
Answer : processing a relatively small set of pre-defined queries from a large data set

3
Reconciled data is which of the following?
a. Data stored in the various operational systems throughout the organization.
b. Current data intended to be the single source for all decision support systems.
c. Data stored in one operational system in the organization.
d. Data that has been selected and formatted for end-user support applications.
Answer : Current data intended to be the single source for all decision support systems.

4
The extract process is which of the following?
a. Capturing all of the data contained in various operational systems
b. Capturing a subset of the data contained in various operational systems
c. Capturing all of the data contained in various decision support systems
d. Capturing a subset of the data contained in various decision support systems
Answer : Capturing a subset of the data contained in various operational systems

5
Availability of Mapping and Transformation document will be the entry criteria for which phase of data migration
a. Analysis
b. Design
c. Testing
d. Post Implementation
Answer : Testing

6
Basic problems faced by IT Teams which doing Test Strategy are?
a. Shortage of Budget
b. Reduced cycle times
c. Browser compatibility
d. Only A and B
Answer : Only A and B

7
Components which are not part of BIDW Test Strategy
a. Risks and Mitigation plan
b. Post Implementation
c. Entry and Exit criteria for all phases of testing
d. Assumptions, Dependencies and Constraints
Answer : Post Implementation

8
Critical Business Bugs, response time, availability, User friendliness, performance/load issues, Multilingual,browser compatibility are present under _________________in Test Strategy
a. General Scope and Objective
b. Test Approach
c. Test Deliverables
d. Business Issues
Answer : Business Issues

9
PDM Tool capabilities doesnot include
a. Version Control
b. Change Detection
c. Audit Trail
d. Locking Mechanisms
Answer : Locking Mechanisms

10
<TOPIC>Logical and Physical Data Model</TOPIC>
Physical data model includes
a. Maps or transforms the conceptualschema
b. Only the business requirements within the scope of the project
c. Representation of the information requirements of a business area
d. database properties for the physical implementation of databases
Answer : database properties for the physical implementation of databases