PrepAway - Latest Free Exam Questions & Answers

Category: 70-432

Exam 70-432: ts microsoft sql server 2008 implementation and maintenance

Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products
whose recovery model is set to full for Company.com. The Products database?

backup method is listed below:The information reserve on different disks. The hard disks which include the user
database data files are reported to have failed at 17:00 hours on Wednesday. You should make
sure that Products database could be saved by minimal data loss. exhibit Which is the correct answer?

Which Transact-SQL statement should you run?

You are the database administrator for your company. The network contains a SQL Server 2008 computer. The SQL server contains a database named Sales.
You want to create four partitions on the CustID column in the Customers table of the Sales database. The values for each partition will be as follows:

You want to create a partition function that will be used to create the appropriate partitions for the Customers table as per these requirements.
exhibit Which Transact-SQL statement should you run?

Which Transact-SQL statement or statements can you use?

You are responsible for managing an instance of SQL Server 2008.
You run the following Transact-SQLstatements in the Query Editor to create a new table named CorpData to test different collation settings fordifferent columns:

You want to generate output that displays the values of both the columns without producing any errors.
exhibit Which Transact-SQL statement or statements can you use? (Choose all that apply.)

What should you do to ensure that when you run SQL Server Profiler, the performance of the Prod1 database is n

You are a database administrator for your company.
The company stores all its business information in adatabase named Prod1 residing on a SQL Server instance Srv1, which in turn resides on the Sql1 computer.
The Prod1 database is 35 GB in size and occupies almost 90 percent of the hard disk space allocated to Sql1.
Another SQL Server instance Srv2 , located on server computer Sql2 is configured as a linked server on Srv1.
You manage the Prod1 database. To improve query performance and optimize indexes, queries and stored procedures, you frequently run traces using SQL Server Profiler.
The trace information is accessed by other teammembers using Transact-SQL queries.
When you run SQL Server Profiler, other team members complain that theperformance of Srv1 is adversely affected.
You want to ensure that when you run SQL Server Profiler, the performance of the Prod1 database is not affected.
What should you do?

What should you do to start a newerror log?

You are the SQL administrator for your company. You manage two SQL Server 2008 instances named SQL1 and SQL2 . Each instance maintains its own error log.
You discover that the hard drive on which the error log for SQL1 resides is full. You delete non-vital informationfrom the hard drive to free up space.
After cleaning up the hard drive, you decide that you want to start a newerror log. What should you do? (Choose two. Each correct answer represents a complete solution.)

What should you do to achieve this objective?

You are the database administrator for a major electronics chain. You manage all the SQL Server 2008 databases of the company.
The data is stored in databases named Prod1 and Prod2.
These databases areaccessed by users in the company by using four different applications named Cust_sales , Cust_audit , Retail_sales , and Yearly_total.
Users of the Cust_sales and Cust_audit applications complain that either the transactions time out frequently ortake too long to complete.
You want to monitor the applications causing the transaction blocks by using the Activity Monitor.
exhibit What should you do to achieve this objective?


Page 1 of 3312345...102030...Last »