Latest MCTS 70-432 Dumps Real Exam Download 171-180

Ensurepass

QUESTION 171

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database.

Now you are in charge of a SQL Server 2008 instance. There is an Internet Information Services application. This application will use anonymous access to access the SSAS instance.

You must make sure that the application can access the SSAS instance.

What should you do?

 

A. The SecurityRequireClientAuthentication server configuration should be set to False

B. The SecurityRequireClientAuthentication server configuration should be set to True.

C. The NTLM Security Support Provider Interface (SSPI) provider should be added to the Security SecurityPackageList server configuration.

D. The Kerberos Security Support Provider Interface (SSPI) provider should be added to the Security SecurityPackageList server configuration

 

Correct Answer: A

Explanation/Reference:

Microsoft SQL Server Analysis Services supports the security server properties listed in the following table. To view or change these properties for an instance of Analysis Services, in SQL Server Management Studio, right-click the Analysis Services instance, and then click Properties. PropertiesRequireClientAuthentication

A Boolean property that indicates whether client authentication is required. The default value for this property is True, which indicates that client authentication is required. In this case, the authentication should be anonymous, thus the property should be set to False

 

 

QUESTION 172

You work in a company which uses SQL Server 2008. You are the administrator of the company database.

Now you are in charge of a SQL Server 2008 instance.

A SQL Server Agent job is failing.

You find that the job history information is incomplete and seems to be truncated after you review it. All information produced by a job must be available for viewing.

So what action should you perform to achieve this goal?

 

A. You should enable notifications to the Windows application event log when the job completes.

B. You should enable write OEM file

C. You should enable all job steps, making them send the output to a file

D. You should include execution trace messages in the SQL Agent Error log

 

Correct Answer: C

Explanation/Reference:

In all the jobsteps, go to the option panel and select Output file to get all info from the step. Note that you can append or overide the file. All job steps should be adapted with the option.

Output file Sets the file to use for output from the job step.

 

 

QUESTION 173

You administer a SQL Server 2008 instance named CorpPub that contains a database named

SalesSupport. The SalesSupport database contains the Products table.

You plan to create a Replication topology to replicate the Products table to the SQL Server instances installed in portable computers. When the portable computers reconnect to the corporate network, the

Products table is updated from CorpPub.

The Products table on the CorpPub instance is frequently updated between reconnections.

You need to successfully implement the Replication topology along with the Subscription type by ensuring that bandwidth usage is minimized.

What should you do?

 

A. Implement the Merge Replication topology along with a Pull Subscription.

B. Implement the Snapshot Replication topology along with a Pull Subscription.

C. Implement the Snapshot Replication topology along with a Push Subscription.

D. Implement the Transactional Replication topology along with a Pull Subscription.

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 174

You administer a SQL Server 2008 instance that contains a database named AdventureWorks.

The AdventureWorks database contains the Products table.

You create a Merge Replication topology and a Publication to replicate the Products table to the SQL

Server instances at remote locations. The Publication has a 21-day retention period.

When a user returns from a one-month vacation, she discovers that her database does not contain the most recent data. The Windows Event log states the following error message:

“Replication: expired subscription dropped.”

You need to obtain the most recent data in the database of the user. You also need to ensure that future data changes are appropriately replicated.

What should you do?

 

A. Recreate the publication.

B. Upload unsynchronized changes.

C. Upload unsynchronized changes, and then reinitialize the publication.

D. Reinitialize the publication and immediately generate a new snapshot.

 

Correct Answer: D

Explanation/Reference:

 

 

QUESTION 175

You administer a SQL Server 2008 cluster.

You plan to test the failover response of the cluster.

You need to implement a manual failover on the cluster.

Which two actions should you perform? (Each correct answer presents a complete solution.

Choose two.)

 

A. Restore a backup to the active node.

B. Remove the shared array from the active node.

C. Unplug the network cable(s) from the active node.

D. Use Encrypting File System (EFS) to encrypt the contents of a shared folder on the active node.

 

Correct Answer: BC

Explanation/Reference:

 

 

QUESTION 176

You administer three SQL Server 2008 instances named Instance1, Instance2, and Instance3.

Each of the three instances runs on a separate server. A mission-critical database is mirrored between

Instance1 and Instance2. Instance3 acts as the witness. Instance1 currently acts as the Principal.

You plan to apply a patch to both servers. The patch requires a restart of the server.

You need to find out the sequence of steps necessary to ensure that the following requirements are met:

1. The patching process is completed in the shortest possible time.

2. The database is online on the partner that currently does not apply the patch.

3. The database does not failover to the other partner during this time. What should you do?

 

A. Apply the patch to the server that runs Instance2. Apply the patch to the server that runs Instance1.

B. Apply the patch to the server that runs Instance2. Manually failover the mirroring session. Apply the patch to the server that runs Instance1.

C. Remove the mirroring session. Apply the patch to the server that runs Instance2. Apply the patch to the server that runs Instance1. Re-establish the mirroring session.

D. Suspend the mirroring session. Apply the patch to the server that runs Instance2. Resume the mirroring session. Manually failover the mirroring session. Apply the patch to the server that runs Instance1.

 

Correct Answer: D

Explanation/Reference:

 

 

QUESTION 177

You maintain multiple SQL Server 2008 instances.

You are designing a consolidated repository of performance data.

You need to ensure that the following requirements are met:

1. The data collector is used to gather performance information.

2. A single database stores performance information for all instances.

3. Performance information that is older than 14 days is deleted.

4. Administrative effort to manage performance data is minimized. What should you do?

 

A. Create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process to store and delete performance data in a single database for all instances.

B. Create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances.

C. Configure a management data warehouse process on each instance to store and delete performance data in a single database for all instances.

D. Configure an automated server-side trace process on each instance to store and delete performance data in a single database for all instances.

 

Correct Answer: C

Explanation/Reference:

 

 

QUESTION 178

You manage a SQL Server 2008 instance.

You plan to maintain a management data warehouse that collects performance data by using the data collector.

You need to implement a process that routinely gathers and uploads data in the management data warehouse on different schedules.

What data collection process should you implement?

 

A. Create a cached data collection.

B. Create a scheduled non-cached data collection.

C. Create an on-demand non-cached data collection.

D. Create two different SQL Agent jobs that are scheduled at the same time. One job creates a data collection and the other job uploads the data collection.

 

Correct Answer: AExplanation/Reference:

 

 

QUESTION 179

You administer a remote SQL Server 2008 instance.

Users report that the performance of the application is poor.

You use SQL Profiler to capture a workload of the remote instance to a trace table on the remote SQL Server instance.

You need to analyze the workload of the remote SQL Server instance on a local SQL Server instance by using the Database Engine Tuning Advisor.

What should you do?

 

A. Use the data collector to recapture the workload.

B. Use SQL Profiler to recapture the workload to a trace file.

C. Enable the XP_MSVER stored procedure on the local server.

D. Enable the XP_MSVER stored procedure on the remote server.

 

Correct Answer: B

Explanation/Reference:

 

 

QUESTION 180

You administer a SQL Server 2008 instance.

A user named Mary reports that she is waiting for a query to complete.

You need to ascertain whether the query is blocked.

Which tool should you use?

 

A. The Windows System Monitor tool

B. The Database Engine Tuning Advisor tool

C. The Activity Monitor tool in Microsoft SQL Server Management Studio

D. The Job Activity Monitor tool in Microsoft SQL Server Management Studio

 

Correct Answer: C

Explanation/Reference:

 

Download Latest MCTS 70-432 Real Free Tests , help you to pass exam 100%.