070-432 試験問題を無料オンラインアクセス

You administer a SQL Server 2008 instance that has TCP/IP enabled.
You need to verify the port that the SQL Server instance listens on.
What should you do?

• A.Open SQL Server Configuration Manager
  Expand the SQL Server Network Configuration service. Select the Protocols for (InstanceName) service.
  In the right panel, right-click TCP/IP, select the Properties option, and then select the IP Addresses tab.
• B.Open SQL Server Configuration Manager
  Expand the SQL Native Client 10.0 Configuration service.
  Select the Client Protocols service. Select the Properties option.
• C.Open SQL Server Configuration Manager
  Select the SQL Server Services service.
  In the right panel, right-click SQL Server Browser, right-click Properties, and then select the Advanced tab.
• D.Open SQL Server Configuration Manager
  Select the SQL Server Services service.
  In the right panel, right-click SQL Server (InstanceName), right-click Properties, and then select the Advanced tab.

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?

• A.CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\\MAIN_SERVER\AuditV ) WITH (ON_FAILURE = SHUTDOWN) ;GOCREATE DATABASE AUDIT SPECIFICATION Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP).ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GO ALTER SERVER AUDIT SrvAucfit WITH (STATE=ON);GO
• B.CREATE SERVER AUDIT Srv_Audit TO FILE (FILEPATH =`\\MAIN_SERVER\Audit\') WITH (ON_FAILURE = SHUTDOWN);GOCREATE SERVER AUDIT SPECIFICATION Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP),ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GOALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);GO
• C.sp_configure 'show advanced options'. 1 ;GORECONFIGURE;GOsp_configure 'common criteria compliance enabled'. 1 ;GORECONFIGUREGO
• D.sp_configure 'show advanced options', l:GORECONFIGURE:GOsp_configure 'default trace enabled'. 1 ;GORECONFIGUREGO

You administer a SQL Server 2008 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 thirty minutes.
The Customers table contains redundant data.
You need to conserve the disk space used to store the Customers table.
What should you do?

• A.Defragment the hard disk that contains the instance.
• B.Implement page compression.
• C.Implement row compression.
• D.Compress the hard disk that contains the instance.

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?

• A.You should reserve the model and master databases for the database.
• B.You should rebuild the whole SQL Server Web Service for the database.
• C.You should rebuild the whole table schema for the database.
• D.You should reserve the Log Transaction for the database.

You need to install a SQL Server 2008 instance for a new application on an existing server that contains a default SQL Server 2005 instance.
You need to ensure that both database instances are available for their respective certified third-party applications.
You need to achieve this goal by complying with the following constraints:
- Minimal database administrative effort.
- The existing application environments remain unchanged
What should you do?

• A.Upgrade the SQL Server 2005 application to use SQL Server 2008.
• B.Install SQL Server 2008 as a named instance, and configure the new application to use the new instance.
• C.Upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
• D.Install SQL Server 2008 as the default instance, and configure the new application to use the default instance.