You administer a SQL Server 2008 instance that runs on a Windows Server 2003 computer.
The instance uses mixed authentication mode.
You need to ensure that the SQL Server 2008 authenticated logins follow the same
password complexity rules that are enforced by Windows Server 2003. You also need to
ensure that the password complexity rules continue to be enforced.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

You are reviewing and configuring the security of a SQL Server 2008 instance that contains
database DB1.
The security audit policy specifies the following requirements:
Only successful and failed logon attempts are recorded in log files.
The SQL Server instance is shut down if records cannot be written to the log files.
You need to configure the SQL Server instance to comply with the security audit policy.
Which Transact-SQL statements should you run?

You are managing a SQL Server 2008 instance for Home.com. You use a Microsoft SQL
Server 2008 Analysis Services (SSAS) instance. A data mining structure should be deployed
which contains the Microsoft Clustering mining model. From Scalable K-Means to Nonscalable K-Means.
You should alter the attribute of the mining model. Which is the correct answer?

You are mastering the company database, including the SQL Server 2005 database which
include a table called Production. Product. The table has more than 50 columns
The most common queries are listed below Transact-SQL statements. –QUERY 1SELECT
[Name], [ProductLine], [ListPrice], [Class], [Style] FROM [Production]. [Product]WHERE
[ProductLine] = ‘T’ –QUERY 2SELECT * FROM [Production]. [Product] ORDER BY [Name]
When you are minimizing the space required for the indexes.
You should select the best indexes to maintain the most common searched to the
Production. Product tableWhich is the correct answer?

You administer a SQL Server 200S instance. The instance contains an On-Line Analytical
Processing (OLAP) database along with a dimension table named Customers. The data of
the Customers table is updated every hour.
The Customers table contains redundant data.
You need to conserve the disk space used to store the Customers table.
Which compression technology should you use?

You maintain a SQL Server 2008 instance that contains a database named
AdventureWorks.
The AdventureWorks database contains a table named OrderSpecs. The OrderSpecs table
has a clustered primary key named OrderId on the OrderId column. The OrderSpecs table
has a single XML column named ProductSpecs that stores XML data, and there is an XML
index on the same XML column.
You add a new column named ProductId to the OrderSpecs table.
You need to include ProductId in the primary key.
What should you do?

You administer a SQL Server 2008 instance.
You use the SQL Server Import and Export Wizard to export data from SQL Server to a
Microsoft Excel file.

You save the package definition to a file.
You need to reexecute the package from the command line.
Which utility should you use?

You maintain a SQL Server 2008 instance that contains a database named
AdventureWorks. The AdventureWorks database contains two tables as shown in the
following table:

The OrderHistory table contains two table partitions: one partition contains all data and the
other partition is empty.
You plan to develop a process to move data from the partition that contains data for the
oldest month of the Orders table to the appropriate partition of the OrderHistory table.
You need to ensure that the process can be repeated at the end of every month.
What should you do?

You are mastering the company database, with SQL Server 2008 computer named
SQLTEST1The master database on SQLTEST1 is down. Some SQL Server Agent jobs
should be included in the SQLTEST1.The whole database should be backed up every day.
You rebuild and restore the master database. You should make sure that SQLTEST1
functions as it did before the database lost. Which is the correct answer?

You administer a SQL Server 2008 instance that contains a database named
AdventureWorks. The AdventureWorks database contains a table named Orders. The
Orders table has several indexes and a very large number of rows. The database supports
an enterprise Web environment that is constantly used.
Thirty percent of the indexes on the Orders table is fragmented.
You need to defragment the indexes by ensuring that the effect on database availability is
minimized.
Which option should you include in the ALTER INDEX statement?