Clustering MCQ

Test your knowledge with important Clustering MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Clustering MCQs at Bissoy

• An exciting new feature in SQL Server 2014 is the support for the deployment of a Failover Cluster Instance (FCI) with ___________
  ক

  Cluster Shared Volumes (CSV)

  খ

  In memory database

  গ

  Column oriented database

  ঘ

  All of the mentioned
• Which of the following is a Windows Failover Cluster quorum mode?
  ক

  Node Majority

  খ

  No Majority: Read Only

  গ

  File Read Majority

  ঘ

  None of the mentioned
• A Windows Failover Cluster can support up to _______ nodes.
  ক

  12

  খ

  14

  গ

  16

  ঘ

  18
• Which of the following operation requires to run SQL Server Setup on the node?
  ক

  Add

  খ

  Remove

  গ

  Update

  ঘ

  All of the mentioned
• Which of the following element is installed locally on each node of the FCI?
  ক

  WSFC Resource Group

  খ

  SQL Server Binaries

  গ

  Network Name

  ঘ

  Storage
• The resources owned by WSFC node include ___________
  ক

  Destination address

  খ

  SQL Server Browser

  গ

  One file share resource, if the FILESTREAM feature is installed

  ঘ

  None of the mentioned
• Benefits that SQL Server failover cluster instances provide ____________
  ক

  Protection at the instance level through redundancy

  খ

  Disaster recovery solution using a multi-subnet FCI

  গ

  Zero reconfiguration of applications and clients during failovers

  ঘ

  All of the mentioned
• Which of the following scenario prefers failover cluster instance over stand alone instance in SQL Server?
  ক

  High Confidentiality

  খ

  High Availability

  গ

  High Integrity

  ঘ

  None of the mentioned
• K-means is not deterministic and it also consists of number of iterations.
  ক

  True

  খ

  False
• Which of the following clustering requires merging approach?
  ক

  Partitional

  খ

  Hierarchical

  গ

  Naive Bayes

  ঘ

  None of the mentioned
• Which of the following function is used for k-means clustering?
  ক

  k-means

  খ

  k-mean

  গ

  heatmap

  ঘ

  none of the mentioned
• Hierarchical clustering should be primarily used for exploration.
  ক

  True

  খ

  False
• Which of the following combination is incorrect?
  ক

  Continuous – euclidean distance

  খ

  Continuous – correlation similarity

  গ

  Binary – manhattan distance

  ঘ

  None of the mentioned
• Which of the following is required by K-means clustering?
  ক

  defined distance metric

  খ

  number of clusters

  গ

  initial guess as to cluster centroids

  ঘ

  all of the mentioned
• Which of the following is finally produced by Hierarchical Clustering?
  ক

  final estimate of cluster centroids

  খ

  tree showing how close things are to each other

  গ

  assignment of each point to clusters

  ঘ

  all of the mentioned
• Which of the following clustering type has characteristic shown in the below figure?
  ক

  Partitional

  খ

  Hierarchical

  গ

  Naive bayes

  ঘ

  None of the mentioned