Which two actions should you include in your design?
Your network includes Windows Server 2008 R2 Hyper-V servers. You are configuring the servers in a failover cluster that will host highly available virtual machines (HAVMs). You plan to manage the servers in the cluster by using Microsoft System Center Virtual Machine Manager (VMM) 2008 R2. You need to design a storage solution for the cluster that allows you to migrate virtual machines (VMs) into and out of the cluster by using SAN migration. Which two actions should you include in your design? (Each correct answer presents part of the solution. Choose two.)
What should you choose?
You are designing a Hyper-V solution. You plan to virtualize an application server. The application server requires failover clustering that uses shared storage. You need to choose the correct storage solution. What should you choose?
Which two actions should you perform?
Your environment includes a Windows Server 2008 R2 Hyper-V failover cluster and a single Windows Server 2008 R2 Hyper-V server. You are designing a migration strategy. You need to ensure that you can perform a SAN migration to move virtual machines (VMs) from the single server into the failover cluster. Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
What should you do to identify any missing nonclustered indexes. You want the existing structures remain intac
You are employed as a database administrator at Domain.com. Your duties at Domain.com include administrating a SQL Server 2005 database computer named Certkiller -DB04. None of the databases on Certkiller -DB04 contain any views. You want to tune a database named CK_Stats that is hosted on Certkiller -DB04. You to accomplish this task using the Database Engine Tuning Advisor (DTA). Certkiller -DB04 contains a workload file that is appropriate for DT
How can you achieve this goal to connect to Certkiller -DB01 to detect the problem?
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 is configured for SQL Server and Windows Authentication mode.
You make use of Windows Authentication; therefore you have sysadmin privileges on Certkiller -DB01. You have received several reports from clients who work with Certkiller -DB01 stating that all applications that use Certkiller -DB01 stopped responding. You have received instruction from the CIO to investigate this error.
You check in Task Manager and detects that the CPU usage is at 100 percent. You attempt to connect to Certkiller -DB01 by using SQL Server Management Studio. However, Certkiller -DB01 does not respond. You are required to connect to Certkiller -DB01 to detect the problem.
How can you achieve this goal? (Choose all that apply)
How can you retrieve data concerning a user who is currently logged in on the system?
Domain.com has employed you as a database administrator. Your duties at Domain.com encompass administrating a SQL Server computer named Certkiller -DB03.
You have received instruction from the CIO to retrieve data concerning a user who is currently logged in on the system. You create a function that returns scalar information about the activity time for a particular user. How can you accomplish this goal? (Choose all that apply)
What should you do next on Certkiller -SR02 to configure Certkiller -DB01 and Certkiller -DB02 as mirrored ser
You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server2003. The Domain.com network contains a single SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. The CK_Sales database is configured to use the full recovery model.
You want to provide zero down time and high availability for the CK_Sales database. You decide to add a new database server which will be named Certkiller -DB02 on the Domain.com network. You want to configure Certkiller -DB01 and Certkiller -DB02 as mirrored servers. You perform a full backup of the CK_Sales database on Certkiller -DB01.
What should you do next on Certkiller -SR02?
Which two article properties should you change to change the article properties so that all indexes of Certkil
Exhibit:
Domain.com has two SQL Server 2005 computers named SQL1 and SQL2. A database named DB1 is located on SQL1. DB1 contains a table named Certkiller 4. Certkiller 4 is replicated to a database named DB1Repl, which is located on SQL2. Full-Text Search is not being used. Users report that the queries they run against Certkiller 4 in DB1Repl are very slow. You investigate and discover that only the clustered index of Certkiller 4 is replicated. All other indexes in DB1Repl are missing. You examine the Certkiller 4 article properties. The current Certkiller 4 article properties are shown in the exhibit. You need to change the article properties so that all indexes of Certkiller 4 in DB1 are replicated when the subscription is reinitialized. Which two article properties should you change? (Each correct answer presents part of the solution. Choose two.)
Which two actions should you perform to modify the Transact-SQL statement?
Exhibit:
You use a SQL Server 2005 database that contains a table named Customers. The Customers table contains the columns displayed in the exhibit. You create a view named v_Customer by using the following Transact-SQL statement. CREATE VIEW v_CustomerASSELECT CustomerID, CompanyName, FirstName, LastName, PictureFROM Customers You want to create an index on the v_Customer view. Prior to creating the index, you need to modify the Transact-SQL statement. Which two actions should you perform? (Each correct answer presents part of the solution.Choose two.)
Which Transact-SQL batch should you use to ensure that the database is always in a consistent state?
Your data warehouse includes three separate SQL Server 2005 tables for storing customer data. Each table is used to horizontally partition data that is migrated from a SQL Server 2000 installation to SQL Server 2005. Data is partitioned as shown in the following table. Table nameStores customer surnamebeginning with letterCustomer1A C HCustomer2I C PCustomer3Q C Z The database does not allow customers to opt-out of e-mail marketing offers.
You need to add a new OptOutFlag column to each of the customer tables. You must ensure that this column is added to either all three customer tables or none of them. You must also ensure that the database is always in a consistent state.
exhibit Which Transact-SQL batch should you use?