Which is the correct answer?
You are managing a SQL Server 2008 instance which includes a database called Products for
Company.com. You set recovery model full. You run a full database backup for the whole the
user databases at 01:00 hours everyday. The transaction log backup happens each 20 minutes.
You could run a differential backup each 5 hours. You decide to run a full backup of the Products
database at 12:00 hours. Not only you should make sure that you could run the backup without
affecting the overall backup and restore procedures for the Products database but also you could
restore the Backup files in proper sequence. Which is the correct answer?
Which is the correct answer?
You are mastering the company database, Users complaints that the SQL Server 2008
application is running slowly. You should check the information of the CPU utilization, disk
utilization, and memory utilization. The network should be considered. the detailed information
should be checked for the proper example of SQL Server2008.Which is the correct answer?
Which is the correct answer?
You are mastering the company database called TesterDB; the database includes a database
that uses SQL Server log shipping. Log shipping will happen half a hour.
You should make the full backup. In order to cut the net bandwidth utilization when maintenance every night.
Which is the correct answer?
Which is correct?
Your workstation has installed Microsoft SQL Server Management Studio (SSMS), and not
installed Microsoft Business Intelligence Development Studio (BIDS).
You should design a package, which has the following features:The package should be transactional.
The package should be optimized for 10 tables.
The package should be stored safely in the msdb database of a server which is remote. Which is correct?
Which command should you run?
You are the database administrator for Nutex Corporation. The company has a main office and a branch office.Each office contains an instance of SQL Server 2008. You have received a text file named emp.txt from the human resources department in the branch office. The textfile contains information about employees, and the data for each column is separated by a comma. You want toimport the data from the files into a table named employees in a database named hrdb using minimumadministrative effort. Which command should you run?
Which Transact-SQL statement should you use?
You are the database administrator of your company. The network contains a SQL Server 2008 computer thathas two partitioned tables named Sales and Sales_Hy.
You want to switch a partition from the Sales table to the Sales_Hy table.
Which Transact-SQL statement should you use?
Which two data types can you configure for the CustAddress column to perform the required task?
You are responsible for managing an instance of SQL Server 2008 named SQL1 . SQL1 contains a databasenamed Customers.
The Customers database contains a table named CustDetails . You want to create a spatialindex on a column named CustAddress.
Which two data types can you configure for the CustAddress column to perform the required task? (Choose two.Each correct answer represents a complete solution.)
Which statements about XML indexes are true?
You are the database administrator for your company. One of the databases that you maintain contains largevolumes of XML data.
An XML column appears in the WHERE clauses of most queries that users execute againstthe database.
The large binary objects (BLOBs) are shredded at runtime for each row of the query.
This processbecomes very expensive for the database server in terms of resources and performance.
In this scenario, you decide to create an index on the XML columns.
You need to ensure that you understand XML indexes.
Which statements about XML indexes are true? (Choose all that apply.)
What should you do next?
You are the SQL administrator for your company. You manage a SQL Server 2008 instance named SQL1 thathosts several databases.
SQL1 was originally configured to use a SQL Server collation. You need to change theinstance to a Windows collation.
You create scripts for creating all the user databases and the objects in them. Then, you export all your data anddrop all user databases. What should you do next?
Which task should you include in the maintenance plan?
You are the SQL administrator for your company. A SQL Server 2008 instance named SQL_Prod includes adatabase named Research.
The Research database contains many indexes. Users report that the Research database is experiencing performance issues.
Upon investigation, you discoverthat the indexes for the Research database are showing an average fragmentation of 20 percent.
You decide tocreate a maintenance plan that will run on a weekly basis to resolve this issue.
Which task should you include in the maintenance plan?