Saturday, February 5, 2011

MCITP 70 450 Exam Sample Question and Answers Paper 2


QUESTION 1
You work as a database administrator at MSSQLFix.com. MSSQLFix.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named MSSQLFIX-DB01 with an instance that hosts a database named CK_SALES. MSSQLFIX-DB01 hardware configuration is shown below: MSSQLFIX-DB01 has eight quad-core processors. MSSQLFIX-DB01 has 128-GB RAM.

During the course of the day you discover that MSSQLFIX-DB01 is experiencing a low number MSSQLFix.com of CXPACKET waits whilst experiencing a large number of lazy writer waits. MSSQLFix.com wants you to optimize the performance of MSSQLFIX-DB01.

What should you do?

A.  You should consider having the software non-uniform memory access (soft-NUMA) configured.
B.  You should consider having an increase configured in the maximum degree of parallelism option.
C.  You should consider having the Resource Governor configured.
D.  You should consider having the Windows System Resource Manager configured.


Answer: A

QUESTION 2
You are employed as a database administrator at MSSQLFix.com. You are responsible for administering a SQL Server 2008 database server named MSSQLFIX-DB01 that consists of four processors.

MSSQLFIX-DB01 contains numerous databases which include the databases named CK_PRODUCTS and CK_RESEARCH. The subsequent rules are applied MSSQLFIX- DB01:Four processors should be used for operations on CK_PRODUCTS.Two processors should be used by the CK_App application for queries on the tables in CK_RESEARCH.Four processors should be used for all imports, exports, queries or operations on the other databases located on MSSQLFIX-DB01.

What should you do?

A.This can be accomplished using MAXDOP in order to set the processor number to four.
B.This can be accomplished using MAXDOP in order to set the processor number to two.
C.This can be accomplished using the max degree of parallelism option and setting the value to 4.
D.This can be accomplished using MAXDOP with the default value. E.This can be accomplished using the max degree of parallelism option and setting the value to 2.

Answer: BC

QUESTION 3
You are employed as a database administrator at MSSQLFix.com. MSSQLFix.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named MSSQLFIX-DB01 hosts five databases.
MSSQLFIX-DB01 contains two processors. You have received instruction from the CIO to make use of more than one processor for parallelism. You thus set the Show Advanced Options to 1.
You then write the subsequent code:


sp_configure 'max degree of parallelism', 6;
GO
RECONFIGURE WITH OVERRIDE;
GO

You need to determine what the result will be when you execute the code above.

What should you identify?

A.It will result in four processors being used.
B.It will result in three processors being used.
C.It will result in two processors being used.
D.It will result in one processor being used.



Answer: C


QUESTION 4
You work as a database administrator at MSSQLFix.com. MSSQLFix.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named MSSQLFIX-DB01 with an instance that hosts a database named CK_SALES. MSSQLFix.com requires information about the system resources like the amount of memory available and consumed by MSSQLFIX-DB01.

What should you do?

A.You should consider making use of the sys.dm_os_memory_nodes dynamic management view. 
B.You should consider making use of the sys.dm_os_sys_info dynamic management view.
C.You should consider making use of the sys.dm_os_stacks dynamic management view.
D.You should consider making use of the sys.dm_os_process_memory dynamic management view.




Answer: B

QUESTION 5
You work as a database administrator at MSSQLFix.com. MSSQLFix.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named MSSQLFIX-DB01 with an instance that hosts a database named CK_ORDERS. During the course of the day you receive instruction from MSSQLFix.com to select what the recommended size of the allocation unit should be when your database is expected to have a high number of transactions.

What should you do?

A.You should consider having the allocation unit size 64 K.
B.You should consider having the allocation unit size 32 K.
C.You should consider having the allocation unit size 4096.
D.You should consider having the allocation unit size 8192.

Answer: A

QUESTION 6
You work as a database administrator at MSSQLFix.com. MSSQLFix.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named MSSQLFIX-DB01 containing four processors with an instance that hosts a database named CK_SALES. During the course of the day MSSQLFix.com decided to configure the MAX Degree of Parallelism option set to 2. You have later created an index making use of the MAXDOP option and set the number of processors to 3. MSSQLFix.com wants you to determine what the results would be?

A.The current configuration would make use of one processor only.
B.The current configuration would make use of two processors by the default setting of Max Degree of Parallelism option overriding the MAXDOP option.
C.The current configuration would make use of four processors only.
D.The current configuration would make use of three processors only.

