MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 15 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_CLUSTERING_REQUIRES_MERGING_APPROACH_??$ |
| A. | Partitional |
| B. | Hierarchical |
| C. | Naive Bayes |
| D. | None of the Mentioned |
| Answer» C. Naive Bayes | |
| 2. |
WHICH_OF_THE_FOLLOWING_IS_A_WINDOWS_FAILOVER_CLUSTER_QUORUM_MODE??$ |
| A. | Node Majority |
| B. | No Majority: Read Only |
| C. | File Read Majority |
| D. | None of the mentioned |
| Answer» B. No Majority: Read Only | |
| 3. |
K-means is not deterministic and it also consist of number of iterations.$ |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
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 | |
| 5. |
Which of the following function is used for k-means clustering ? |
| A. | k-means |
| B. | k-mean |
| C. | heatmap |
| D. | None of the Mentioned |
| Answer» B. k-mean | |
| 6. |
A Windows Failover Cluster can support up to _______ nodes? |
| A. | 12 |
| B. | 14 |
| C. | 16 |
| D. | 18 |
| Answer» D. 18 | |
| 7. |
Hierarchical clustering should be primarily used for exploration. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
Which of the the following operation requires to run SQL Server Setup on the node? |
| A. | Add |
| B. | Remove |
| C. | Update |
| D. | All of the mentioned |
| Answer» E. | |
| 9. |
Which of the following combination is incorrect ? |
| A. | Continuous – euclidean distance |
| B. | Continuous – correlation similarity |
| C. | Binary – manhattan distance |
| D. | None of the Mentioned |
| Answer» E. | |
| 10. |
Which of the following element is installed locally on each node of the FCI? |
| A. | WSFC Resource Group |
| B. | SQL Server Binaries |
| C. | Network Name |
| D. | Storage |
| Answer» C. Network Name | |
| 11. |
Which of the following is required by K-means clustering ? |
| A. | defined distance metric |
| B. | number of clusters |
| C. | initial guess as to cluster centroids |
| D. | all of the Mentioned |
| Answer» E. | |
| 12. |
The resources owned by WSFC node include: |
| A. | Destination address |
| B. | SQL Server Browser |
| C. | One file share resource, if the FILESTREAM feature is installed |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 13. |
Which of the following is finally produced by Hierarchical Clustering ? |
| A. | final estimate of cluster centroids |
| B. | tree showing how close things are to each other |
| C. | assignment of each point to clusters |
| D. | all of the Mentioned |
| Answer» C. assignment of each point to clusters | |
| 14. |
Benefits that SQL Server failover cluster instances provide: |
| A. | Protection at the instance level through redundancy |
| B. | Disaster recovery solution using a multi-subnet FCI |
| C. | Zero reconfiguration of applications and clients during failovers |
| D. | All of the mentioned |
| Answer» E. | |
| 15. |
Which of the following scenario prefers failover cluster instance over stand alone instance in SQL Server? |
| A. | High Confidentiality |
| B. | High Availability |
| C. | High Integrity |
| D. | None of the mentioned |
| Answer» C. High Integrity | |