which one should be utilized?
You are a professional level SQL Sever 2008 Database Administrator. They are
respectively named Ins01, Ins02, Ins03 and Ins04. A single database application is hosted
by each instance. All four instances should be removed to a new SQL Server failover
cluster. You can see the configuration of the four instances from the table listed below: All
the four instances are sufficiently optimized, and there are no spare CPU cycles or extra
memory in the instances. All four databases will be hosted by the new cluster on a single
virtual cluster IP address. Since you are the technical support, you are required to set the
new cluster to handle the workload of all the database applications with the least amount of
hardware resources. From the four cluster configuration, which one should be utilized?
Which type of data region should you use?
You develop a report by using SQL Server 2008 Reporting Services (SSRS).
The report has a dataset that contains 25 columns of data. You plan to render the dataset to
a Microsoft Office Excel worksheet.
You need to ensure that the report columns are properly aligned when rendering to Excel.
Which type of data region should you use?
You need to ensure that the server executes only correctly signed packages
You administer an instance of a SQL Server 2008 server.
The server is used to execute SQL Server 2008 Integration Services (SSIS) packages.
You need to ensure that the server executes only correctly signed packages.
What should you do?
Which two actions should you perform?
You manage the security in SQL Server 2008 R2 Reporting Services (SSRS).
You create a new role.
You need to grant the following permissions to the role:
View and modify security settings for reports, folders, resources, and shared data sources.
Create and delete reports.
Modify report properties.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
Which action will you perform to accomplish the goal?
You are a professional level SQL Sever 2008 Database Administrator. An instance runs on
a computer, and the computer has eight quad-core processors and 128-GB RAM. The
instance is utilized by four different applications. Not only a low number of CXPACKET waits
but also a large number of lazy writer waits are experienced by the instance. The
performance of the instance should be optimized. Which action will you perform to
accomplish the goal?
Which control flow component should you use to create the worksheet?
You are designing a SQL Server 2008 Integration Services (SSIS) package. The package
will be used to extract data from a SQL Server 2008 database and load data to a Microsoft
Office Excel workbook. You need to ensure that the package creates a new worksheet in an
existing Excel workbook during execution. Which control flow component should you use to
create the worksheet?
You need to minimize the amount page I/O that is generated when the query runs
You have a table named Table1. A sample of the data in Table1 is shown in the following
table. There is a defined nonclustered index on the SalesOrderNumber column. The
following query executes against the table. WHERE ‘SO3’ = LEFT(SalesOrderNumber,3)
You need to minimize the amount page I/O that is generated when the query runs. What
should you do?
You need to ensure that only the aggregations are updated
You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to process the aggregations of a cube by using an XML for Analysts (XMLA) script.
You need to ensure that only the aggregations are updated.
What should you do?
which column in the Employee table should you a create a self-reference foreign key constraint?
You administer a Microsoft SQL Server 2012 database. The database contains a table named
Employee.
Part of the Employee table is shown in the exhibit. (Click the Exhibit button.)
Unless stated above, no columns in the Employee table reference other tables.
Confidential information about the employees is stored in a separate table named EmployeeData.
One record exists within EmployeeData for each record in the Employee table.
You need to assign the appropriate constraints and table properties to ensure data integrity and
visibility.
On which column in the Employee table should you a create a self-reference foreign key constraint?
Which event should you trace in Microsoft SQL Profiler?
You administer an instance of SQL Server Analysis Services (SSAS).
To troubleshoot access rights issues, you need to find out which roles are applied to a user.
Which event should you trace in Microsoft SQL Profiler?