MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 17 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which of the following document details the state and configuration of the replica set and statistics about its members? |
| A. | replSetGetStatus |
| B. | db.serverStatus() |
| C. | db.stats() |
| D. | none of the mentioned |
| Answer» E. | |
| 2. |
Which of the following command returns quickly and does not impact MongoDB performance? |
| A. | dbStats |
| B. | db.serverStatus() |
| C. | db.stats() |
| D. | none of the mentioned |
| Answer» C. db.stats() | |
| 3. |
The agent ships initial sync and oplog data over HTTPS back to ___________ |
| A. | Opscore Manager |
| B. | Ops Manager |
| C. | mongod |
| D. | None of the mentioned |
| Answer» C. mongod | |
| 4. |
Ops Manager maintains one _____ database for each backed-up replica set. |
| A. | mdump |
| B. | head |
| C. | tail |
| D. | all of the mentioned |
| Answer» C. tail | |
| 5. |
Ops Manager reads directly from the Backup Blockstore database and transfers files either through ___________ |
| A. | TCP |
| B. | HTTPS |
| C. | MMS |
| D. | All of the mentioned |
| Answer» C. MMS | |
| 6. |
_____________CONTAINS_DATA_FROM_ONLY_SOME_OF_THE_FILEGROUPS_IN_A_DATABASE.?$ |
| A. | copy-only backup |
| B. | database backup |
| C. | data backup |
| D. | partial |
| Answer» E. | |
| 7. |
__________ALLOWS_ONLY_ONE_AGENT_OF_EACH_TYPE_PER_MACHINE_AND_WILL_REMOVE_ADDITIONAL_AGENTS.?$ |
| A. | Automation |
| B. | Performance |
| C. | Monitoring |
| D. | Backup |
| Answer» B. Performance | |
| 8. |
Which of the following backups contain transaction logs ? |
| A. | copy-only backup |
| B. | database backup |
| C. | data backup |
| D. | None of the mentioned |
| Answer» E. | |
| 9. |
_________ backups represent the whole database at the time the backup finished? |
| A. | copy-only backup |
| B. | database backup |
| C. | data backup |
| D. | All of the mentioned |
| Answer» C. data backup | |
| 10. |
Backup can also create snapshots of _________ that are run as single-member replica sets. |
| A. | documents |
| B. | standalones |
| C. | backups |
| D. | none of the mentioned |
| Answer» C. backups | |
| 11. |
Which of the following is not a type of backup ? |
| A. | database backup |
| B. | data backup |
| C. | table backup |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 12. |
Backup can occur while the database is in ___________ state. |
| A. | Online |
| B. | Offline |
| C. | Restoring |
| D. | All of the mentioned |
| Answer» B. Offline | |
| 13. |
The agent ships initial sync and oplog data over HTTPS back to: |
| A. | Opscore Manager |
| B. | Ops Manager |
| C. | mongod |
| D. | None of the mentioned |
| Answer» C. mongod | |
| 14. |
Features provided by SQL Server backups include : |
| A. | Wire compression of data for optimal backup and restore time |
| B. | Supports full and transaction log style backups |
| C. | Backup of MS SQL Server databases without interrupting running MS SQL Server services |
| D. | All of the mentioned |
| Answer» E. | |
| 15. |
Ops Manager maintains one _____ database for each backed-up replica set |
| A. | mdump |
| B. | head |
| C. | tail |
| D. | all of the mentioned |
| Answer» C. tail | |
| 16. |
How many types of backups are provided by SQL Server ? |
| A. | 5 |
| B. | 6 |
| C. | 7 |
| D. | 8 |
| Answer» E. | |
| 17. |
Backing up your SQL Server database is essential for _______ your data. |
| A. | protecting |
| B. | preventing |
| C. | replication |
| D. | None of the mentioned |
| Answer» B. preventing | |