DBA - Database Administration || with Accurate Answers 100%.

DBA correct answers Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases Hosting correct answers In-House Server Hosting Pros correct answers 1. Gives you physical control over your backup 2. Keeps critical data IN-HOUSE (no third parties) 3. Internet is not needed 4. Cost effective for small-mid sized companies In-House Server Hosting Cons correct answers 1. Requires a capital investment in hardware and infrastructure 2. Physical space needed 3. Data loss during disaster situations 4. No uptime or recovery guarantees Cloud Server Hosting Pros (For example: Apple Icloud) correct answers 1. No need for onsite hardware 2. Storage can be added as needed 3. Backup and restore can be done from anywhere 4. Back up can be done as regularly as 15-minute intervals (minimizes data loss in disaster situations) Cloud Server Hosting Cons correct answers 1. Limit to data that can be stores in the cloud 2. Internet going down 3. Full data recovery could be very time consuming Top Cloud Computing Providers correct answers Microsoft, Amazon, Google Microsoft Azure correct answers Microsoft Azure (formerly Windows Azure) is a cloud computing service created by Microsoft for building, testing, deploying, and managing applications and services through a global network of Microsoft-managed data centers. SQL Server correct answers SQL Server is Microsoft's relational database management system (RDBMS) with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. SQL Server correct answers The Per Core licensing option allows for unlimited users or devices to access SQL Server (both internally and externally).