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 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?
Which two transaction isolation levels can you configure to accomplish this?
You are the database administrator of your company. You are in the process of configuring transaction isolation level to define the locking and row versioning behavior of Transact-SQL statements. You want to ensure that phantom reads do not occur when you configure the transaction isolation level. Which two transaction isolation levels can you configure to accomplish this? (Choose two. Each correct answer represents a complete solution.)
What should you do to achieve this?
You are the database administrator of your company. You configure automatic auditing by using SQL Server Audit on a server that runs an instance of SQL Server 2008. You want to ensure that the failed login attempts to the instance are logged in the Windows Security event log.
What should you do to achieve this?
What action should you take?
You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server 2008 instance.
You have received instruction from management to migrate a web application from Microsoft SQL Server 2005 to Microsoft SQL Server 2008.
Be reminded that when a web application is moved then some features could stop working. You need to detect such instances.
What action should you take? (Each correct option is part of the answer. Choose TWO)
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 cluster. You have received instructions from management to perform a manual failover on
the cluster.
What should you do? (Choose TWO)
What should you do?
You work as a database administrator at Domain.com. Domain.com is using SQL Server 2008
for its database administration. Domain.com has five automated testing areas for completely assembled items.
The Testing results of every area are stored on the SQL Server 2008 instance.
You have received instructions to create a replication method to ensure that test results flow from
the testing areas to the SQL Server efficiently and that it can be used for reporting.
What should you do? (Each correct answer forms part of the solution. Choose TWO.)
which owns an estimated execution cost less than 2.What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You have received instruction from management to set the instance to utilize one
thread for searches which owns an estimated execution cost less than 2.
What should you do?
What should you do to all SQL servers to provide maximumsecurity for login accounts?
You are the SQL administrator for your company. A SQL Server 2008 computer named VMSQL01 is configuredwith the following settings on the Security page of the
Server Properties dialog box:
A new security policy has been adopted by your company that requires all SQL servers to provide maximumsecurity for login accounts. Backward compatibility should not be a consideration. exhibit What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You have received instruction from management to move a web application from
Microsoft SQL Server 2005 to Microsoft SQL Server 2008. Be reminded that when a web
application is moved then the features will be stopped and you need to control the SQL Server
sample to remember the use of features.
What should you do?