|
Braindumps of 70-441
Designing Database
Solutions by Using MS SQL Server 2005
Exam Questions,
Answers, Braindumps (70-441)
This braindump will be helpful to you. Try it.
Question: 1
You need to design a
solution for deploying the database to new stores as
they are opened. Your solution must minimize the number
of steps that are required to make the database ready
for use
in the production
environment. What should you do?
A. Replicate the database
schema and all lookup data from an existing server to
new servers.
B. Detach the database on an
existing server, copy the database files to new servers,
and
attach the copies on the new
servers. Reattach the database on the existing server.
C. Use SQL Server
Integration Services (SSIS) to copy the entire database
from an existing server to new servers.
D. Back up the database on
an existing server, and restore the backup to new
servers.
Answer: A
Question: 2
You need to ensure that
products that have an inventory below the specified
threshold are not included in the exported XML data that
is sent to distributors. Your solution must require the
minimum number of changes to any existing database
objects. What should you do?
A. Write a stored procedure
that accepts all inventory changes and that removes
products from the database when product inventory falls
below the specified threshold.
B. Write a trigger on the
inventory table that updates the exclusion bit column
whenever
inventory changes are made.
C. Write a SQL Server Agent
job that updates the exclusion bit column based on
current
inventory.
D. Write a user-defined
function that updates the inventory table and the
exclusion bit column, and ensure that all database
objects that update inventory use the new function.
Answer: B
Question: 3
You need to design a report
that provides consolidated inventory information from
selected stores. The report must be designed so that it
will display aggregated inventory from only those stores
that are selected by the user. Your solution must
minimize additional network utilization.
What should you do?
A. Use SQL Server
Integration Services (SSIS) to copy all inventory data
from all servers into a single temporary table. Design
the report to use the temporary table as its data source
and to filter out data from stores that are not
selected.
B. Implement replication so
that all servers contain the inventory data from all
other servers.
Design the report to use the
server that is at the same location as the user who is
running the report.
C. Create a parameterized
stored procedure that queries the required inventory
data and returns the results in a single result set.
Design the report to use the stored procedure as its
data source.
D. On each server, create a
view that displays that servers inventory data. Design a
report that uses the view from each server as a data
source for the report and filters out data from stores
that are not selected.
Answer: C
Question: 4
You need to design a
solution for importing weather-related data from the
legacy system into the new weather database tables. What
should you do?
A. Write a SQL Server
Integration Services (SSIS) package to import the data.
B. Write a Windows Forms
application to import the data.
C. Use the bcp utility to
import the data.
D. Write a managed assembly
to import the data.
E. Write a view that uses
linked servers to query the data from the ODBC database.
Answer: A
Question: 5
You need to design a
solution for controlling changes to database objects on
the SQL Server database servers. Your solution must
comply with existing company policies and procedures.
What should you do?
A. Require developers to
check in all code changes to a source control database.
B. Create a single database
user account that has permission to change database
objects.
C. Give one developer
permissions to change database objects, and enable
logging of those changes on the server.
D. Disable replication of
database objects between servers.
Answer: B
Question: 6
You need to ensure that
proper business logic is used when data is provided to
reports, so that the reports contain the correct data.
What should you do?
A. Write a Windows
application that queries the appropriate data and builds
a new table
containing this data.
Program SSRS to use the new table as a data source.
B. Use SQL Server
Integration Services (SSIS) to copy production tables
into reporting tables on the same server. Program SSRS
to obtain data from the reporting tables.
C. Program SSRS to obtain
data by using appropriate Transact-SQL queries.
D. Write one or more
parameterized stored procedures that return data.
Program SSRS to use the stored procedures and the
correct parameters to query data for reports.
Answer: D
Question: 7
To improve performance, you
need to redesign the StoreReports view, which provides
access to aggregated data. What should you do?
A. Use a language that
supports the .NET Framework to rewrite the view as a
stored procedure.
B. Use Transact-SQL to
rewrite the view as a stored procedure.
C. Add indexes to the view.
D. Add indexes to the
underlying tables that constitute the view.
Answer: D
Question: 8
You need to ensure that all
orders are entered with complete, consistent, and
accurate
information. What should you
do?
A. Write a parameterized
stored procedure. Modify any application or object that
enters orders so that it will enter orders by using the
new stored procedure.
B. Write a COM object that
enters orders directly into the appropriate tables.
Modify any
application or object that
enters orders so that it will enter orders by using the
new COM
object.
C. Write a managed assembly
that enters orders directly into the appropriate tables.
Modify any application or object that enters orders so
that it will enter orders by using the new assembly.
D. Modify the permissions of
the tables that contain order information so that no end
users have direct access to the tables.
Answer: A
|
