|
Braindumps of 70-443
PRO: Designing a Database Server
Infrastructure by Using Microsoft SQL
Server 2005
Exam Questions, Answers,
Braindumps 70-443)
I
had enjoyed the paper after getting help from the
dumps of
www.braindumps.org. Here is my contribution.
Question: 1
You
need to set up the Bid_Archive database. What should you
do?
A.
Configure merge replication to move the data between the
Bids and Bid_Archive databases.
B.
Set up DML triggers to move rows from the Bids database
to the Bid_Archive database when
the
Completed column in the Bid_Tracking table is set to 1
and the Successful column is set
to 0.
C.
Configure snapshot replication to move all data from the
Bids to the Bid_Archive database.
D.
Create a job that is scheduled to run every hour to
check for rows in the Bid_Tracking table
where
the Completed column is set to 1 and the Successful
column is set to 0.
Answer: B
Question: 2
You
need to identify the combinations of the Windows
operating system and SQL Server 2005
version that will be the most appropriate for the new
R&D configuration, which will include the
Research, Parts, and Engineering databases. Which two
combinations will be the most
appropriate? (Each correct answer presents a complete
solution. Choose two.)
A.
Windows Server 2003 Enterprise Edition with SQL Server
2005 Enterprise Edition
B.
Windows Server 2003 Datacenter Edition with SQL Server
2005 Enterprise Edition
C.
Windows Server 2003 Standard Edition with SQL Server
2005 Enterprise Edition
D.
Windows Server 2003 Enterprise Edition with SQL Server
2005 Standard Edition
Answer: A, D
Question: 3
Your
account name is Pat and you are a member of the db_owner
database role. You have the
permissions that are required to create the assembly for
the new custom application that
manages the replication for the Customer database. You
need to minimize the attack surface on
the
server, while creating the assembly for the CLR to use.
You need to ensure that your solution
fulfills the companys security requirements. Which two
options should you use? (Each correct
answer presents part of the solution. Choose two.)
A.
WITH PERMISSION_SET = External_Access
B.
WITH PERMISSION_SET = Unsafe
C.
WITH PERMISSION_SET = Safe
D.
AUTHORIZATION dbo
E.
AUTHORIZATION Pat
Answer: A, E
Question: 4
You
are a member of the DBAdmins group. You need to
configure the HTTP endpoints for the
new
Web services application that will access the Customer
database. You want to accomplish
this
goal by using the minimum amount of administrative
effort, while fulfilling the companys
technical requirements. Which two actions should you
perform? (Each correct answer presents
part
of the solution. Choose two.)
A.
Install Internet Information Services (IIS) 6.0 on
CompanyB.
B.
Create an implicit namespace reservation while executing
the CREATE ENDPOINT
command.
C.
Ask the Windows administrator to create an explicit
namespace reservation for the HTTP
endpoint.
D.
Assign the Control permission on the endpoint to all
users that will use the Web services
application.
E.
Assign the Connect permission on the endpoint to all
users that will use the Web services
application.
Answer: C, E
Question: 5
You
need to define the data type and the table options for a
new column named AnnualReview in
the
HR database. Which two options should you select? (Each
correct answer presents part of
the
solution. Choose two.)
A.
Use the text data type.
B.
Use the nvarchar(max) data type.
C.
Use the varchar(max) data type.
D.
Set the large value types out of row option to Off.
E.
Set the large value types out of row option to On.
F.
Set the text in row option to Off.
G.
Set the text in row option to 7000.
Answer: B, E
Question: 6
DRAG
DROP
Your
boss, Mrs. Company, wants you to design the backup
schedule for the Customer database.
Not
all locations have to be filled.
Answer:
Question: 7
You
need to design the consolidation plan for CompanyA,
CompanyB, and CompanyC. You need
to
identify the appropriate combination of SQL Server
instances and SQL Server 2005 computers
that
are needed to fulfill the companys consolidation plans
and security requirements. Which
combination should you use?
A.
one SQL Server 2005 computer with one instance
B.
two SQL Server 2005 computers, each with two instances
C.
two SQL Server computers, one with one instance and one
with three instances
D.
one SQL Server 2005 computer with two instances
Answer: D
|