Answer: D

QUESTION 7
You work as a database administrator at MSSQLFix.com. MSSQLFix.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named MSSQLFIX-DB01 containing multiple processors and has an instance that hosts a database named CK_SALES. During the course of the day you receive instruction from MSSQLFix.com to create a large volume of indexes and delete older indexes whilst optimizing CPU performance on MSSQLFIX-DB01.

What should you do?

A.You should consider making use of the MAXDOP index option in the index statement.
B.You should consider making use of the MAXDOP index option with the ALTER INDEX REORGANIZE statement.
C.You should consider setting the Max Degree of Parallelism option to 0.
D.You should consider setting the Max Degree of Parallelism option to 1.


Answer: A

QUESTION 8
You work as a database administrator at MSSQLFix.com. MSSQLFix.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named MSSQLFIX-DB01 with an instance that hosts a database named CK_SALES.
MSSQLFIX-DB01 has four quad-core processors and regularly experiences CPU pressure. The users at MSSQLFix.com use the large mission critical database frequently, which resides on MSSQLFIX-DB01. During the course of the day you receive an instruction from the CIO to make sure that the online index rebuilds does not utilize all thye CPU cycles that are available.

What should you do?

A.You should consider having the max degree of parallelism option configured.
B.You should consider running the Netsh utility.
C.You should consider using the Hyper-V feature on the quad-core servers.
D.You should consider configuring the Background Intelligent Transfer Service (BITS) server extensions.

Answer: A

QUESTION 9 
You work as a database administrator at MSSQLFix.com. Your duties include administrating a SQL Server 2008 instance. You are currently planning to deploy a new database named CK_Data to the 2008 instance.
CK_Data will have multiple schemas as well as being subjected to regular inserts and updates. A large amount of read-only reference information will be hosted on one of the schemas. You have received instructions from the management to set up a physical database structure to optimize the backup performance.

What should you do?

A.This can be accomplished by using multiple filegroups and a single log file to set up the database.
B.This can be accomplished by using caching on the multiple data files.
C.This can be accomplished by using multiple downstream servers to create the database.
D.This can be accomplished by using the Database Engine Tuning Advisor tool to create the database.

Answer: A

QUESTION 20
You are employed as the database administrator at MSSQLFix.com. MSSQLFix.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named MSSQLFIX-DB01.

MSSQLFIX-DB01 is configured with 1024 MB of RAM, 80 GB system drive with SQL Server installed as well as a single Core2 Duo 1.6 GHz processor. MSSQLFIX-DB01 hosts a database named CK_DATA. CK_DATA contains: One primary data fileTwo secondary data filesOne transaction log file.

During routine monitoring you discover that the hard drive has only 2 GB of free space available. You notice that the performance of CK_DATA has degraded. You have received instruction from the CIO to optimize the performance of CK_DATA.

What should you do?

A.Your best option would be to increase the memory to 2048 MB.
B.Your best option would be to add additional hard drives as well as moving the database files across the hard drives.
C.Your best option would be to compress the hard drive in order to create more space.
D.Your best option would be to add a new processor to MSSQLFIX-DB01.

Answer: B
Exam 70-432 - Microsoft, 70-432 Microsoft Real Questions, Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance,
Microsoft test 70-432 exam dumps, SQL Server 2012 dumps, sql server 2012 certification dumps, sql server 2012 MCTS dumps, sql server 2012 mcitp dumps, Microsoft 70-432 Exam Preparation,  Microsoft 70-432 Exam guide, Microsoft 70-432 Exam question and answers.Microsoft test 70-432 exam dumps, MCTS 70-432 Dumps, 70-432 Braindumps, Latest 70-432 dumps for sql server 2012, 70 432 dumps free download, 70 432 dumps pdf download, 70 432 dumps free, exam 70 432 dumps free download, mcts 70 432 dumps free download 70 432 dumps pdf, 70 432 dumps download, 70 432 answers. Exam 70-450, Microsoft 70-450 Exam guide, Microsoft 70-450 Exam question and answers.Microsoft test 70-450 exam dumps, MCTS 70-450 Dumps, 70-450 Braindumps, Latest 70-450 dumps for sql server 2012, 70 450 dumps free download, 70 450 dumps pdf download, 70 450 dumps free, exam 70 450 dumps free download, mcts 70 450 dumps free download 70 450 dumps pdf, 70 450 dumps download.

0 comments:

Post a Comment