|
Question 1.
You need to ensure that old data and current data can be queried according to the business requirements. What should you do?
A. Specify a view based on the archival data table and current data tables.
B. Specify that the data must be queried by using a stored procedure.
C. Specify that both the archival data table and the current data tables must have indexes created
on the same columns.
D. Specify that a SQL Server Agent job must be used to copy current data into the archival data
table each night.
Answer: A
Question 2.
You need to design the Service Broker queues that will be used to submit requests for long running reports. Your solution must minimize complexity of using the queues by applications.
What should you do?
A. Specify one queue for each client application that can submit report requests.
B. Specify one queue for each of the two report-generation services.
C. Specify one queue for all long-running report requests.
D. Specify eight queues: One for each service, and one for each client application.
Answer: B
Question 3.
You need to ensure that database schema changes in branch offices result in the proper notifications.
What should you do?
A. Install Notification Services on all branch office servers, and configure Notification Services to
use a local notifications database.
B. Specify that all SQL Server log files must be archived and sent by e-mail to the main office.
C. Implement DML triggers that use Database Mail to send an e-mail message about the DML
activity.
D. Implement DDL triggers that use Database Mail to send an e-mail message about the DDL
activity.
Answer: D
Question 4.
You need to ensure that the Cust_CalcData column is implemented appropriately.
What should you do?
A. Specify that the Cust_CalcData column must be implemented as a computed column of the
table.
B. Specify that the Cust_CalcData column must be indexed using a non-clustered index.
C. Specify that the Cust_CalcData column must be implemented as a column that uses a user
defined data type.
D. Specify that the Cust_CalcData column must be updated by a SQL Server Agent job that runs
nightly.
Answer: A
Question 5.
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 6.
You need to ensure that the performance of the Research_Aggr view is optimized.
What should you do?
A. Specify that access to the view must be made only through a stored procedure.
B. Specify that indexes must be created on the views Data1 and Data2 columns.
C. Specify that indexes must be created on the base table columns that contain the data that is
used by the calculations in the Data1 and Data2 columns.
D. Specify that indexes that are present on the view must be rebuilt each month, with a fill factor
of 50 percent.
Answer: B
Question 7.
You need to ensure that the process for identifying when the server hardware is approaching full utilization fulfills the business requirements.
What should you do?
A. Use SQL Trace to log the activity on the servers to a log file.
B. Use Performance Logs and Alerts to log the activity on the servers to a log file.
C. Instruct the end users to report when application response time decreases.
D. Check the Windows event log for errors or warnings that are produced due to high utilization.
Answer: B
Question 8.
Currently the Complex Calc column in the Results table is updated by a Transact-SQL trigger that calls the COM component by using the sp_OA* extended stored procedures. You want to migrate this process to a solution that does not use sp_OA* and that requires the minimum amount of development and testing time.
What should you do?
A. Write a new extended stored procedure in Microsoft Visual C++ to call the COM component.
Write a Transact-SQL trigger that calls this extended stored procedure to update the Complex
Calc column.
B. Rewrite the COM component in a managed code language. Write a managed trigger to call the
new managed component to update the Complex Calc column.
C. Create a stored procedure in a managed code language to call the COM component and insert
the data into the Complex Calc column or update the Complex Calc column.
D. Create a user-defined function in a managed code language to call the COM component.
Write a Transact- SQL trigger to call the new managed function to update the Complex Calc
column.
Answer: D
Question 9.
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
Question 10.
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.
|
Question 1.
An administrator created a template of a Microsoft Windows XP SP3 virtual machine (VM) and now needs to modify it.
How can the administrator modify the template?
A. Export the template from the XenServer host, import it to another system, power it on and
Make the changes
B. Power on the VM template, make the changes and save the template
C. Create a new VM based on the original template, make the changes to the new VM and turn
the new VM into the new template
D. Put the XenServer host in Maintenance mode, make the changes to the VM template and then
exit Maintenance Mode
Answer: C
Question 2.
Which step requires an administrator to enable maintenance mode on a XenServer host?
A. Creating Fibre Channel storage repositories
B. Enabling high availability
C. Creating NIC bonds
D. Enabling storage multipathing
Answer: D
Question 3.
Which storage repository type allows an administrator to create a new storage repository that does not erase any existing data on the specified storage target?
A. EQUAL
B. NFS
C. EXT
D. NetApp
Answer: B
Question 4.
What must an administrator configure on the pool master to allow migration of virtual machines (VMs) between servers in the pool?
A. Shared Storage
B. NIC bond
C. High availability
D. Management Interface
Answer: A
Question 5.
Which is a valid MAC address?
A. 6A:70:A0:5E:D0
B. 255.255.255.255
C. 6A:70:A0:5E:D0:04
D. 127.0.0.1
Answer: C
Question 6.
DRAG DROP
An administrator needs to connect a network to an external VLAN using the command line interface (CLI). Click the Task button to place the steps necessary to connect a network to an external VLAN using the CLI in the correct order. Click the Exhibit button for instructions on how to complete a Drag and Drop item.
Answer:
Question 7.
DRAG DROP
Click the Task button to place the steps in the correct order for an administrator to configure multipathing using XenCenter. Click the Exhibit button for instructions on how to complete a Drag and Drop item.
What is the correct order of steps for the configuration of multipathing using XenCenter?
Answer:
Question 8.
Which two XenServer CLI commands are valid? (Choose two.)
A. Pool-ha-enable
B. Pool-backup
C. Pool-recover-slaves
D. Pool-create-pool
Answer: A, C
Question 9.
An administrator recently created an ISO library for a XenServer environment. The administrator now wants to make the ISO library available to all XenServer hosts.
What must the administrator do before the ISO library can be attached using XenCenter?
A. Copy the ISO library to the control domain
B. Build a directory to copy the ISO library into
C. Make an exploded network repository using FTP
D. Create an external NFS or CIFS share directory
Answer: D
Question 10.
An organization has a single installation of XenServer Enterprise Edition 4.0. The administrator plans to upgrade the host to version 5.0.
Which upgrade path should the administrator take?
A. Upgrade XenCenter to 5.0 and use the Updates Manager
B. Upgrade directly from version 4.0 to version 5.0
C. Upgrade to version 4.1 and then upgrade to version 5.0
D. Upgrade the XenServer using Emergency Mode
Answer: C
Question 11.
How can an administrator enable a Virtual Machine (VM) to connect to resources available through a physical NIC on a XenServer host?
A. Add a new external network
B. Use the XenServer management NIC
C. Add a new internal network
D. Use VLAN 0
Answer: A
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.