Tuesday, February 1, 2011

MCITP 70 450 Exam Sample Question and Answers Paper 1

QUESTION 1 
MSSQLFIX.COM has hired you as a database administrator for their network. Your duties include administering the SQL Server 2008 servers. You receive an instruction from the CIO to implement page compression on numerous partitions in order to save space. You need to determine what effect implementing compression will have on the SQL Server components.

What should you identify?

A.  Restore operations will not be affected by implementing page compression. 
B.  Backup operations will not be affected by implementing page compression. 
C.  Bulk export operations will not be affected by implementing page compression. 
D.  Bulk import operations will not be affected by implementing page compression. 
E.  Existing query plans will not be affected by implementing page compression. 
F.   Log shipping will not be affected by implementing page compression.

Answer: ABF 

QUESTION 2 
You work as a database administrator at MSSQLFIX.COM. You are responsible for administering a SQL Server 2008 instance. 
You are currently planning the deployment of a new database. The database will have the subsequent capacity requirements:45 GB for the transaction log file280 GB for the database data file

There are approximately six 120 GB disk drives available for the database in the storage array. MSSQLFIX.COM contains a RAID controller that supports RAID levels 0, 1, 5 and 10. The disks are on the RAID controller. You receive an instruction from the CIO that is as follows:
The transaction log's write performance should be maximized.  In the event of a drive failure, it is expected that the database and transaction log files is protected.  You then decide to plan a storage system. You need to determine the storage configuration that will accomplish this.
 
What should you identify?

A.  You should consider using a RAID 1 volume as well as a RAID 5 volume. 
B.  You should consider using a RAID 1 volume as well as a RAID 10 volume. 
C.  You should consider using a RAID 3 volume as well as a RAID 5 volume. 
D.  You should consider using a RAID 1 volume as well as a RAID 3 volume.


Answer: A

QUESTION 3 
You work as a database administrator at MSSQLFIX.COM. You are responsible for administering the SQL Server 2008 infrastructure for MSSQLFIX.COM.
During routine monitoring you discover that the instance experiences a low number of CXPACKET waits as well as a large number of lazy writer waits. To ensure productivity you need to better the performance of the instance.
 
What should you do?
 
A.  You should consider setting up the Windows System Monitoring tool to better the performance.
B.  You should consider setting up the Asynchronous database mirroring to better the performance.
C.  You should consider using the SQLAGENT.OUT log to better the performance. 
D.  You should consider setting up the software non-uniform memory access (soft-NUMA) to better Mssqlfix. com the performance.
 
Answer: D 

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 receive an instruction from management to make sure that your department is prepared in the event of a natural disaster. You thus decide to create a disaster readiness plan. You need to determine the appropriate actions that should be included in your disaster readiness plan.
 
A.  You should consider testing and using RAID 5 for the volume that contains the database files.
B.  You should consider testing and using RAID 1 for the volume that has the operating system. 
C.  You should consider maintaining the system logs in a secure manner. 
D.  You should consider performing the recovery of a database(s) on another SQL server. 
E.  You should consider testing and using RAID 5 for the volume that has the operating system. 
F.  You should consider testing and using RAID 1 for the volume that contains the database files.
 
Answer: CD  

QUESTION 5 
MSSQLFIX.COM has employed you as a database administrator. MSSQLFIX.COM currently makes use Mssqlfix. com of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named MSSQLFIX-DB.
You are in the process of enabling FILESTREAM on a volume on MSSQLFIX-DB. You have received instruction from the CIO to ensure that the volume store documents in compressed form. You notice that volume F:\ is not formatted. You need to make sure that the volume will be able to store documents in a compressed form.
 
What should you do?
 
A.  You should execute the format F: /FS:NTFS /V:BLOBContainer/A:8192 /C command. 
B.  You should execute the format F: /FS:NTFS /V:BLOBContainer/A:8192 command. 
C.  You should execute the format F: /FS:NTFS /V:BLOBContainer/A:4096 command. 
D.  You should execute the format F: /FS:NTFS /V:BLOBContainer/A:4096 /C command.
 
