What should you do?
You manage an instance of SQL Server 2008 named SQL1. SQL1 contains a database named CorpData that isconfigured for full recovery.
You want to compress the primary filegroup and transaction logs for the CorpData database. What should you do?
Which two permissions will you require to perform this task?
You manage an instance of SQL Server 2008 named SQL1 . SQL1 contains two schemas named Corp and Customer.
You want to move a table named Products from the Corp schema to the Customer schema.
Which two permissions will you require to perform this task? (Choose two. Each correct answer represents part ofthe solution.)
Which action or actions must you perform to be able to complete this task using minimum administrative effort?
You are the database administrator of your company. You manage an instance of SQL Server 2008 that stores adatabase named UserData.
UserData is configured with the full recovery model and contains a large amount ofstatic data.
To minimize the amount of space required for the data, you create a new read-only filegroup named UserDataFileGrp and move the data to that filegroup.
You also compress the UserDataFileGrp filegroup using NTFS compression.
After several days, you receive a request to update the data for one of the users in the UserData database.
Toachieve this, you want to modify the compressed data stored in UserDataFileGrp.
Which action or actions must you perform to be able to complete this task using minimum administrative effort?
(Choose all that apply. Each correct answer represents part of the solution.)
Which two bcp commands could you use to accomplish this?
You are a database administrator for your company.
You transfer data from the Prod1 database maintained onthe Sql1 instance of SQL Server 2008 into an external data file before sending the data file to vendors.
You mustsend all the data from the Tbl_auction_rate table. You must use the bcp utility to accomplish this.
Which two bcp commands could you use to accomplish this? (Choose two. Each correct answer represents acomplete solution.)
Which Dynamic Management View (DMV) should you use?
You are the database administrator of a SQL Server 2008 instance that contains several query plans.
You want toobtain information about a query plan that is cached by SQL Server for faster query execution.
Which Dynamic Management View (DMV) should you use?
What should you do?
You are the SQL administrator for your company. You manage a SQL Server 2008 instance named SQL_1.
The instance contains two production databases used by your company.
You need to collect performance data on the growth of all the database and log files within both databases.
Thedata must be collected in the Management Data Warehouse.
Your solution needs to use the same schedule forthe collection and upload of the data.
Your solution must meet the requirements while using the leastadministrative effort.
What should you do?
Which event class should you monitor?
You are the database administrator of your company. You are creating a new trace on an instance of SQL Server 2008 named SQL1.
You want to monitor all connection events when a client requests a connection to SQL1.
You navigate to the Events Selection tab in the Trace Properties dialog box.
Which event class should you monitor?
What should you do?
You are the SQL administrator for your company. A SQL Server 2008 instance named SQL_Prod resides on acomputer named Server1.
SQL_Prod contains three databases named Accounting, Research, and HR .
You need to obtain a list of transactions that are occurring in the HR database.
The information must include thetransaction ID, transaction state, and transaction type. What should you do?
Which event class should you monitor?
You are the database administrator of your company. You are creating a new trace on an instance of SQL Server2008 named SQL1.
You want to capture events when a compiled plan is cached for the first time, recompiled, orevicted from the plan cache.
You navigate to the Events Selection tab in the Trace Properties dialog box. Which event class should you monitor?
What should you do?
You are the SQL administrator for your company. A SQL Server 2008 instance named SQL1 contains severalproduction databases.
Because of the number of users accessing the databases, performance is the primaryconcern.
You configure a SQL trace that monitors the CPU Threshold Exceeded event class.
After the trace is running forseveral days, the trace does not generate any warnings of the condition.
You are concerned that the thresholdthat was specified is too large.
You want to reset the threshold to its default value. What should you do?