Explore topic-wise MCQs in Mongodb.

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'
Discussion
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
Discussion
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
Discussion
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.
Discussion
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
Discussion
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.
Discussion
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
Discussion
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
Discussion
59.

Which of the following recovery models requires log backups?

A. Simple
B. Full
C. Bulk
D. All of the mentioned
Answer» C. Bulk
Discussion
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
Discussion
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
Discussion
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
Discussion
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
Discussion
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.
Discussion
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.
Discussion
66.

Creation of a Derived Hierarchy requires permission to ___________

A. System Administration
B. DQS
C. syschema
D. None of the mentioned
Answer» B. DQS
Discussion
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
Discussion
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
Discussion
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
Discussion
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
Discussion
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
Discussion
72.

Which of the following is especially important in Sharded Clusters ?

A. NSS
B. STP
C. NTP
D. SSD
Answer» B. STP
Discussion
73.

WiredTiger can compress collection data using either snappy or zlib compression library.

A. snappy
B. zip
C. lib
D. Kit
Answer» B. zip
Discussion
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
Discussion
75.

MongoDB requires a filesystem that supports ______ on directories.

A. fsynconce()
B. fsync()
C. sync()
D. all of the mentioned
Answer» C. sync()
Discussion
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
Discussion