What should you do?
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 on Windows Server2003 and all client computers run Windows XP Professional. The Domain.com network contains two SQL Server 2005 database servers that are configured in a cluster with two nodes named NodeA and NodeB. NodeA hosts a default database instance named MSSQLSERVR.
Domain.com wants to implement another SQL Server 2005 instance for a database named Sales_DB. Sales_DB will store sales data for the company. All Domain.com users will require access to the Sales_DB database. You have been instructed to create the SQL Server 2005 instance for the Sales_DB database on NodeA. You need to ensure that all users will be able to connect to the Sales_DB database.
What should you do?
What should you do?
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 on Windows Server2003 while the client computers run Windows XP Professional, Windows 98 Second Edition, and Novell NetWare 6.5. All computers are members of the Domain.com Active Directory domain. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that hosts a database instance named MSSQLSERVR. Domain.com wants to implement another SQL Server 2005 instance for a database named Sales_DB. Sales_DB will store sales data for the company. All Domain.com users will require access to the Sales_DB database. You have been instructed to create the SQL Server 2005 instance for the Sales_DB database. You need to ensure that all users will be able to connect to the Sales_DB database. You cannot make configuration changes to the client computers. Your solution must optimize network traffic.
What should you do?
What should you do during the installation of SQL Server 2005 on CERTKILLER-SR21?
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 Server 2003. The Domain.com network contains a Domain Controller named Certkiller -DC01 and a member server named Certkiller -SR21.
Domain.com wants to implement a SQL Server 2005 database that will store sales data. All Domain.com users will require access to the Sales_DB database. You have been instructed to install SQL Server 2005 on Certkiller -SR21 and to create a database named Sales_DB. You need to ensure that Domain.com users and applications can connect to the database instance by using only the computer name. What should you do during the installation of SQL Server 2005 on CERTKILLER-SR21?
What should you do next?
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 Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains two SQL Server 2000 database servers named Certkiller -DB01 and Certkiller -DB02 that are configured fro log shipping. Certkiller -DB01 is the primary server and hosts a database named CK_Trading. Both Certkiller -DB01 and Certkiller -DB02 have Service Pack 3 for SQL Server 2000 installed. Domain.com wants to upgrade Certkiller -DB01 and Certkiller -DB02 to SQL Server 2005 Enterprise Edition but the CK_Trading database must remain available during the upgrade process. You verify that both Certkiller -DB01 and Certkiller -DB02 exceed the recommended hardware requirements for SQL Server 2005 Enterprise Edition. You then install Service Pack 1 for Windows Server 2003 on Certkiller -DB01 and Certkiller -DB02.
What should you do next?
What should you do next?
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 2000 Server. The Domain.com network contains a SQL Server 7.0 database server named Certkiller -DB01 that runs on Windows 2000 Server. Service Pack 4 for Windows 2000 Server id installed on Certkiller -DB01.
Domain.com wants to migrate Certkiller -DB01 to SQL Server 2005. You decide to perform an in-place upgrade to SQL Server 2005. You verify that Certkiller -DB01 exceeds the recommended hardware requirements for SQL Server 2005.
What should you do next?
What should you do next?
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 2000 Server. The Domain.com network contains a SQL Server 2000 database server named Certkiller -DB01 that runs on Windows 2000 Server Service Pack 4. Certkiller -DB01 contains a database named CK_Trading.
Domain.com wants to migrate Certkiller -DB01 to SQL Server 2005 but wants to retain the CK_Trading database with the same instance name. You decide to perform an in-place upgrade to SQL Server 2005. You verify that Certkiller -DB01 exceeds the minimum recommended hardware requirements for SQL Server 2005.
What should you do next?
What should she identify?
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You have received instruction from the CIO to prepare a new installation of SQL Server 2005. The new SQL Server 2005 database server is named Certkiller -DB01. A Domain.com user named Mia Hamm is a member of the Marketing department. You instruct her to identify the protocols that the client computers might use to connect to the server. Mia Hamm needs to identify the protocols that are needed to accomplish this goal.
What should she identify? (Choose all that apply)
What should you do next?
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 2000 Server. The Domain.com network contains a SQL Server 2000 database server named Certkiller -DB01 that runs on Windows 2000 Server. Certkiller -DB01 contains a database named CK_Sales.
Domain.com intends migrating Certkiller -DB01 to SQL Server 2005 in the near future. To prepare for the migration, you decide to install SQL Server 2005 Express on a server named Certkiller -SR23. Certkiller -SR31 was used for previously used by application developer and contains Microsoft Visual Studio 2003, .NET Framework 1.2 and Internet Explorer 5.5. You verify that Certkiller -SR23 exceeds the minimum recommended hardware requirements for SQL Server 2005. What should you do next? (Each correct answer provides part of the solution. Choose THREE.)
Which protocols can Certkiller .com users use to Certkiller -SR21?
You work as a 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 Server 2003 with the latest Service Packs and Hotfixes, while the client computers run Windows XP Professional, Windows 98 Second Edition, and Novell NetWare 6.5.
You have received instruction to prepare for a new installation of SQL Server 2005 on a member server named Certkiller -SR21. Certkiller -SR21 will host a database named CK_Sales. All Domain.com users must be able to connect to Certkiller -SR21 by computer name. A Domain.com network administrator named Rory Allen must ensure that the client computers will be able to connect to Certkiller -DB01.
Which protocols can Domain.com users use to Certkiller -SR21?
What are two possible ways to achieve this goal?
Your company uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is, you need to identity the blocking session ID. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)