Microsoft 70-433 Real Exam Questions

TS: Microsoft SQL Server 2008, Database Development

1: You are planning the backup strategy for the BusinessData database. You need to include a strategy for backup redundancy. Which backup redundancy strategy should you include?
A.Back up the database to a disk backup device, and then back up the database to a tape device.
B.Use different backup devices for full backups and transaction log backups.
C.Back up only the filegroups that are not stored in a RAID disk array.
D.Use a mirrored media set to back up the database to multiple backup devices of the same type.
Correct Answers: D
2: You are designing a data archival strategy for order data. The placements of data and partitions for the Sales.Orders table at the end of July are shown in the following display.  On which filegroup should you locate partition 2 of the Sales.OrderArchive table?
A.FG1
B.FG2
C.FG3
D.FG4
Correct Answers: B

3: You need to implement the HTTP endpoint for the Sales.AddOrder and Sales.GetOrderDetails stored procedures while minimizing the risk of unauthorized access to data and the risk of execution of unauthorized Transact-SQL code. Which action or actions should you perform? (Choose all that apply.)
A.Specify that the endpoint must support BATCHES.
B.Specify that the endpoint must use Secure Sockets Layer (SSL) ports.
C.Grant CONNECT permission on the endpoint to the logins in the sales department.
D.Grant EXECUTE permission on the Sales.AddOrder and Sales.GetOrderDetails stored procedures to the users in the sales department.
E.Specify that the endpoint must use clear ports.
Correct Answers: B C D
4: For the MarketingAnalysis database, you are adding functionality that sends the results of a query in an e-mail message to the marketing supervisors when new sales data has been entered. You need to implement a method that fulfills this requirement and minimizes the security risks. Which method should you use?
A.Database Mail
B.SQL Mail
C.a managed stored procedure
D.a command line program that is called by xp_cmdshell
Correct Answers: A

6: You are planning the configuration of the SQL Server 2005 instance where the BusinessData database will be stored.  As a security precaution, you need to ensure that Windows services that are not essential are disabled. Which Windows service or services should be disabled? (Choose all that apply.)
A.SQL Browser
B.SQL Server
C.SQL Server Analysis Services
D.SQL Writer
E.SQL Server Integration Services
F.SQL Server Agent
Correct Answers: A C D

7: You need to ensure that the companys standard password policy is enforced for all logins that are used to access SQL Server 2005. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.Set the appropriate local password policies for all computers on which SQL Server is installed.
B.Set the server authentication mode of all SQL Server instances to Windows Authentication mode.
C.Install all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.
D.Create SQL Server logins that have CHECK_POLICY enabled.
Correct Answers: C D

8: You are designing the backup strategy for the BusinessData database. You need to ensure that the backup strategy fulfills the business requirements for minimizing data loss and database downtime. Which three backup methods should your strategy include? (Each correct answer presents part of the solution. Choose three.)
A.differential backup every three hours
B.full database backup once per day
C.transaction log backup every three hours
D.transaction log backup every 30 minutes
E.full database backup every 30 minutes
F.differential backup once per day
Correct Answers: A B D

9: You are designing the interim disk availability solution for SQL1. You plan to use Windows RAID functionality. You need to identify the most appropriate RAID configuration to fulfill the availability requirements. Which RAID configuration should you use?
A.Create a mirrored volume for the system files and database logs, and a stripe set with parity for the data files.
B.Create a mirrored volume for the system files and database logs, and a stripe set without parity for the data files.
C.Create a mirrored volume for the system files, database logs, and data files.
D.Create a stripe set with parity for the system files, database logs, and data files.
Correct Answers: A

10: You want to implement database mirroring to ensure the availability of the BusinessData database. You specify SQL1 as the principal server and SQL2 as the mirror server. You need to ensure that the database mirroring solution fulfills the business requirements. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.Configure SQL3 as a monitor server.
B.Configure SQL3 as a witness server.
C.Create a database snapshot of the BusinessData database.
D.Configure the mirror session to use a synchronous operating mode.
Correct Answers: B D

Download  |  Password: certificatexam.com