What could you do to enable clients to connect to Sql1 ?
You are a database administrator in your company. You create a new database named Prod1 on a SQL Server2008 instance named Sql1.
The users on your company’s LAN should have access to the Prod1 database.
All the client computers are running Windows XP Professional and have the SQL Client component installed.
The shared memory protocol is also enabled on all the client computers in the SQL Native Client Configuration .
What could you do to enable clients to connect to Sql1 ? (Choose all that apply. Each correct answer presents aunique solution.)
Which editions of SQL Server 2008 can you use to upgrade SQL1 ?
You are the database administrator of your company. The network contains a server named SQL1 that has the32-bit version of SQL Server 2005 Express edition installed.
SQL1 hosts an application that backs up databasesstored on SQL1 . You want to install a default instance of SQL Server 2008 on SQL1 .
You discover that theapplication uses the DUMP statement that is no longer supported by SQL Server 2008.
You want to upgrade SQL1 to SQL Server 2008.
Which editions of SQL Server 2008 can you use to upgrade SQL1 ? (Each correct answer represents a part of thecorrect solution. Choose two.)
What else should you do?
You are the SQL administrator for your company. A new SQL Server 2008 computer named SQL3 has beendeployed on your network.
You create a default instance named MSSQLServer and two named instances named HumanResources-SQL3 and Finance-SQL3.
After creating the three instances, you attempt to connect to each of them from your Windows Vista clientcomputer.
You connect successfully to the default instance, but are unable to connect to the named instances.
You ensure that you enabled remote connections on the named instances. The appropriate ports for the namedinstances are open on the firewall. What else should you do?
Which jobs should you create?
You are the database administrator for your company. You are in the process of enabling log shipping to improvethe availability of the database.
You have configured four servers of which Prod1 is the primary server instance that maintains your productiondatabase, Prod2 and Prod3 are the secondary server instances for log shipping, and Prod4 is the monitor serverinstance.
After configuring the servers, you must create jobs for the four server instances involved in log shipping.
Which jobs should you create? (Choose all that apply.)
Which system stored procedure should you run on SQL1 to configure this?
You are the database administrator of your company. The company has a main office and five branch offices indifferent cities. Each branch office contains a computer running SQL Server 2008. The main office networkcontains an instance of SQL Server 2008 named SQL1 . SQL1 contains a database named Inventory . Your company wants to implement a new inventory tracking application that will access a table named Inventory_items in the Inventory database. You want to enable users in all the offices to update the
Inventory_items table. You decide to implement merge replication with SQL1 as the Publisher and instances ofSQL Server in the branch offices as the Subscribers. To minimize the disk space on the Subscribers, you want to ensure that only the Publisher is used to store conflictrecords.
Which system stored procedure should you run on SQL1 to configure this?
What should do to create the mirror database on Server2 ?
You manage an instance of SQL Server 2008 named SQL1 . SQL1 contains a database named Sales . You wantto configure database mirroring for the Sales database.
You install a new instance of SQL Server 2008 on aserver named Server2 . You perform a full backup of the Sales database and its transaction logs.
What should do to create the mirror database on Server2 ? (Choose two. Each correct answer presents part ofthe solution.)
Which strategies should you adopt to meet the requirements?
You are a database administrator for your company.
To configure the application environment in the high-availability mode, you have configured a standby server in addition to the primary SQL Server 2008 server.
This standby server should appear online immediately if the primary server fails.
The primary server has a largevolume of inserts, updates, and selects, and generates a transaction log that is almost 100 GB. If the primary server fails, you should minimize the network impact while bringing the standby server online.
You should prevent any type of data loss. Which strategies should you adopt to meet the requirements?
What should you do?
You are the SQL administrator for your company.
You currently manage a SQL Server 2008 failover cluster thatconsists of six SQL Server 2008 instances named SQL1 , SQL2 , SQL3 , SQL4 , SQL5 , and SQL6.
Because of performance issues, you decide to remove SQL6 from the failover cluster.
What should you do?
Which table can you use to achieve the objective?
You are a database administrator for Verigon Corporation.
The company stores all its product-related data in a SQL Server 2008 database named Product that resides on the Sqlserver1 server.
You have configured asecondary database named Product_sec for the Product database to provide high availability for the database.
You must determine the log shipping specific configuration details of the Product database on the Sqlserver1 server.
Which table can you use to achieve the objective?
Which value should you configure for the @sync_type parameter of the sp_addsubscription system storedprocedure
You are the database administrator of your company. You have two SQL Server 2008 servers in a peer-to-peertransactional replication topology. You are in the process of adding a new node to the peer-to-peer transactionalreplication. You want to ensure that all relevant transactions are replicated to the new node.
Which value should you configure for the @sync_type parameter of the sp_addsubscription system storedprocedure?