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
 

Kameron

Micheal Noah

 
 

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

 

 

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