REAL QUESTIONS SUBMIT MATERIAL ADVERTISE
Braindumps

Microsoft

Cisco

Citrix

CIW

CompTia

CWNA

Apple

Adobe

HP

Legato

Exin

Filemaker

Brocade

Ericsson

TIA

Veritas

ISEB

SCP

IISFA

ISM

OMG

Apc

Mile2

Foundry

Huawei

McData

Symantec

TeraData

RedHat

Solar Winds

Blue Coat

Riverbed

 

 
 
Click on name of dumper to view the dump
 
Martin
 
 

70-450
PRO: Designing, Optimizing and Maintaining a
Database Administrative Solution
Using Microsoft SQL Server 2008

 

Hi Friends! The exam is tough but the guide from www.exams.ws was really helpful.


Question no: 1
You work as a database administrator at Abc.com. Abc.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering multiple database servers hosting multiple databases containing company sensitive data. During the course of the day you receive instruction from Abc.com to configure a replication solution for the databases to replicate with each other. Abc.com wants to have the information replicated so the smallest change will trigger immediate replication to the replicated copy. What should you do?
A. You should consider making use of merge replication.
B. You should consider making use of transactional replication.
C. You should consider making use of peer-to-peer replication.
D. You should consider making use of snapshot replication.
Correct Answer is: D


Question no: 2
You work as a database administrator at Abc.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. Abc.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.
Correct Answer is: A


Question no: 3
You work as a database administrator at Abc.com. You are responsible for administering the SQL Server 2008 infrastructure for Abc.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 the performance.
Correct Answer is: D


Question no: 4
You work as a database administrator at Abc.com. Abc.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named ABC-DB01 with an instance that hosts a database named CK_SALES. During the course of the day Abc.com implemented an additional server named ABC-DB02 in a peer-to-peer transactional replication topology. Abc.com additionally wants you to add a new node to the peer-to-peer transactional replication whilst ensuring all relevant transactions are replicated to the new node. What should you do?
A. You should consider configuring the value below for the @sync_type parameter of the sp_addsubscription stored procedure: automatic.
B. You should consider configuring the value below for the @sync_type parameter of the sp_addsubscription stored procedure: replication support only.
C. You should consider configuring the value below for the @sync_type parameter of the sp_addsubscription stored procedure: initialize with backup.
D. You should consider configuring the value below for the @sync_type parameter of the sp_addsubscription stored procedure: initialize from Isn.
Correct Answer is: D


Question no: 5
Abc.com has employed you as a database administrator. Abc.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named ABC-DB01. You are in the process of enabling FILESTREAM on a volume on ABC-DB01. 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.
Correct Answer is: D
Explanation:
This command will format the volume, convert it to NTFS and then label it as BLOBContainer .
This command will also set the NTFS cluster size to 4096. It is important to note that the cluster size must be 4096 or smaller for compression to be enabled for a volume. Finally, the /c parameter will compress the volume. When you are storing the FILESTREAM data, you can store it on a compressed or a non-compressed volume. The data in FILESTREAM is actually stored on the file system. There are a number of benefits to storing the data on the file system. For instance, you will be able to compress data with the NTFS compression capabilities. When the data is stored, it is in compressed form and when the data is retrieved, it is decompressed.
Incorrect Answers:
A: The commands format
B: The commands format
C: The command format F: /FS:NTFS /V:BLOBContainer /A:4096 will not work in this scenario.
This command does not use the /c switch that is required to enable compression. With the execution of this command, only /A: drive will be formatted as a NTFS volume with a 4096 cluster size but without any compression.


Question no: 6
You work as a database administrator at Abc.com. Abc.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named ABC-DB01 with an instance that hosts a database named CK_DATA. During the course of the day you receive instruction from Abc.com to design a RAID solution for the CK_DATA database which has high read/write activity. Abc.com wants you to ensure that the I/O performance of ABC-DB01 is improved whilst ensuring that there is fault tolerance for the database. Abc.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.
Correct Answer is: A
Explanation:
In this scenario, you should use RAID 5 for CK_DATA. RAID 5 will provide good performance throughput and prevent data loss if there is a disk failure. CK_DATA has high read/write activity, and therefore RAID 5 will be a better choice when compared to RAID 0 and RAID 1 in terms of data availability and data protection.
For an ideal SQL Server configuration, you should have a combination of RAID 1 and RAID 5. You should mirror the operating system using RAID 1, and place transaction logs on a RAID 1 that is separate from the RAID 1 that hosts the operating system. SQL Server writes data to the transaction logs and maintains serial information of all modifications that occurred in a SQL database. The transaction log files can be used for rollback and roll forward of information from a SQL Server database. The SQL Server files and filegroups should be placed on a RAID 5, because you get best performance throughput by placing database files on RAID 5 disk array.
Incorrect Answers:
B: You should not use RAID 10 in this scenario. RAID 10 is a better choice than RAID 5, but the scenario states that you have financial constraints. RAID 10 would be more expensive than RAID 5. RAID 10 is a combination of RAID 0+1, which is known as striping with mirroring. You should first mirror disks and then create a stripe set of mirrored disks. This provides high fault tolerance for data and excellent throughput performance.
C: You should not use RAID 1 in this scenario. RAID 1 is known as disk mirroring. You need a minimum of two disks to form a RAID 1 array. One primary disk is used for read/write operations and the data is replicated to the second disk. This RAID level offers better read performance but slower write performance. Therefore, it is not a suitable solution.
D: You should not use RAID 0 in this scenario. RAID 0 is known as disk striping. This RAID level stripes data across disks in the array, offering better throughput on the read/write operations.
However, there is no data protection offered in this RAID level. If one disk fails, the data stored on the disk will be lost. Therefore, this RAID level will not be a suitable solution for CK_DATA database.


