MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.

Which term best defines the process of transferring a database from on-premises to the cloud?
a. Data replication
b. Database migration
c. Load balancing
d. Caching
Answer: b. Database migrationcloud.google+1
What is a primary reason organizations migrate databases to the cloud?
a. Increased cost
b. Scalability
c. Decreased efficiency
d. Reduced automation
Answer: b. Scalabilityrivery+1
In cloud migration, what is “lift and shift” commonly referred to?
a. Rehosting
b. Refactoring
c. Retiring
d. Repurchasing
Answer: a. Rehostingestuary
Which component is essential for zero-downtime database migration?
a. Load testing
b. Database migration service
c. DHCP server
d. DNS server
Answer: b. Database migration servicecloud.google
Which migration strategy involves minimal changes to the application architecture?
a. Replatforming
b. Retiring
c. Refactoring
d. Rehosting
Answer: a. Replatformingestuary
Migrating from MySQL to Amazon Aurora is an example of what type of migration?
a. Homogeneous
b. Heterogeneous
c. Serverless
d. Legacy
Answer: a. Homogeneousaws.amazon+1
What service helps track progress of migrations in AWS?
a. EC2
b. S3
c. Migration Hub
d. Lambda
Answer: c. Migration Hubkoenig-solutions
What is the first phase in a phased database migration strategy?
a. Data migration
b. Cloud assessment
c. Proof of Concept
d. Optimization
Answer: c. Proof of Conceptwayground
What is a primary advantage of using cloud-native database solutions?
a. Manual backups
b. Elastic scalable storage
c. Physical tape storage
d. Inflexible compute
Answer: b. Elastic scalable storagewayground+1
Which Google Cloud tool can migrate databases with near-zero downtime?
a. Cloud Data Fusion
b. Compute Engine
c. Migration Hub
d. Lambda
Answer: a. Cloud Data Fusioncloud.google
What is a common benefit of refactoring a database for migration?
a. Minimal downtime
b. Optimization for cloud scalability
c. Incompatibility
d. Increased redundancy
Answer: b. Optimization for cloud scalabilityestuary
Migrating SQL Server databases to Azure most commonly uses which service?
a. Azure Migrate
b. Azure Blob Storage
c. Azure VPN
d. Azure Cosmos DB
Answer: a. Azure Migratetechtarget
What is a common challenge encountered in cloud migration?
a. Fast internet
b. Data security concerns
c. Unlimited resources
d. High redundancy
Answer: b. Data security concernsalation+1
What does the acronym ETL stand for in migration?
a. Encryption, Transmission, Loading
b. Extract, Transform, Load
c. Elastic, Transparent, Lightweight
d. Evaluate, Transfer, Lease
Answer: b. Extract, Transform, Loadmicrosoft
What process describes moving legacy systems to managed cloud databases?
a. Replatforming
b. Repurchasing
c. Retaining
d. Retiring
Answer: b. Repurchasingestuary
What AWS service simplifies migration of relational and NoSQL databases?
a. CloudFront
b. DMS
c. Athena
d. Redshift
Answer: b. DMS (Database Migration Service)aws.amazon
Which step in migration focuses on validating technology and reducing risk?
a. Final deployment
b. Proof of Concept
c. Performance benchmarking
d. Legacy software promotion
Answer: b. Proof of Conceptwayground
Change Data Capture is important in migrations because it:
a. Minimizes downtime
b. Increases manual updates
c. Deletes old databases
d. Inhibits automation
Answer: a. Minimizes downtimeestuary
Which service commonly helps migrate file servers to the cloud?
a. Lambda
b. CloudFront
c. Amazon S3
d. EC2
Answer: c. Amazon S3wayground
What is “homogeneous migration”?
a. Same source and target database engines
b. Different source and target database engines
c. Data at rest encryption only
d. No migration involved
Answer: a. Same source and target database enginesaws.amazon+1
What term describes rebuilding infrastructure from scratch for the cloud?
a. Rehosting
b. Retiring
c. Refactoring
d. Retaining
Answer: c. Refactoringestuary
What migration strategy deals with components incompatible with cloud platforms?
a. Retiring
b. Retaining
c. Rehosting
d. Repurchasing
Answer: b. Retainingestuary
Migrating data can help reduce which recurring responsibility for organizations?
a. Manual backups
b. Infrastructure management
c. Data redundancy
d. Elastic scaling
Answer: b. Infrastructure managementaws.amazon+1
What migration approach involves moving data with no transformation?
a. ETL
b. Lift-and-shift
c. Refactoring
d. Retaining
Answer: b. Lift-and-shiftcloud.google+1
In which step of migration should data integrity be verified?
a. Pre-migration
b. Post-migration
c. During migration
d. At all stages
Answer: d. At all stagesestuary
Which is NOT commonly migrated to the cloud?
a. Applications
b. Databases
c. Gaming experience
d. Storage
Answer: c. Gaming experiencewayground
The process of transferring data between multiple cloud providers is known as:
a. Repurchasing
b. Cloud migration
c. Compute sharding
d. Database refactoring
Answer: b. Cloud migrationgeeksforgeeks+1
Which is a core technical building block of database migration systems?
a. Network segmentation
b. Data migration process
c. Data archiving
d. Load balancing
Answer: b. Data migration processcloud.google
What feature of Estuary Flow helps with real-time migration?
a. Legacy software support
b. Real-time CDC (Change Data Capture)
c. Single-thread replication only
d. Manual data import
Answer: b. Real-time CDC (Change Data Capture)estuary
Which type of migration involves different platforms, such as Oracle to SQL Server?
a. Homogeneous migration
b. Heterogeneous migration
c. Manual migration
d. Hybrid migration
Answer: b. Heterogeneous migrationaws.amazon+1
What is the purpose of performance tuning during migration?
a. To minimize cost
b. To ensure data accessibility
c. To optimize database speed and reliability
d. To increase manual processing
Answer: c. To optimize database speed and reliabilityestuary
Real-time database replication in migration aims to:
a. Make data permanently unavailable
b. Guarantee accuracy and control
c. Increase downtime
d. Promote legacy systems
Answer: b. Guarantee accuracy and controlestuary
Cloud bursting refers to:
a. Cloud migration failure
b. Temporary renting of cloud capacity to handle spikes
c. Permanent infrastructure change
d. Non-scalable cloud
Answer: b. Temporary renting of cloud capacity to handle spikestestbook
In cloud migration, connectors in Estuary Flow provide:
a. Redundant services
b. Flexibility and integration
c. Security risks
d. Manual intervention
Answer: b. Flexibility and integrationestuary
What is a critical factor for live monitoring during migration?
a. DNS configuration
b. Integration with reporting tools
c. Lack of availability
d. Legacy compatibility
Answer: b. Integration with reporting toolsestuary
When should fallback architecture be set up?
a. After migration
b. Before migration
c. During migration
d. Never
Answer: b. Before migrationcloud.google
What is a common size for data volumes handled in professional database migration tools?
a. 100 MB
b. Up to 7GB/s
c. 1 TB
d. 56 KB
Answer: b. Up to 7GB/sestuary
Which migration system feature allows for structured unstructured data?
a. Basic replication
b. Data transformation
c. Legacy backups
d. Load testing
Answer: b. Data transformationestuary
The process of switching over client access from source to target databases is called:
a. Failback
b. Switchover
c. Forklift migration
d. Data archiving
Answer: b. Switchovercloud.google
Which migration strategy is most likely to require retraining users?
a. Refactoring
b. Repurchasing
c. Retiring
d. Retaining
Answer: b. Repurchasingestuary
What is a benefit of business case planning in cloud assessment?
a. Preventing software updates
b. Increasing manual processing
c. Justifying migration investment
d. Ensuring private cloud use only
Answer: c. Justifying migration investmentwayground
What provides high availability across regions in migration platforms?
a. DNS routing
b. Survival capabilities
c. Manual file transfer
d. Data segmentation
Answer: b. Survival capabilitiesestuary
Which migration phase allows technology validation before full deployment?
a. Final migration
b. Proof of Concept
c. Cloud assessment
d. Optimization
Answer: b. Proof of Conceptwayground
Data migration often involves what additional process?
a. Data conversion
b. Redundancy promotion
c. Legacy code
d. Infrastructure removal
Answer: a. Data conversionmicrosoft
In cloud database migration, what typically separates compute from storage?
a. On-premises database
b. Data warehouse solutions
c. File server
d. Application server
Answer: b. Data warehouse solutionsrivery
What tool allows real-time tracking of data migration status?
a. Reporting and monitoring tools
b. Load balancers
c. NAS storage
d. VPN servers
Answer: a. Reporting and monitoring toolsestuary
When assessing team skills for migration, organizations should:
a. Ignore knowledge gaps
b. Identify expertise and provide training
c. Outsource only
d. Avoid assessment
Answer: b. Identify expertise and provide trainingestuary
Which is an example of robust data replication for migration?
a. Offline transfer
b. Exact cloud copy of databases
c. Physical tape shipping
d. Partial sync
Answer: b. Exact cloud copy of databasesestuary
Which step helps minimize risk and validate migration feasibility?
a. Full migration
b. Proof of Concept phase
c. Retain phase
d. Manual code review
Answer: b. Proof of Concept phasewayground
What is a core goal of database migration to the cloud?
a. Decrease data accessibility
b. Improve scalability and efficiency
c. Reduce redundancy
d. Limit user access
Answer: b. Improve scalability and efficiencyalation+2

Blog

Systemethic Technologies

Leave a Reply Cancel reply

Useful links

Other Terms & Policies

Contact Info