Testking microsoft Mcdba 70-228 Exam

testking Microsoft: 70-228 Exam
Questions & Answers 70-228 – Questions & Answers
Interactive Testing Engine Included!
150 Questions
Updated : 03/11/2008
Price : $65.99 $59.99
Study Guides 70-228 – Study Guides
Updated : 03/09/2008

Testking Materials do not contain actual questions and answers
from Microsoft’s Certification Exams
Testimonials
Tetimonial – MS 070-228

Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

Candidates for this exam operate in medium to very large computing environments that use Microsoft SQL Server 2000 Enterprise Edition. Candidates have at least one year of experience administering SQL Server.

When you pass the Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition exam, you achieve Microsoft Certified Professional status. You also earn credit toward the following certifications:
• Core credit toward Microsoft Certified Database Administrator on Microsoft SQL Server 2000 certification
• Elective credit toward Microsoft Certified Systems Engineer on Microsoft Windows 2000 certification
• Elective credit toward Microsoft Certified Systems Engineer on Microsoft Windows NT 4.0 certification
• Elective credit toward Microsoft Certified Systems Administrator on Microsoft Windows 2000 certification

Exam Topics Include:
• Installing and Configuring SQL Server 2000
• Creating SQL Server 2000 Databases
• Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases
• Extracting and Transforming Data with SQL Server 2000
• Managing and Monitoring SQL Server 2000 Security
• Managing, Monitoring, and Troubleshooting SQL Server 2000

Question No: 1 During the same week, two users at Fabrikam modify the same account record. On Monday
morning, Jon goes offline with his Laptop client. The offline data includes the account record for Contoso Inc.
Later he changes Contoso’s phone number to 555-0176 on his laptop.
On Tuesday, Anu uses the web client to update the Contoso account record. She sets the phone number to
555-0134, and the fax number to 555-0100. She also changes the Web Site from http://contoso to

http://www.contoso-inc.com.

On Thursday, Jon takes his Laptop client online. No other modifications are made to the data. What
data is stored in the account record for Contoso Inc on Friday?
A. Phone number: 555-0134. Fax number: 555-0100. Web Site: http://www.contoso-inc.com
B. Phone number: 555-0134. Fax number: 555-0199. Web Site: http://www.contoso-inc.com
C. Phone number: 555-0176. Fax number: 555-0199. Web Site: http://www.contoso-inc.com
D. Phone number: 555-0176. Fax number: 555-0199. Web Site: http://contoso

Question No: 3 The Small Business Edition of Microsoft CRM 3.0 has some extra features not included in the
Professional Edition. Which of the following features does the Small Business Edition include? Choose the 2
that apply. Answer: C
Question No: 2 You are the IT administrator for your organization and you are planning the installation of
Microsoft CRM 3.0. The server you will use for Reporting Services is called REPORTS, and you will specify
this name when you install Microsoft CRM 3.0. The project sponsor has asked for a number of customized
reports to be developed, and has also asked you to ensure that all report data is kept confidential when
transferred over the network. What needs to be in place on server REPORTS before you can successfully
install CRM while fulfilling the security requirements? Each answer provides part of the solution. Choose the
2 that apply.
A. There must be an SSL certificate installed.
B. IIS must be installed on the server.
C. .NET Framework 1.0 must be installed.
D. CryptoAPI tools must be installed.
Answer: A, B

Question No: 3 The Small Business Edition of Microsoft CRM 3.0 has some extra features not included in the
Professional Edition. Which of the following features does the Small Business Edition include? Choose the 2
that apply.

A. Announcements automatically synchronized onto http://companyweb.
B. Small Business Server Console Integration
C. Fax Server Integration
D. POP3 Connector Manager Integration
Answer: B, C
Question No: 4 You have developed a custom entity called Resellers, which holds information about resellers
who work with Trey Research. In addition, you have created four custom reports which include reseller
information. Your manager asks you to include a new field on the custom entity, and also to include this field
on two of the custom reports. What actions do you need to take? Choose the best answer.

Question No: 4 You have developed a custom entity called Resellers, which holds information about resellers
who work with Trey Research. In addition, you have created four custom reports which include reseller
information. Your manager asks you to include a new field on the custom entity, and also to include this field
on two of the custom reports. What actions do you need to take? Choose the best answer.
A. Amend the custom entity, amend the filtered view, and amend the custom report.
B. Amend the custom entity, publish the custom entity, and amend the custom report.
C. Amend the custom entity, and amend the custom report.
D. Amend the custom entity, publish the custom entity, amend the filtered view, and amend the custom report.
Answer: C
Question No: 5 You are a developer specializing in writing reports using SQL 2000 Reporting Services. Your
manager has asked you to develop some new reports required by senior management. What software do you
need on your computer in order to develop the reports?