Question no: 7
You work as a database administrator at Abc.com. Abc.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named ABC-DB01 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 Abc.com to change the default size of the allocation unit which is set at 4096 bytes. Abc.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.
Correct Answer is: C
Explanation:
When you create a RAID 5 volume, you need to format it to ensure that it is usable for storing data. By default, the allocation unit for a logical unit number (LUN) is 4096 bytes (4 KB) on an NTFS partition. When you are storing data with large files on a RAID 5 volume, you should change the allocation unit to 64 KB, which is 65536 bytes. When you run execute the command format f: / A : 64K /V: Data, you will be able to format the RAID 5 disk with a new allocation unit. In this command, you would need to provide the volume letter, which is f: in this case, the /A :size clause defines the allocation unit size, which is 64 KB in this scenario, and /V: is the volume name.
Incorrect Answers:
A: The format E: /A:4096 /V:Data command will work in this scenario but will result in retaining the default allocation unit size, which is 4096 bytes. To keep the default allocation unit size, you can simply run the format command without specifying the allocation unit size.
B: The format E: /A:4K /V:Data command will not work in this scenario. You would be prompted with Invalid parameter -/A:4K error. You must provide the size of the allocation unit in bytes if the allocation unit size is below 16 KB, for instance, 8192 for 8 KB. For allocation unit sized at 16 KB and above, the value must be written in K, such as 16 KB.
D: The format E: /A:65536 /V: Data command will not work. You would be prompted with Invalid parameter - /A:65536 error upon executing this command. You must provide the size of the allocation unit in KB for 16, 32, and 64 KB. For the value below 16 KB, you must write the value in bytes, for instance, 8192 for 8 KB.


Question no: 8
You work as a database administrator at Abc.com. Abc.com currently makes use of Microsoft SQL Server 2008 for hosting databases. You are responsible for administering a database server named ABC-DB01 with an instance that hosts a database named CK_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. Abc.com wants you to meet the company requirements below:
Abc.com wants to have the SQL Server 2008 configuration optimized to ensure the database remains intact even when a hard disk fails.Abc.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.Abc.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 filegroups.
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 filegroups.
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 filegroups.
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 filegroups.
Correct Answer is: A
Explanation:
You should configure your SQL Server 2008 implementation in the following manner: SQL Server files: RAID 5
Operating System files: RAID 1
Transaction files: RAID 1
To meet varying requirements for response time, data reliability, and performance, you typically use different RAID levels depending on how you are designing the SQL Server deployment. These RAID levels are:
RAID 5: Known as Striping with Parity. The parity information is written across all disks in the array. You need minimum of three disks to form a RAID 5 array. This RAID level offers better read/write performance as long as all disks in the RAID 5 are present. If one disk is missing, the read performance is degraded. RAID 5 stripes data across all disks in the array.
RAID 0: Known as Disk Striping. This RAID level stripes the data across disks in the array, offering better throughput on the read/ write operations. However, there is no data protection offered in this RAID level. If one disk fails, the data stored on the disk will be lost.
RAID 1: Known as Disk Mirroring. You need minimum of two disks to form a RAID 1 array. One primary disk is used for read/write operations, and the data is replicated to the second disk. This RAID level offers better read performance and fault tolerance, but slower write performance than RAID 0.
The scenario states that the database must be functional even if a drive fails in the system. To meet this goal, you must have the operating system files on RAID 1. Using RAID 1, you will mirror the operating system so that even if a disk fails, the operating system will function. The transaction logs should be placed on a separate RAID 1 array. SQL Server writes data to the transaction logs and maintains serial information of all the modifications that occurred in a SQL database. The transaction log files can be used for rollback and roll forward operations from a SQL Server database. To enhance the performance of SQL databases, you should place the transaction log files on a dedicated RAID 1. Finally, the SQL Server files and filegroups should be placed on a RAID 5 array to achieve the best performance throughput.
Incorrect Answers:
B: This configuration uses RAID 0 or disk striping for the operating system. If one disk fails in a RAID 0 array, the database will no longer be online, which is contrary to the goal stated in the scenario. However, placing the transaction logs and SQL Server files and filegroups on RAID 1 and RAID 5 is appropriate.
C: This configuration uses RAID 0 or disk striping for the operating system. If one disk fails in a RAID 0 array, the database will no longer be online, which is contrary to the goal stated in the scenario. However, placing the transaction logs and SQL Server files and filegroups on RAID 1 and RAID 5 is appropriate.
D: You should not use this configuration. It places the operating system and transaction logs on the same RAID 1 disk array, and places the SQL Server files and filegroups on RAID 5. For an appropriate configuration, you should place the operating system and transaction logs on separate RAID 1 arrays. This provides better I/O performance and throughput because the transactions are continuously written to the transaction logs. If there are continuous read/write operations by the operating system on the same RAID 1, then the transaction log performance is degraded.
Therefore, it is always recommended that you place transaction logs on a separate RAID 1.


