Data Migration – Database Questions & Answers
1) Assessment of Data Migration viability means
a. Assessment of Timelines
b. Assessment of Tools/Technology
c. Assessment of Legacy Sources/Risks/Mitigation
d. All of the above
2) Data migratability assessment means
a. Assessment of fitment of legacy data to target model
b. Assessment of legacy data to staging landing structure
c. Validation of legacy data with lookup tables
d. None of the above
3) From Migration point of View, Data profiling is
a. Fixing the data anomalies
b. Quantifying the data anomalies
c. Finalizing the business rules for conversion
d. None of the above
4) Data migration is a process involving key stakeholders from
a. Business Process
b. Information Technology
c. Source/Target Data Owners
d. All of the above
5) The role of Data Migration Architect is to
a. Prepare Data Migration Strategy
b. Review Technical Specifications/Notify errors/resolution
c. Data modeling & staging area architecture
d. All of the above
6) Inability to involve the business in this activity from the beginning may severely end up in initial hiccups/delays in data migration pipeline
a. Formal agreement from the relevant corporate security governance team on data access
b. Installation of ETL Tool
c. Creation of Staging Database
d. None of the above
7) Synchronization of three ingredients for a successful data migration result
a. People, Process and Technology
b. People, Tool and Testing
c. Process, Technology & Testing
d. None of the above
8) Configuration management is inherent process within data migration because
a. To track versioning of your migration code
b. To track versioning of your mapping specifications
c. To track versioning of your fallout information
d. All of the above
9) Challenge you will face while working with 3rd party managed legacy source system for
a. Understanding source data model
b. Aligning your data extraction tasks as per their time window
c. Option A & B
d. None of the above
10) Before moving to design stage, the activities to be freezed are
a. High level source-target mapping specification, scoping report and volumetric
b. Conceptual and Logical data models
c. Risk register with indicative mitigation plan
d. All of the above
11) Type of data quality management solution, you can adopt
a. Cleanse in Source
b. Cleanse in Staging /In-flight using code logic
c. Cleanse on Target
d. All of the above
12) What is remediation process in data migration parlance?
a. Allowing exceptions to move to target system but with a careful codification for later track
b. Fixing exceptions with hard-coded pass value
c. Allowing exceptions to move to target system as-is
d. None of the above
13) UAT is a testing done by whom and where?
a. DM team in Dev environment
b. Business team in Dev environment
c. Business team in Pre-Prod environment
d. None of the above
14) Source-to-target specifications is a collaborative task by
a. Source/Target data owners in the presence of business and DM team
b. Target data owners in the presence of business
c. Source data owners in the presence of business and DM team
d. DM Team
15) Historical data migration requirements means
a. Moving inactive master data to target system
b. Moving past transactions i.e., 6 months, 1 year, etc to target system for business requirements/legal compliance
c. Moving only current data to target system
d. None of the above
16) Profiling results will give more insight to Source-To-Target mapping specifications
a. Yes
b. No
17) CDC in data migration parlance is
a. Preventing duplicates in target system
b. Identifying duplicates in source system
c. Change Data Capture, a concept of delta data loading or loading data incrementally to target system keeping track of changes in source system
d. None of the above
18) A critical testing, when heavy volumetric need to be migrated
a. Unit Testing
b. Performance Testing
c. Integration Testing
d. None of the above
19) Data Fallout layer is meant to expose information to business on
a. Exceptions arise while data conversion/validation
b. Passed records while data migration
c. Extraction errors while data migration
d. None of the above
20) Data migration is a
a. One-off activity triggered by business circumstances/upgrade circumstances
b. Perpetual activity asking for a continuous synchronization between legacy and target systems
c. One-off activity triggered by upgrade circumstances
d. None of the above
21) Which of the following is generally not a key element for processing data in migration projects
a. Data standardization
b. Data masking
c. Data loading
d. Data auditing
22) Which of the following is the process of collecting and capturing changes in the source applications?
a. Data acquisition
b. Data cleansing
c. Data auditing
d. Error handling
23) Which of the following is the process of merging the data between applications and preparation of a fully cross-application model?
a. Data subset
b. Harmonization
c. Data reference
d. Change data capture
24) The build phase of systems development includes:
a. Testing
b. Data Migration
c. Documentation.
d. All Of The Above
25) Unit testing
a. Involves ‘Black-Box’ Testing
b. Involves Volume Testing.
c. Involves Users.
d. None Of The Above
26) User acceptance testing typically occurs:
a. Before Systems Testing
b. At The Same Time As Systems Testing.
c. After Project Close Down Review.
d. Will Be The First Phase In Testing
27) Which of the following cannot be considered as data migration tool
a. Datastage
b. ODI
c. OWB
d. IDE
28) which of the following can be considered as best practice for data loading
a. Source-Stage And Stage-Warehouse
b. Source-Target
c. Source-Warehouse
d. Non Of The Above
29) which method is used to extract only frequency of changes that these source systems undergo
a. Change Data Capture
b. Cleansing
c. Migration
d. Archiving
30) which method should be used as early as in the etl migration projects as a best practice
a. Data Profiling
b. Data Loading
c. Data Storage
d. None Of The Above
31) which of the following improves performance for data load during migration process
a. Normal Load
b. Row By Row Load
c. Bulk Load
d. None Of The Above
32) which of the following is a open source etl tool used for migration
a. Talend
b. Abinitio
c. ODI
d. Golden Gate
33) The process of importing/extracting data from various source systems and loading into one target system is known as
a. Data Migration
b. Data Cleansing
c. Data Mining
d. Data Synchronization
34) In a ideal data migration scenario which of the following is not considered as part of migration
a. Data Extraction
b. Data Mapping
c. Reconciliation
d. Data Subset
35) Which of the following can be used to hold the data extracted from disparate sources for cleansing/standardization?
a. Staging
b. Target
c. Reporting Schema
d. Ods
36) Which of the following process can be part of data migration for analyzing the source data?
a. Profiling
b. Cleansing
c. Standardization
d. Loading
37) For which of the following generally migration can be considered as one time process
a. Olap
b. Legacy Data
c. Data Warehouse
d. None Of The Above
38) What percentage could be the most acceptable and feasible target for achieving cleansing and enrichment in large data migration projects?
a. 100%
b. 98%
c. 95%
d. 93%
39) Detailed migration strategy is defined usually
a. Before Initial assessment of quality of existing data
b. After Initial assessment of quality of existing data
c. Before enhancing the quality of existing data
d. After enhancing the quality of existing data
40) As per best practice, data cleansing activities should be started
a. At beginning of business blue print phase
b. At end of business blue print and before start of build phase
c. At the end of Build phase
d. During the cutover phase
41) As per best practice, what percentage of total data should be uploaded
a. 100% of masters and 100% transaction data
b. 100% of masters and 90% transaction data
c. 90% of masters and 100% transaction data
d. 90% of masters and 90% transaction data
42) Business user’s should be involved in data migration testing only during UAT phase? Select the most appropriate one
a. Yes, as implementation team can carry out the testing based on requirements gathered during requirement gathering phase
b. Yes, but testing results and learning of data loads during unit testing and SIT should be shared and discussed with business users
c. No. Business users should be involved during all testing cycles
d. No. Business users are not required for data testing even in UAT phase.
43) Cleansing of data by business users should be started only after build phase?
a. Yes, as it will ensure that changes in data will be minimal as requirement and development would be frozen by that time.
b. Yes, only in case of medium size projects where data objects are less than 30
c. Yes only for small size projects where no. of data objects are less than 10
d. no. It should always be started in between business blue print phase as it would give sufficient time for enhancing the quality of data.
44) Standard tools are not necessary for carrying out data migration activity for large data migration projects. It should be done by developing customer programs during the project execution phase. Select the most appropriate answer.
a. Yes, as standard tools requires lot of investment cost
b. Yes, as migration usually is one time activity and utility of tool post migration is very minimal.
c. No. Standard tools should be used as it comes with lot of prebuilt building blocks for faster execution of projects.
d. No. Standard tools should be used as it comes with lot of prebuilt building blocks for faster execution of projects and also post migration can be used for maintaining quality of data.
45) Data governance process should be implemented during migration phase of project for
a. Only for large size projects where number of data objects is more than 30
b. Both for medium and large size projects where number of data objects is more than 10
c. Only for small size projects where number of data objects is less than 10
d. For all migration projects irrespective of size of the projects
46) Dedicated team and special focus is not needed for carrying out data migration activities while ERP implementation? Select the most appropriate one
a. Yes, as it can be done by Functional and Technical team involved in implementation
b. Yes, as data ownership lies with business users hence data cleansing and accuracy will be taken care by them.
c. No, as data cleansing, standardization and enrichment is fulltime activity hence a separate dedicated team is required to carry out the migration activity.
d. No, as data cleansing, standardization and enrichment requires specialize skills and hence should be carried out by separate team.
47) Technical knowledge of data storage mechanism and data formats in legacy system is not required by data migration architect? Select the most appropriate one
a. Yes, only in cases where data extracts is responsibility of client team
b. Yes, only in cases where readymade data extract programs are available
c. No, it is required in all the cases as it helps in reconciling the extracts for its completeness and accuracy
d. No, it is required in all the cases as it helps not only in reconciling the extracts for its completeness and accuracy but also for better control of overall management of project
48) Technical knowledge of data storage mechanism and data model in new system is not required by data migration architect? Select the most appropriate one+C8
a. Yes, only in cases where data upload is responsibility of client team
b. Yes, only in cases where readymade data upload programs are available and reconciliation of uploaded data is clients responsibility
c. No, it is required in all the cases as it helps in reconciling the uploaded data for its completeness and accuracy
d. No, it is required in all the cases as it helps not only in reconciling the uploaded data for its completeness and accuracy but also for better control of overall management of project
49) One should carryout 100% data cleansing and enrichment activity in legacy system?
a. As, it will significantly reduce reconciliation effort
b. As, it will significantly reduce the effort of maintaining and carrying out cleansing activity in staging area
c. It should not be done at all as it involve huge risk of impacting the existing functionality of the system.
d. It should be done only to the extent where it do not impact the existing functionality of the system and in cases where effort of doing so in legacy is comparatively less.
50) Data migration testing and functional configuration testing should be carried out in different systems? Select the most appropriate one
a. As system functionality testing requires only sample data
b. This will help in removing dependency of functionality testing on data load
c. No, Functionality testing should be carried out only on system where data has been loaded as it will reduce risk of unforeseen issues during final cutover
d. No, Functionality testing should be carried out only on system where data has been loaded as it helps in testing of configuration, developments and data at same time and hence reduces the effort of testing.
51) For enhancement projects (adding new modules to existing system), where one time data migration is involved, latest production copy is not required for carrying out testing of data? Select the most appropriate one
a. Yes, as testing of enhanced functionality can be done on old data
b. It can be done in cases where functionality of new module is not dependent on availability of recent data
c. It can be done in cases where data to be migrated is not impacting the existing data
d. Its always good to have latest production copy for testing
52) For integration projects where one time data migration is required, latest production copy is not required for carrying out testing of data?
a. Yes, as integration testing can be done on sample data
b. It can be done in cases where integration testing is not dependent on availability of recent data
c. It can be done in cases where data to be migrated is not impacting other integrated systems
d. Its always good to have latest production copy for testing the integration components
53) Usually ownership of provision of data lies with
a. SI team
b. Legacy Administrator
c. Business Data Owners
d. Business end Users
54) Usually ownership of accuracy of data lies with
a. SI team
b. SI Team and Business Data Owners
c. Business Data Owners
d. Business Data Owners and Legacy Administrator
55) Difference between Data Migration and Data Conversion? Select the most accurate from below.
a. Data migration is changing from Legacy to New System. Conversion is changing of formats.
b. Data migration is upgrading the version of application e.g. Oracle 11i to Oracle 12i. Conversion is changing from one system to other system e.g. Legacy to Oracle Apps.
c. Data migration is changing from Legacy to New System or upgrading of the version. Conversion is subset of data migration and is changing of formats.
d. Data migration is integration of two systems. Conversion is subset of data migration and is changing of formats for smooth integration.
56) Identify the incorrect opportunity for Data Migration
a. Business transformation
b. Green field implementation
c. Application migrations/upgrades
d. None of these
57) Which one is a feature of Big-Bang migration
a. Less efforts
b. Synchronization between Legacy & Target
c. Multiple rollouts
d. None of these
58) Which one is a feature of Phased Migration
a. Less efforts
b. Single down time
c. Synchronization of Source & Target system
d. None of these
59) Identify the outcome of Data Profiling activity
a. Reconciliation reports
b. DQ Reports
c. Data Mapping
d. None of these
60) Which activity is primarily performed outside the staging area
a. Data Transformation
b. Data Cleansing
c. Target data loading
d. Data Profiling
61) Identify the main layer for generating Profiling reports
a. Source System
b. Target System
c. Staging Area
d. None of these
62) Which activity is generally covered during Mock runs
a. Data Profiling
b. Cut-over planning
c. Attribute & LoV mapping
d. Defining Migration strategy
63) UAT is recommended to be conducted during which dry run
a. 1st Dry Run
b. 2nd Dry Run
c. 3rd Dry Run
d. All of these
64) Legacy data Profiling Report primarily is a deliverable of –
a. Requirement and Data Quality Assessment Phase
b. Design Phase
c. CUT Phase
d. Testing Phase
65) Which is generally an activity of Requirement & Data Quality Assessment Phase
a. Data Profiling
b. Data Transformation
c. Attribute & LoV mapping
d. Defining Migration strategy
66) Which activity is generally covered during Design Phase
a. Data Profiling
b. Attribute & LoV mapping
c. UAT
d. Building Migration components
67) Identify activity which is covered during CUT Phase
a. Data Profiling
b. Attribute & LoV mapping
c. Migration component development
d. UAT
68) Default values for missing data should be mainly covered as part of –
a. Requirement analysis document
b. Transformation Rules document
c. Migration Strategy Document
d. Reconciliation report
69) Identify the most appropriate use case for data transformation
a. Missing data
b. Data in different format
c. Both A & B
d. None of these
70) Identify the issue which ideally can’t be fixed in staging area
a. Missing Functionality issue
b. Data quality issue
c. Datatype Conversion
d. Data Transformation issue
71) Migration Phasing can be decided based on –
a. Geography
b. Business requirements & application rollout strategy
c. Products & Services
d. All of these
72) Identify the transactional data object
a. Products
b. Orders
c. Customers
d. Vendors
73) Which is not the data migration best practice
a. Migrate complete legacy history into new target
b. Migrate all active transactions
c. Migrate master data
d. Data validation
74) Data transformation is generally achieved using:
a. DQ tool
b. ETL tool
c. Java
d. C++
75) Loadiing of data into SAP can be achieved using:
a. VB Script
b. EIM tool
c. LSMW tool
d. C++