A. Report Manager and Report Designer.
B. Report Manager.
C. Visual Studio .NET 2003 and Report Designer.
D. Report Designer.
Answer: C
Question No: 6 Microsoft CRM provides the ability to generate e-mail activities and route them to a
common area so that any one of a set of users can access the activities. What is the name given to this object?
A. Business Unit
B. Queue

C. Site
D. Team
Answer: B
Question No: 7 You are planning the deployment of Microsoft CRM 3.0 for Fabrikam Inc. Fabrikam supports
charity fundraising initiatives by deploying configured servers and laptop computers to charities, so that they
can conduct telephone campaigns and employ mail merge functionality for direct mail campaigns. Fabrikam
customers have shifts of telesales operators using the same computers. You need to select the most appropriate
Microsoft CRM client for Fabrikam. What should you do?
A. Deploy the Microsoft CRM laptop client for Outlook for all telesales staff.
B. Deploy the Microsoft CRM desktop client for Outlook for all telesales staff.
C. Deploy the Microsoft CRM laptop client for Outlook on a Terminal Services server, and instruct all
telesales staff to connect to the Terminal Services server.
D. Instruct all telesales staff to use the web browser client.
Answer: B
Question No: 8 As part of the Microsoft CRM 3.0 installation process, the Environmental Diagnostic
Wizard conducts various checks to ensure a smooth installation. Which of the following are checked?
Choose the 3 that apply.
A. Active Directory Domain Model
B. Available disk space on the Microsoft CRM server
C. Whether the SQL Server Agent is running on the SQL Server
D. Whether the DNS Server is accessible
Answer: B, C, D
Question No: 9 You are about to install Microsoft CRM 3.0 on Small Business Server 2003 machine.
Which of the following services must be started on this machine before installation can proceed? Choose
the 2 that apply.
A. Microsoft Exchange Information Store
B. Indexing Service
C. SQLSERVERAGENT
D. Windows Installer

Donwload Free PassGuide Braindumps-The Most Realistic Practice Questions and Answers,Help You Pass any Exams

Answer: B, C
Question No: 10 Your organization’s sales team uses Microsoft CRM to send e-mails containing sales
literature to prospects that are identified by the Telemarketing division. Which of these out-bound e-mails
sent by the sales team via Microsoft CRM are processed by the Microsoft CRM 3.0 Exchange E-mail
Router?
A. Emails sent via the Microsoft CRM clients for Outlook.
B. Emails sent via the Microsoft CRM web client.
C. Emails sent via Outlook Web Access.
D. No out-bound email messages sent via Microsoft CRM are processed.
Answer: D

1.You are the administrator of a SQL Server 2000 computer. You import a large amount of data into the
Contracts database. After the import, you perform a full database backup. You examine the hard disk and discover
that the log file has grown from 200 MB to 800 MB.
You want to recover disk space as quickly as possible without losing backup information. Which two
Transact-SQL statements should you execute? (Each correct answer presents part of the solution. Choose two.)
A. BACKUP LOG Contracts WITH no_log
B. BACKUP LOG Contracts WITH truncate_only
C. BACKUP LOG Contracts To disk=’E:\SQLBackup\Contracts_Log.bkp’
D. ALTER DATABASE Contracts
(Name=Contract_Log.ldf,
FILENAME=’E:\Data\Contracts.ldf’,
SIZE=200)
E. DBCC ShrinkDatabase (Contracts, 200)
F. DBCC ShrinkFile (Contracts_Log, 200)
Answer: CF

2.You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The
database has a Parts table that has a field named InStock.hen parts are shipped, a table named PartsShipped is
updated. When parts are received, a table named PartsReceived is updated. The relationship of these tables is
shown in the exhibit. (Click the <<ItemExhibitName>> button.)
You want the database to update the InStock field automatically. What should you do?
A. Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.
B. Create a user-defined function that calculates  current inventory by running aggregate queries on the
PartsShipped and PartsReceived tables.
C. Use a view that creates an InStock field as part of an aggregate query.
D. Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the
InStock field in the Parts table.Use these procedures exclusively when modifying data in the PartsReceived and
the PartsShipped tables.
Answer: A

3.You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory
application. The hard disks on your server are configured as shown in the exhibit. (Click the
<<ItemExhibitName>> button.)
The operating system files are located on drive C. Your database will store a maximum of 6 GB of data and
requires a maximum of 2 GB of disk space for the transaction log.You want to optimize database performance.
What should you do?