Question no: 9
You work as a database administrator at Abc.com. You are responsible for administering multiple SQL Server 2008 servers that hosts a multiple databases. These databases contain the networks critical information. You receive the subsequent instructions from the CIO to:Configure replication whereby you are able to send different updates to different subscribers at different locations.Replicate a certain set of information to one subscriber as well as another set to another subscriber.Ensure that subscribers are able to work offline and later synchronize the modifications with the publisher. You thus need to determine the appropriate replication type that will meet the requirements. What should you do?
A. You should consider using Transactional replication.
B. You should consider using Snapshot replication.
C. You should consider using Peer-to-peer replication.
D. You should consider using Merge replication.
Correct Answer is: D
Explanation:
In this scenario, merge replication would be able to meet the required goal. You use merge replication typically when you need to meet the following requirements:
Allow subscribers to modify information in an offline state and then replicate it back to the publisher. A subscriber can also replicate information to other subscribers.
Provide data filtering. In data filtering, you can filter different updates to different subscribers at different locations.
Allow information to be replicated to users who are mobile and are not always connected to the SQL Server.
Provide the ability to resolve conflicts that occur during replication.
Incorrect Answers:
A: You should not use transactional replication. You would typically use this type of replication to propagate incremental changes to from one server to another server immediately. As soon as a change occurs in a database, the data is replicated immediately to its partners. For instance, if there is a row value that changes multiple times, every change will be replicated to its partner. In this type of replication, there are typically fewer subscribers keeping the read-only copy of replicated data. This type of replication does not have the ability to allow subscribers to work offline and then replicate changes when they are back online. This replication also does not have the flexibility to filter data during replication.
B: You should not use snapshot replication. This type of replication is used when you need to replicate a large volume of information. This type of replication does not have the ability to allow subscribers to work offline and then replicate changes when they are back online. This replication also does not have the flexibility to filter data during replication.
C: You should not use peer-to-peer replication. This type of replication is typically used when you need high availability and scalability. This type of replication does not have the ability to allow subscribers to work offline and then replicate changes when they are back online. This replication also does not have the flexibility to filter data during replication.

70-450


 

 

 

Braindumps Real exam questions and verified answers - 100% passing guarantee - cheap prices.

 

Free brain dumps Braindumps, notes, books for free

 

Braindumps and Exams - Instant download real exam questions - Passing guarantee.

Follow us on FaceBook
Braindumps on Facebook
 
 
 
 
 

CheckPoint

Linux

Novell

DB/2

Network Appliance

EC-Council

Nortel

McAfee

Juniper

ISACA

PMI

Sybase

EMC

HDI

SNIA

ISC

Sair

IBM

Lotus

Exam Express

3COM

BICSI

DeLL

Enterasys

Extreme Networks

Guidance Software

Computer Associates

Network General

SAS Institute

Alcatel Lucent

SeeBeyond

TruSecure

Polycom

Hyperion

Hitachi

Nokia

Fortinet

Vmware

Fujitsu

Tibco

Intel

PostgreSQLCE

BusinessObjects

RESSoftware

BlackBerry

AccessData

ICDL

Isilon

SAP

The Open Group

ACSM

Altiris

Avaya

Cognos

F5

Genesys

SDI

ACI

ASQ

Google

H3C

HIPAA

HRCI

SOA

IIBA

Zend