|
Question 1.
You are a database developer for Company.com A routine that processes orders for the city of Stockholm must be optimized for better performance.
The current routine is shown in the following code segment.
...
DECLARE OrderCursor CURSOR FOR
SELECT OrderID, City, CustomerID FROM Orders;
OPEN OrderCursor;
FETCH NEXT FROM OrderCursor INTO @OrderID, @CustomerID, @City;
WHILE(@@FETCH_STATUS = 0)
BEGIN
IF(@City <> 'Stockholm')
GOTO Next;
<Code for processing order>
Next:
FETCH NEXT FROM OrderCursor INTO
@OrderID, @CustomerID, @City;
END
...
You need to optimize the routine for the greatest performance. What should you do?
A. Change the IF statement to check for @City = 'Stockholm' to eliminate the need for the
GOTO statement.
B. Change the SELECT statement in the cursor to includeWHERE City = 'Stockholm'.
C. Change the cursor to be declared as STATIC.
D. Change the cursor to be declared as KEYSET.
E. Change the cursor to be declared as DYNAMIC.
Answer: B
Question 2.
You are a database developer for Company.com The company is upgrading from SQL Server 2000 to SQL Server 2005. The companys new coding standards require conformance with ANSI standards. Your manager asks you to convert the following query to use ANSI standard wording.
SELECT E.EmployeeID, E.Hiredate, J.Resume
FROM HumanResources.Employee AS E,
HumanResources.JobCandidate AS J
WHERE E.EmployeeID *= J.EmployeeID
The new query must always produce the same result set as the existing query. You need to write the query to fulfill these requirements.
Which Transact-SQL query should you use?
A. SELECT E.EmployeeID, E.Hiredate, J.Resume FROM HumanResources.Employee AS E
FULL OUTER JOIN HumanResources.JobCandidate AS J ON E.EmployeeID =
J.EmployeeID
B. SELECT E.EmployeeID, E.Hiredate, J.Resume FROM HumanResources.Employee AS E
INNER JOIN HumanResources.JobCandidate AS J ON E.EmployeeID = J.EmployeeID
C. SELECT E.EmployeeID, E.Hiredate, J.Resume FROM HumanResources.Employee AS E
LEFT OUTER JOIN HumanResources.JobCandidate AS J ON E.EmployeeID =
J.EmployeeID
D. SELECT E.EmployeeID, E.Hiredate, J.Resume FROM HumanResources.Employee AS E
RIGHT OUTER JOIN HumanResources.JobCandidate AS J ON E.EmployeeID =
J.EmployeeID
Answer: C
Question 3.
You are a database developer for Company.com The company recently upgraded to SQL Server 2005. You are creating a query to return information that shows the total number of purchase orders placed by a specified group of employees, grouped by the vendors who requested the orders. The result set should show each employees total number of purchase orders in a separate column of the result set. Each vendor should have its own row in the result set. You need to create the query to fulfill these requirements.
Which Transact-SQL command should you use?
A. UNION
B. PIVOT
C. CROSS APPLY
D. INTERSECT
Answer: B
Question 4.
You are a database developer for Company.com You are creating a parameterized stored procedure that will query the data and return rows that include any verb tense of the verbs supplied as input to the stored procedure.
The query should also return rows that contain both plural and singular forms of nouns. The data is included in several varchar(max) and varbinary(max)columns. You need to create the stored procedure to fulfill these requirements.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Create a nonclustered index on the appropriate column or columns.
B. Create a full-text index on the appropriate column or columns.
C. Use the LIKE operator.
D. Use the CONTAINS predicate.
Answer: A, D
Question 5.
You are a database developer for Company.com You are updating a stored procedure that declares and uses a dynamic cursor. The stored procedure originally needed to return the result set and allow for updates to the result set. The requirements have changed, and now the data will be read-only. Therefore, data changes should not be allowed to be made through the cursor. The only fetch command used in the stored procedure is FETCH NEXT. You need to rewrite the cursor definition to use resources as efficiently as possible and to provide the best performance, while fulfilling the new requirements.
What should you do?
A. Change the cursor DECLARE statement to use only the LOCAL, FORWARD_ONLY, and
OPTIMISTIC options.
B. Change the cursor DECLARE statement to use only the LOCAL and FAST_FORWARD
options.
C. Change the cursor DECLARE statement to use only the LOCAL and FORWARD_ONLY
options.
D. Add the SCROLL_LOCKS option to the current DECLARE statement with the LOCAL and
DYNAMIC options.
Answer: B
Question 6.
You are a database developer for Company.com You are creating a stored procedure that will use a Transact-SQL cursor to share the result set with other statements in the stored procedure.
This cursor must have a fixed membership where the order of the rows does not change. The data in the rows that are retrieved through the cursor should be updatable. These updates should be viewable after they are made. While implementing this cursor, you need to minimize memory usage regardless of the resulting effect on the speed of the cursor. You need to create the stored procedure to fulfill these requirements.
Which option should you use in the DECLARE CURSOR statement?
A. DYNAMIC
B. KEYSET
C. FAST_FORWARD
D. STATIC
Answer: B
|
Question 1.
The Cisco Security Monitoring, Analysis, and Response System (Cisco Security MARS) is an appliance-based, all-inclusive solution that provides unmatched insight and control of your existing security deployment.
Which three items are correct with regard to Cisco Security MARS rules? (Choose three.)
A. There are three types of rules.
B. Rules can be deleted.
C. Rules can be created using a query.
D. Rules trigger incidents.
Answer: A, C, D
Question 2.
Which three benefits are of deploying Cisco Security MARS appliances by use of the global and local controller architecture? (Choose three.)
A. A global controller can provide a summary of all local controllers information (network
topologies, incidents, queries, and reports results).
B. A global controller can provide a central point for creating rules and queries, which are applied
simultaneously to multiple local controllers.
C. A global controller can correlate events from multiple local controllers to perform global
sessionizations.
D. Users can seamlessly navigate to any local controller from the global controller GUI.
Answer: A, B, D
Question 3.
Which item is the best practice to follow while restoring archived data to a Cisco Security MARS appliance?
A. Use Secure FTP to protect the data transfer.
B. Use "mode 5" restore from the Cisco Security MARS CLI to provide enhanced security During
the data transfer.
C. Choose Admin > System Maintenance > Data Archiving on the Cisco Security MARS GUI to
perform the restore operations on line.
D. To avoid problems, restore only to an identical or higher-end Cisco Security MARS appliance.
Answer: D
Question 4.
A Cisco Security MARS appliance can't access certain devices through the default gateway. Troubleshooting has determined that this is a Cisco Security MARS configuration issue.
Which additional Cisco Security MARS configuration will be required to correct this issue?
A. Use the Cisco Security MARS GUI to configure multiple default gateways
B. Use the Cisco Security MARS GUI or CLI to configure multiple default gateways
C. Use the Cisco Security MARS GUI or CLI to enable a dynamic routing protocol
D. Use the Cisco Security MARS CLI to add a static route
Answer: D
Question 5.
Which two options are for handling false-positive events reported by the Cisco Security MARS appliance? (Choose two.)
A. mitigate at Layer 2
B. archive to NFS only
C. drop
D. log to the database only
Answer: C, D
Question 6.
What is the reporting IP address of the device while adding a device to the Cisco Security MARS appliance?
A. The source IP address that sends syslog information to the Cisco Security MARS appliance
B. The pre-NAT IP address of the device
C. The IP address that Cisco Security MARS uses to access the device via SNMP
D. The IP address that Cisco Security MARS uses to access the device via Telnet or SSH
Answer: A
Question 7.
Which statement best describes the case management feature of Cisco Security MARS?
A. It is used to conjunction with the Cisco Security MARS incident escalation feature for incident
reporting
B. It is used to capture, combine and preserve user-selected Cisco Security MARS data within a
specialized report
C. It is used to automatically collect and save information on incidents, sessions, queries and
reports dynamically without user interventions
D. It is used to very quickly evaluate the state of the network
Answer: B
Question 8.
Which two configuration tasks are needed on the Cisco Security MARS for it to receive syslog messages relayed from a syslog relay server? (Choose two.)
A. Define the syslog relay collector.
B. Add the syslog relay server application to Cisco Security MARS as Generic Syslog Relay Any.
C. Define the syslog relay source list.
D. Add the reporting devices monitored by the syslog relay server to Cisco Security MARS.
Answer: B, D
Question 9.
Here is a question that you need to answer. You can click on the Question button to the left to view the question and click on the MARS GUI Screen button to the left to capture the MARS GUI screen in order to answer the question. While viewing the GUI screen capture, you can view the complete screen by use of the left/right scroll bar on the bottom of the GUI screen. Choose the correct answer from among the options.
What actions will you take to configure the MARS appliance to send out an alert when the system rule fires according to the MARS GUI screen shown?
A. Click "Edit" to edit the "Operation" field of the rule, select the appropriate alert option(s), then
apply.
B. Click on "None" in the "Action" field, select the appropriate alerts, then apply.
C. Click "Edit" to edit the "Reported User" field of the rule, select the appropriate alert
option(s),then apply.
D. Click on "Active" in the "Status" field, select the appropriate alerts, then apply.
Answer: B
Question 10.
Which action enables the Cisco Security MARS appliance to ignore false-positive events by either dropping the events completely or by just logging them to the database?
A. Inactivating the rules
B. Creating system inspection rules using the drop operation
C. Deleting the false-positive events from the events management page
D. Creating drop rules
Answer: D
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.