A. Add a 2-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F.
B. Add a 1-GB transaction log to drive C, a 1-GB transaction log to drive D, a 3-GB data file to drive E, and a
3-GB data file to drive F.
C. Add a 1-GB transaction log to drive E, a 1-GB transaction log to drive F, a 3-GB data file to drive E, and a
3-GB data file to drive F.
D. Add a 2-GB transaction log to drive F, a 3-GB data file to drive D, and a 3-GB data file to drive E.
Answer: A
5.You are the administrator of a SQL Server 2000 computer. When you arrive at work, you learn that power to the
server has been interrupted.You need to find out whether the power loss damaged the databases on the server. You
also need to correct any damage that occurred as quickly as possible. You have valid backups of each database
previous to the power loss.What should you do?
A. Select the  torn page detection  option for each  database.If torn pages are detected, execute the DBCC
CHECKDB statement, and specify the REPAIR_FAST option.
B. Execute the Sp_table_validation stored procedure for all tables in each database.If errors are detected, restore
each damaged database from the most recent backup.
C. Execute the DBCC CHECKDB statement, and specify the PHYSICAL_ONLY option.If errors are detected,
execute the DBCC DBREPAIR statement for each damaged database.
D. Execute the DBCC CHECKDB statement, and specify the PHYSICAL_ONLY option.If errors are detected,
resto
C. Drop both indexes from the Students table before using the BULK INSERT statement.Re-create the indexes
when the data load is complete.
D. Drop the nonclustered index from the Students table before using the BULK INSERT statement.Re-create the
nonclustered index when the data load is complete.
E. Drop the clustered index from the Students table before using the BULK INSERT statement.Re-create the
clustered index when the data load is complete.
Answer: AD

7.You are the administrator of a SQL Server 2000 computer at your company’s warehouse. All product orders are
shipped from this warehouse. Orders are received at 30 sales offices. Each sales office offers a range of products
specific to its region.Each sales office contains one  SQL Server 2000 computer. These servers connect to the
warehouse through dial-up connections as needed, typically once a day. Each sales office needs data pertaining
only to its region.You need to replicate inventory data from the server at the warehouse to the servers at the sales
offices. You want to minimize the amount of time needed to replicate the data.
Which three actions should you take? (Each correct answer presents part of the solution. Choose three.)
A. Create one publication for each Subscriber.
B. Create one publication for all Subscribers.
C. Enable horizontal filtering.
D. Enable vertical filtering.
E. Use pull subscriptions.
F. Use push subscriptions.
Answer: ACE

8.You are the administrator of a SQL Server 2000 computer named CorpSql. The server is a member of a
Microsoft Windows NT domain named CORPDOMAIN. CorpSql is configured for Windows Authentication and
contains three databases named Sales     Finance  and  Research Sophie is an administrative assistant in your
company. She uses a suite of client/server applications to access all three databases on CorpSql. Sophie transfers
to a different department within the company and requires access only to the   Research database. Her former
manager requests that you remove Sophie’s access to the Sales And    Finance databases.
You need to configure the appropriate permissions for Sophie. Which batch of Transact-SQL statements should
you execute?
A. USE Finance re the database from the most recent backup.
Answer: D
6.You are the database administrator for a university. You are migrating a database from an old database
management system to SQL Server 2000. You export student data from the database to a text file. All students
have unique ID numbers. In the file, the student data is ordered according to these ID numbers.
On the server, you create a table named Students. You create indexes on the Students table as shown in the
following output.
index_description                       index_keys
nonclustered                           lastName, firstName
clustered, unique, primary key             studentID
You want to load the student data into the new database as quickly as possible by using the BULK INSERT
statement. Which two actions should you take? (Each correct answer presents part of the solution. Choose two.)
A. Specify an ORDER clause.Sort the student ID numbers in ascending order.
B. Specify an ORDER clause.Sort the student ID numbers in descending order.

Free down:testking microsoft Mcdba 70-228 Exam

Free Down:Pass4sure mcdba 70-228 v2.73

password:www.testking.name

High quality IT Certification Training Exam Questions, Study Guides and Practice Tests are in Downloadable PassGuide Testing Engine,Successful for IT Certification or Full Refund for you.Contact Us:Sales@PassGuide.com

Type	Exam Bible	New Questions & Answers	Latest Updated	Download link
PDF	All Certbible 's Exam Dumps	597	1 days ago	Available

PassGuide Training Materials & Practice Tests

• Testking mcicrosoft Mcdba 70-441 Exam
• Testking Microsoft Mcdba 70-431 Exam
• Testking mcse mcdba 70-293 Exam
• Testking Microsoft Mcdba certification training Exam
• Testking mcse mcdba 70-290 exam
• Testking microsoft Mcdba mcse 70-291 Exam
• Testking microsoft Mcdba 70-229 Exam
• free testking examways Microsoft Certification exam
• All TestKings for MicroSoft
• Microsoft Certified Database Administrator (MCDBA)