MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

You want to run a MySQL database in an IaaS environment in which you’ll create new instances as quickly as possible. Should you use virtual machines or containers?

A	Use containers.
B	Use virtual machines.
C	Use either.
D	None of the above

Explanation:

Detailed explanation-1: -You want to run a MySQL database in an IaaS environment in which you’ll create new instances as quickly as possible. Should you use virtual machines or containers? Use containers.

Detailed explanation-2: -1 – Amazon Web Service (AWS) Amazon RDS – Amazon’s Relational Database Service runs on either Oracle, SQL or MySQL server instances. Amazon SimpleDB – This is primarily a schema-less database that is meant to handle smaller workloads.

Detailed explanation-3: -In Azure, you can have your SQL Server workloads running as a hosted service (PaaS), or a hosted infrastructure (IaaS) supporting the software layer, such as Software-as-a-Service (SaaS) or an application.

Detailed explanation-4: -Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

Detailed explanation-5: -The correct answer is 1-Additional database filegroups can be added via Transact-SQL statements.

There is 1 question to complete.