COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Use a IaaS approach. Create a set of virtual machines to run your system, and connect them using a virtual network.
|
|
|
Use a PaaS approach. For example, run a PostgreSQL database using Azure Database for PostgreSQL
|
|
|
Use either
|
|
|
None of the above
|
Detailed explanation-1: -Q. You want to create a highly available database system that requires a minimum of administrative time to run. Should you use an IaaS or a PaaS approach? Use a IaaS approach.
Detailed explanation-2: -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-3: -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-4: -The correct answer is 1-Additional database filegroups can be added via Transact-SQL statements.
Detailed explanation-5: -Azure SQL or SQL Managed Instances are usually referred to as PaaS i.e. Platform as a Service, somewhere between IaaS (where you have access to the OS) and SaaS (where you only have access to the front-end). PaaS allows you access to the DB platform, without access to the underlying OS.