MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 76 Mcqs, each offering curated multiple-choice questions to sharpen your Mongodb knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
Which of the following script can check the database recovery model by querying sys.databases for log shipping? |
| A. | SELECT name, recovery_model_desc FROM sys.databases WHERE name = 'jugal' |
| B. | SELECT name, recovery_model_desc FROM sys.databases WHERE name = 'jugal' |
| C. | SELECT name, recovery_model_desc FROM sys.databases WHERE name = 'jugal' |
| D. | None of the mentioned |
| Answer» B. SELECT name, recovery_model_desc FROM sys.databases WHERE name = 'jugal' | |
| 52. |
Purpose of syspolicy_system_health_state in policy based management is ______________ |
| A. | Displays one row for each Policy-Based Management policy |
| B. | Organize policies when you have many policies |
| C. | Displays the time when policies were executed, the result of each execution, and details about errors if any occurred |
| D. | None of the mentioned |
| Answer» B. Organize policies when you have many policies | |
| 53. |
Which of the following is policy based management tip related to administration? |
| A. | Evaluate and Implement Policies in Multiple SQL Server Instances |
| B. | Identify SQL Server Databases Not in Full Recovery Model |
| C. | SQL Server Policy Based Management Has Clustered Index Condition |
| D. | None of the mentioned |
| Answer» B. Identify SQL Server Databases Not in Full Recovery Model | |
| 54. |
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. | |
| 55. |
How many types of backups you can run when the data is in the “Full” recovery model? |
| A. | 5 |
| B. | 6 |
| C. | 7 |
| D. | All of the mentioned |
| Answer» C. 7 | |
| 56. |
Which of the following feature cannot be used in simple recovery mode? |
| A. | Media recovery without data loss |
| B. | Log shipping |
| C. | Database mirroring |
| D. | All of the mentioned |
| Answer» E. | |
| 57. |
Point out the correct statement related to database configuration. |
| A. | Enable Data File Growth for all the Databases Using Policy Based Management |
| B. | Monitor Your SQL Server Linked Server Configurations with Policy Based Management |
| C. | Configuring Alerts for SQL Server Policy Based Management |
| D. | None of the mentioned |
| Answer» B. Monitor Your SQL Server Linked Server Configurations with Policy Based Management | |
| 58. |
An exciting new feature in SQL Server 2014 is the support for the deployment of a Failover Cluster Instance (FCI) with ___________ |
| A. | Cluster Shared Volumes (CSV) |
| B. | In memory database |
| C. | Column oriented database |
| D. | All of the mentioned |
| Answer» B. In memory database | |
| 59. |
Which of the following recovery models requires log backups? |
| A. | Simple |
| B. | Full |
| C. | Bulk |
| D. | All of the mentioned |
| Answer» C. Bulk | |
| 60. |
Which of the following table stores history detail for log shipping jobs? |
| A. | log_shipping_monitor_alert |
| B. | log_shipping_monitor_primary |
| C. | log_shipping_monitor_history_detail |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 61. |
Execute sp_add_jobschedule to add a schedule for the backup job on _________ server. |
| A. | primary |
| B. | secondary |
| C. | primary and secondary |
| D. | none of the mentioned |
| Answer» B. secondary | |
| 62. |
Which of the following stored procedure is used to add a primary database on primary server? |
| A. | sp_add_log_shipping_primary_database |
| B. | sp_add_primary_database |
| C. | sp_add_log_shipping |
| D. | sp_add_log_shipping_primary |
| Answer» B. sp_add_primary_database | |
| 63. |
Which of the following action cannot be performed with MDS? |
| A. | Create entities |
| B. | Create attributes for your entities |
| C. | Export members for your supporting entities |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 64. |
Which of the following data tools comes installed with SQL Server 2012? |
| A. | SSAS |
| B. | SSRS |
| C. | DQS |
| D. | All of the mentioned |
| Answer» E. | |
| 65. |
Which of the following tools is used for enterprise information management? |
| A. | SSAS |
| B. | SSIS |
| C. | SSRS |
| D. | All of the mentioned |
| Answer» E. | |
| 66. |
Creation of a Derived Hierarchy requires permission to ___________ |
| A. | System Administration |
| B. | DQS |
| C. | syschema |
| D. | None of the mentioned |
| Answer» B. DQS | |
| 67. |
Which of the following SQL Server tools is used to enhance data management and governance? |
| A. | SSIT |
| B. | SSDT |
| C. | OBEII |
| D. | All of the mentioned |
| Answer» C. OBEII | |
| 68. |
Key component that help you build an EIM solution is ____________ |
| A. | SSRS |
| B. | SSAS |
| C. | SSIS |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 69. |
ON_LINUX,_USE_THE________COMMAND_TO_CHECK_IF_DISK_I/O_IS_A_BOTTLENECK_FOR_YOUR_DATABASE.?$ |
| A. | stat |
| B. | iostats |
| C. | iostat |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 70. |
______is_a_command-line_tool_for_monitoring_network_use.$ |
| A. | bwm-ng |
| B. | bwm-g |
| C. | bwm-n |
| D. | bwm-ngs |
| Answer» B. bwm-g | |
| 71. |
The TCP keepalive on the Azure load balancer is ______ seconds by default? |
| A. | 100 |
| B. | 200 |
| C. | 240 |
| D. | None of the mentioned |
| Answer» B. 200 | |
| 72. |
Which of the following is especially important in Sharded Clusters ? |
| A. | NSS |
| B. | STP |
| C. | NTP |
| D. | SSD |
| Answer» B. STP | |
| 73. |
WiredTiger can compress collection data using either snappy or zlib compression library. |
| A. | snappy |
| B. | zip |
| C. | lib |
| D. | Kit |
| Answer» B. zip | |
| 74. |
MongoDB Cloud Manager provides integration with Amazon Web Services (AWS) and lets you deploy new ______ instances directly from MongoDB Cloud Manager. |
| A. | ECS |
| B. | EC2 |
| C. | EC3 |
| D. | All of the mentioned |
| Answer» C. EC3 | |
| 75. |
MongoDB requires a filesystem that supports ______ on directories. |
| A. | fsynconce() |
| B. | fsync() |
| C. | sync() |
| D. | all of the mentioned |
| Answer» C. sync() | |
| 76. |
With the WiredTiger storage engine, use of _______ is strongly recommended to avoid performance issues |
| A. | XFS |
| B. | SSD |
| C. | SST |
| D. | All of the mentioned |
| Answer» B. SSD | |