Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• 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 Security\RequireClientAuthentication server configuration should be set to False
  B. The Security\RequireClientAuthentication 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
  A. The Security\RequireClientAuthentication server configuration should be set to False

• Question 172:

  You are mastering the company database, You should check the log of the a SQL Server 2005 Enterprise Edition everyday, You get the information on the torn page errors of the database. In order to fine the solution of the torn page, Which is the correct answer?

  A. You should utilize the latest database backup to restore only the torn page. Then restore any transaction logs which have been made since the full backup.
  B. You should reserve the newest database backup and then reserve any transaction logs which have been made since the past backup.
  C. You should operate DBCC CHECKDB.
  D. You should reserve the database from the newest database snapshot.
  A. You should utilize the latest database backup to restore only the torn page. Then restore any transaction logs which have been made since the full backup.

• Question 173:

  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.
  A. Create a cached data collection.

• Question 174:

  You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database named CustomerOrders.

  The database is backed up by using the weekly scheduled SQL Server Agent jobs. The backup schedule is shown in the following table:

  

  A drive fails and the CustomerOrders database goes into suspect mode on Monday at

  09:00

  hours.

  You need to restore the backup.

  What should you do?

  A. Restore the backup taken on Sunday only.
  B. Restore the backups taken on Sunday and Monday.
  C. Restore the backup taken on Wednesday only.
  D. Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at 18:00 hours.
  E. Restore the backups taken on Wednesday and Thursday at 09:00 hours.
  F. Restore the backups taken on Wednesday, Thursday, and Friday.
  G. Restore the backups taken on Wednesday and Friday.
  H. Restore the backups taken Wednesday, Friday, and Saturday.
  C. Restore the backup taken on Wednesday only.

• Question 175:

  You are mastering the company database, you should check the log of the SQL Server 2008 Enterprise Edition everyday, and you get the information on the torn page errors of the database. In order to fine the solution of the torn page, which is the correct answer?

  A. You should utilize the latest database backup to restore only the torn page. Then restore any transaction logs which have been made since the full backup.
  B. You should reserve the newest database backup and then reserve any transaction logs which have been made since the past backup.
  C. You should operate DBCC CHECKDB.
  D. You should reserve the database from the newest database snapshot.
  A. You should utilize the latest database backup to restore only the torn page. Then restore any transaction logs which have been made since the full backup.

• Question 176:

  You administer a Microsoft SQL Server 2008 R2 instance that contains two databases named Northwind2008R2 and AdventureWorks. The Northwind2008R2 database uses the SQL_Latin1_General_CP1_CI_AS collation and the AdventureWorks database uses the SQL_Latin1_General_CP1_CS_AS collation.

  You need to write a query that returns all customers having the same name in each database. You also need to ensure that the query is not case-sensitive. Which Transact-SQL query should you use?

  

  A. B. C. D.
  B

• Question 177:

  You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition:

  

  The following DDL has been run on the database: CREATE PARTITION FUNCTION FUNC_FG (INT)

  AS RANGE LEFT FOR VALUES (1, 100, 1000);

  You need to create a partition scheme that will place all data to the SECONDARY filegroup.

  What should you do?

  A. Remove the clustered index from the table.
  B. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
  C. Use the ALTER TABLEstatement to remove the COLLATEoption.
  D. Execute the DBCC CLEANTABLEcommand on the OrderItems table.
  E. Create a new filegroup. Create a new database file. Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause. Use ALTER INDEX REORGANIZE statement.
  F. Create a new Filegroup. Create a new database File. Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause. Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.
  G. Create a new table. Use the ALTER TABLE statement along with the SWITCH PARTITION clause. Use the ALTER PARTITION FUNCTION statement along with the MERGE RANGE clause.
  H. Create a new partition function. Create a new partition scheme. Add a clustered index to place the data onto the partition scheme.
  I. Run the following statement: CREATE PARTITION SCHEME SEC_FG AS PARTITION FUNC_FG ALL TO (SECONDARY);
  J. Run the following statement: EXECUTE sp_tableoption @TableNamePattern ='OrderItem3', @OptionName= `PartltionByYear'; @OptionValue= 'true';
  I. Run the following statement: CREATE PARTITION SCHEME SEC_FG AS PARTITION FUNC_FG ALL TO (SECONDARY);

• Question 178:

  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?

  A. Row compression
  B. Page compression
  C. Backup compression
  D. Windows NITS file system compression
  B. Page compression

• Question 179:

  You administer a SQL Server 2008 instance.

  You need to allow users on the SQL Server instance to query remote data sources by using the OPENROWSET() function. Which sp_configure configuration option should you configure?

  A. Remote access
  B. Remote proc trans
  C. Ad Hoc Distributed Queries
  D. Agent XPs
  C. Ad Hoc Distributed Queries

• Question 180:

  You administer a SQL Server 2008 instance. Users report that applications that run on the server perform poorly. You suspect that the performance issues are related to table scans. You need to use an appropriate Windows System Monitor object to capture the appropriate information.

  Which performance object should you use?

  A. SQLServer:Databases
  B. SQLServer:Access Methods
  C. SQLServer:Buffer Manager
  D. SQLServer:Memory Manager
  B. SQLServer:Access Methods