when you want the data to be returned automatically in chronological order
if the application uses queries joining tables only occasionally
if the queries against the clustered table use the equality operator (=) to retrieve the desired row
if the full table scan is executed often on only one of the clustered tables
第1题:
A cluster administrator wants to create a snapshot backup of the cluster. Which smit menu can be used to dothis?()
第2题:
In which scenario will you create a sorted hash cluster? ()
第3题:
You are maintaining a database of credit card transactions. You want the data to be returned automatically in the chronological order of the credit card numbers without using the ORDER BY clause in the query. Which type of cluster will you use to obtain the desired result?()
第4题:
You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create?()
第5题:
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. On two cluster-ready nodes, you intend to perform an installation of a SQL Server 2008 mission-critical cluster. Constant availability is needed by the mission-critical cluster. You have to configure the SQL Server cluster to failover and reduce the service disruption to the least. Which failover option should you use?()
第6题:
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this, you must make sure that after it is completed successfully, the job is removed. What should you do? ()
第7题:
Certkiller .com boosts a two-node Network Load Balancing cluster which is called web. CK1 .com. The purpose of this cluster is to provide load balancing and high availability of the intranet website only. With monitoring the cluster, you discover that the users can view the Network Load Balancing cluster in their Network Neighborhood and they can use it to connect to various services by using the name web. CK1 .com. You also discover that there is only one port rule configured for Network Load Balancing cluster. You have to configure web. CK1 .com NLB cluster to accept HTTP traffic only. Which two actions should you perform to achieve this objective()
第8题:
Create a new rule for TCP port 80 by using the Network Load Balancing Cluster console
Run the wlbs disable command on the cluster nodes
Assign a unique port rule for NLB cluster by using the NLB Cluster console
Delete the default port rules through Network Load Balancing Cluster console
第9题:
when you want the data to be returned automatically in chronological order
if the application uses queries joining tables only occasionally
if the queries against the clustered table use the equality operator (=) to retrieve the desired row
if the full table scan is executed often on only one of the clustered tables
第10题:
In the properties for the cluster, create a new port rule for port TCP 443 that has the Filtering modeoption set to Single host.
In the properties for WEB2, the Handling priority option for the TCP 443 port rule should be changed tothe value of 1.
In the properties for WEB1, the Handling priority option for the TCP 443 port rule should be changed tothe value of 0.
In the properties for the cluster, create a new port rule for port TCP 443 that has the Filtering modeoption set to Multiple host and the Affinity option set to the value of Single.
第11题:
if the application uses queries joining tables only occasionally
if the full table scan is executed often on only one table of the clustered tables
if the data for all the rows of a cluster key value exceeds one or two Oracle blocks
when you want the data to be returned automatically in the chronological order
第12题:
resolve
indirect
next-hop
recursive
第13题:
How do you disable a server from Juniper DX Cluster without terminating active client requests? ()
第14题:
In which scenario will you create a hash cluster?()
第15题:
Which command do you use to create a recovery-catalog schema? ()
第16题:
You need to design a configuration for the mailbox servers. What should you do?()
第17题:
You need to design a configuration for the Microsoft Outlook Web Access servers. What should you do?()
第18题:
Your company has an Active Directory Domain Services (AD DS) domain. You have a Windows Server 2008 R2 Hyper-V server. You manage the virtual environment by using Microsoft System Center Virtual Machine Manager (VMM) 2008 R2. You need to ensure that a user can create new virtual machines (VMs) on only a specific set of servers . The user must not be able to see or manage servers outside of that set within VMM . Which two actions should you perform?()
第19题:
You should allow failback only during non-business hours
You should immediately allow failback
You should prevent automatic failback
You should allow failback only during business hours
第20题:
create a hash cluster to store the data
create an index cluster to store the data
create a partitioned table to store the data
create a sorted hash cluster to store the data
create a heap table with rowid to store the data
第21题:
In the properties for WEB2, change the Handling priority option for the TCP 443 port rule to the value of1.
In the properties for WEB1, change the Handling priority option for the TCP 443 port rule to the value of 0.
In the properties for the cluster, create a new port rule for port TCP 443 that has the Filtering mode option set to Single host.
In the properties for the cluster, create a new port rule for port TCP 443 that has the Filtering mode option set to Multiple host and the Affinity option set to the value of Single.
第22题:
create a hash cluster to store the data
create an index cluster to store the data
create a partitioned table to store the data
create a sorted hash cluster to store the data
create a heap table with rowid to store the data
第23题:
Hash cluster
Index cluster
Sorted hash cluster
Real Application cluster
第24题:
Index cluster
Hash cluster
Sorted Hash cluster
Real Application Cluster