Answer: D 


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-DB with an instance that hosts a database named FIX_DATA. During the course of the day you receive instruction from MSSQLFIX.COM to design a RAID solution for the FIX_DATA database which has high read/write activity. MSSQLFIX.COM wants you to ensure that the I/O performance of MSSQLFIX-DB is improved whilst ensuring that Mssqlfix.COM there is fault tolerance for the database. MSSQLFIX.COM wants you to make use of the existing resources as funds are tied to other projects.

What should you do?
 
A.  You should consider making use of a RAID 5 solution. 
B.  You should consider making use of a RAID 10 solution. 
C.  You should consider making use of a RAID 1 solution. 
D.  You should consider making use of a RAID 0 solution.

 

Answer: A

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-DB with an instance that hosts a database named CK_STAFF which is hosted on a RAID 5 volume. During the course of the day you receive instruction from MSSQLFIX.COM to change the default size of the allocation unit which is set at 4096 bytes. MSSQLFIX.COM wants you to accomplish the task which having the RAID 5 volume data assigned to Drive E: to retain is existing volume name.
 
What should you do?

A.  You should consider making use of the format E: /A:4096 /V:Data command. 
B.  You should consider making use of the format E: /A:4K /V:Data command. 
C.  You should consider making use of the format E: /A: 64K /V:Data command. 
D.  You should consider making use of the format E /A:65536 /V:Data command.

Answer: C


QUESTION 8  
You work as a database administrator at MSSQLFIX.COM. MSSQLFIX.COM currently makes use of Mssqlfix.COM Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named MSSQLFIX-DB with an instance that hosts a database named FIX_DATA which is used by an online portal for storing data. The portal is expected to receive large numbers of queries which will require high availability for the data. MSSQLFIX.COM wants you to meet the company requirements below: MSSQLFIX.COM wants to have the SQL Server 2008 configuration optimized to ensure the database remains intact even when a hard disk fails.MSSQLFIX.COM wants to have the data recovery method to be reliable and provide faster recovery if a hard disk fails whilst ensuring database performance is optimized.MSSQLFIX.COM wants to have the databases available even when the operating system (OS) disk fails.
 
What should you do?

A.  You should consider making use of RAID 1 for the operating system and Transaction Logs; and RAID5 for the SQL Server files and file groups. 
B.  You should consider making use of RAID 0 for the operating system and Transaction Logs; and RAID 5 for the SQL Server files and file groups. 
C.  You should consider making use of RAID 0 for the operating system; RAID 1 for the Transaction Logs; and RAID 5 for the SQL Server files and file groups. 
D.  You should consider making use of the same RAID 1 for the operating system and Transaction Logs; and RAID 5 for the SQL Server files and file groups.
 
Answer: A

QUESTION 9 
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-DB with an instance that hosts a database named CK_SALES. During the course of the day you receive instruction from MSSQLFIX.COM to reconfigure the CK_SALES database for placement on the disk subsystem. MSSQLFIX.COM wants you to place the database on the fastest I/O subsystem whilst ensuring user data is not lost when a disk failure occurs.
 
What should you do?

A.  You should consider placing the CK_SALES database on the same RAID 1 disk as the operating system. 
B.  You should consider placing the CK_SALES database on the same RAID 0 disk as the operating system. 
C.  You should consider placing the CK_SALES database on a separate RAID 0 solution. 
D.  You should consider placing the CK_SALES database on a separate RAID 5 solution.
 
Answer: D

QUESTION 10 
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-DB with an instance that hosts a database named CK_SALES. During the course of the day you receive instruction from MSSQLFIX.COM to deploy a new CK_PRODUCTS database which should meet the capacity requirements set below: MSSQLFIX-DB will require 175 GB for the database data file.MSSQLFIX-DB will require 60 GB for the transaction log.
 
The MSSQLFIX-DB storage array has six 200 GB disk drives available for the database which are attached to a RAID controller supporting RAID levels 0, 1, 5 and 10. MSSQLFIX.COM wants to have the write performance of the transaction log maximized whilst having the database and transaction log protected from drive failure by designing the storage system.
 
What should you do?
 
A.  You should consider making use of a RAID 0 volume and RAID 5 volume. 
B.  You should consider making use of a RAID 1 volume and RAID 5 volume. 
C.  You should consider making use of a single RAID 5 volume. 
D.  You should consider making use of a single RAID 10 volume.
 
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