Certidea 70-441 exam questions and answers

Microsoft
70-441
Designing Database Solutions by Using MS SQL Serv
2005
The
h fo
f l
o l
l o
l w
o in
i g
n s
g are
r so
s m
o e ti
t p
i s
p mad
a e
d fo
f r
o yo
y u
o ,
u we re
r co
c m
o men
e d
n
yo
y u
o
to
t
re
r ad
a th
t e
h m ca
c re
r fu
f l
u l
l y
l
si
s n
i c
n e
c
th
t e
h y ca
c n he
h lp
l yo
y u
o le
l a
e rn
r be
b tt
t e
t r.
r
Do
D '
o s and
n Don
o '
n t
' s
Do’s: Study our products rather than just remember the questions and answers. Certidea
materials are strictly selected by our experts according to the official standards. After studying
them you can enhance your ability.
Don’ts: Do not go through our products just once. You should make sure you can have
enough time to master our materials in case you have missed something. We guarant ee that
you can pass your exam after fully studying our products.
Pro
r m
o pt
p Up
U d
p a
d te
t
You can rest assured that every Certidea product is of the latest version. We are constantly
updating our products to make sure our quality. You can enjoy a 120-day free update after the
purchase and you should check your member zone at Certidea an update 3-4 days bef ore the
scheduled exam date.
Deve
v l
e o
l p
o m
p ent
n
If you have some complaints or suggestions, please let us know. No matter what is the
problem, we are eager to hear from our customers to develop ourselves. You can contact us
at feedback@Certidea.com and should include the following s: exam number, version, page
number, question number, and your login ID. We will solve your problems as soon as possible.
Certidea--Lead Your Way to Certif icates
----------------------------------------------------------------------------------------------------------------------
Sales and Support Manager
Sales Team: sales@Certidea .com
Support Team: support@Certidea .com
---------------------------------------------------------------------------------------------------------------------
Co
C p
o y
p r
y i
r g
i h
g t
h
A unique serial number associated with your particular name and contact information is
contained in each PDF file for security purposes. So if we find you have distributed a
particular PDF file, Cert idea reserves the right to take legal action against you according to
the International Copyright Laws.
Lead your way to certificates!

---

Question：1
You need to provide analyst reporting capabilities that fulfill the business requirements. What
should you do?
A: Add a Report Viewer control to APP3.
B: Add an Internet Explorer ActiveX control to APP3. Set the controls URL to the A. Datum
Corporation Report
Manager.
C: Create a hyperlink in APP3 that ref erences the Report Manager.
D: Create a proxy class to the Report Server Web service.
Answer: A
Question：2
You need to ensure that survey customers are automatically notified when their survey results
are available. You must also ensure that customers can manage their own recipient lists.
Which two actions should you perform?
(Each correct answer presents part of the solution. Choose two.)
A:Create a Subscription Management interface that will allow customers to modify their
recipient lists.
B:Create a custom Notification Services Content Formatter to send an e-mail message to
customers when their survey results are available.
C:Create a custom Notification Services Event Provider to send an e-mail message to
customers when their survey results are available.
D:Create a Notification Services custom delivery protocol to send an e-mail message to
customers when their survey results are available.
E:Create Notification Services Event rules to send an e-mail message to customers when
their survey results are available.
Answer: A, E
Question：3
You need to provide ad hoc reporting capabilities to fulfill business requirements. What should
you do?
A: Create a SQL Server Reporting Services (SSRS) report. Enable customers to modify the
report by using Report Builder.
B: Create an ASP.NET application that will enable customers to view and modify reports by
calling the SQL Server Reporting Services (SSRS) API.
C: Create an ASP.NET application that will enable customers to view and modify reports by
using a SQL Server Reporting Services (SSRS) ActiveX control.
D: Create a SQL Server Reporting Services (SSRS) Report Model. Enable customers to
modify reports based on the model by using Report Builder.
Lead your way to certificates!

---

Answer: D
Question：4
You are designing a performance monitoring plan for the database that supports APP1. You
need to monitor only necessary indicators. Which indicator or indicators should you include in
the baseline? (Choose all that apply.)
A:response times for frequently used queries
B:database backup and restore completion times
C:disk I/O
D:CPU utilization
E:network packet size F:SOAP requests failed
G:HTTP authenticated requests
Answer: A,C,D
Question：5
You need to ensure that branch office database administrators cannot view the source code
of database objects. What should you do?
A: Specify that the database permissions on database objects must deny all access to the
administrators.
B: Specify that all database objects must be stored in a secondary database file. Conf igure
NTFS permissions on this file to deny access to the administrators.
C: Specify that all database objects must be encrypted.
D: Specify that all database objects must be written in managed code.
Answer: C
Question：6
You are upgrading the database servers that are used by all of the companys applications. As
the first step in the upgrade, you upgrade the development database servers. You need to
verif y that the upgrade of the database
servers did not introduce any errors into the databases. What should you do?
A: Execute unit test scripts for each stored procedure in each database.
B: Execute the stored procedures in the SQL Server Management Studio debugger, and
verif y the results.
C: Set the database compatibility level on the database servers to 80.
D: Execute the application user interface test scripts to verif y proper operation.
Answer: A
Lead your way to certificates!

---

Question：7
You need to cleanse and standardize the data on potential survey participants prior to
inserting it into the staging database. What should you do?
A: Import the data into a staging table by using the OPENROWSET BULK statement. Execute
a Transact-S QL
stored procedure to cleanse the data and to insert the data into the database.
B: Import the data into a staging table by using the BULK INSERT statement. Execute a
Transact-S QL stored procedure to cleanse the data and to insert the data into the database.
C: Create a SQL Server Integration Services (SSIS) package to import, standardize, and
cleanse the data.
D: Create a CLR stored procedure to import the data into a staging table, to cleanse and
standardize the data, and to insert the data into the database.
Answer: C
Question：8
You need to minimize the size of the Notification Services database. What should you do?
A: Specify a one-day retention period for alerts and notifications in the Notification Services
database.
B: Specify that the Notification Services database must receive a full backup once each week.
C: For the Notification Services database, specify a recovery model that truncates transaction
logs on a regular basis.
D: Design a maintenance plan for the Notification Services database that shrinks the
database monthly.
Answer: A
Question：9
You need to ensure that the testing of the SSIS packages fulfills the business requirements.
What should you do?
A: Specify that packages must be run, using standard sample data, on a test server.
B: Specify that packages must be run on the production database.
C: Specify that the packages must be run, using actual customer data, on a test server that
contains a copy of the production database.
D: Specify that packages must be run on the production database after a full backup of the
production database is made.
Answer: C
Question：10
Lead your way to certificates!

---

You need to ensure that SSIS packages that are used to import new customer data do not
create unacceptable performance. What should you do?
A: While packages are running, modify the thread priority of the SQL Server Agent service to
Low.
B: While packages are running, modify the thread priority of the SQL Server service to Low.
C: Specify that packages must be designed to use only a single thread of operation.
D: Schedule packages to run outside of normal office hours.
Answer: D
Lead your way to certificates!

---