Capture,analyze,preprocess,replay
Capture,preprocess,analyze,replay
Capture,preprocess,replay,analyze
Analyze,capture,preprocess,replay
None of the above
第1题:
A Windows Azure application connects to a SQL Azure database. The database size has increased significantly. Some queries in the application no longer complete. You need to recommend an approach for identifying queries that do not complete. What should you recommend?()
第2题:
Which of the following represents the correct sequence of events for Database Replay?()
第3题:
Which two prerequisites are needed for performing workload capture and replay?()
第4题:
Which two client requests are captured during database replay Capture?()
第5题:
Which two client requests are captured during database replay Capture?() (Choose two)
第6题:
Which of these recommendations should be followed before capturing a workload?()
第7题:
Flashback queries
Shared server requests
Login and logoff activities of sessions
Direct path load of data from external files by using utilities such as SQL *loader
Data definition language (DDL) and data manipulation language (DML) operations
第8题:
Enter the password.
Modify the delete time to 3 hours.
Set the interface to local, remote or both.
Increase the snap length of the Packet Capture configuration.
Set the Packet Capture size to greater than the actual data flow
第9题:
Capture,analyze,preprocess,replay
Capture,preprocess,analyze,replay
Capture,preprocess,replay,analyze
Analyze,capture,preprocess,replay
None of the above
第10题:
SQL text
Shared server requests (Oracle MTS)
Bind variable values
Information about transactions
Remote DESCRIBE and COMMIT operations
第11题:
Daily
Incremental
Normal
Differential
第12题:
1,4,5,3 (2 is not required.)
1,4,3,5 (2 is not required.)
1,2,4,5 (3 is not required.)
2,1,5,3,4
1,2,4,5,3
第13题:
Which of the following backup methods should be used nightly to ensure backups capture all necessary data in the LEAST amount of time?()
第14题:
In a Database Replay workload capture, what client request information is gathered?()
第15题:
Performance divergence indicated in the Workload Replay report is most likely due to what?()
第16题:
You want to capture WebLogic internal events correlated with JVM events for viewing offline. What three actions must you take to enable this within WebLogic?()
第17题:
Which two statements about workload capture and replay operations are true?()
第18题:
You are the network administrator for your company. The network consists of a single Active Directory domain. The domain contains Windows Server 2003 computers and Windows XP Professional computers. You configure a server named Server1 to be a file server. The written company security policy states that you must analyze network traffic that is sent to and from all file servers.You need to capture file-transfer network traffic that is being sent to and from Server1. You install Network Monitor Tools from a Windows Server 2003 product CD-ROM on a server named Server2, which is on the same network segment as Server1.You run Network Monitor on Server2. However, Network Monitor captures only network traffic that is sent to and from Server2. You need to capture all network traffic that is sent to and from Server1. What should you do?()
第19题:
The clients must be created manually on the test machines to perform more realistic testing.
Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
第20题:
Close all sessions performing queries using database links
running the database in shared server mode
The database on which the workload is replayed has to be a restore of the original database to a specific SCN
setting up the directory to capture the workload
第21题:
Use the SQL Server Profiler to capture all SQL activities.
Use a Dynamic Management View to analyze performance.
Use the Database Engine Tuning Advisor to analyze the workload.
Use Microsoft SQL Server Management Studio to analyze the SQL logs.
第22题:
Install the Network Monitor driver on Server1. Run Network Monitor on Server2 to capture network traffic.
Open Network Monitor on Server2 and create a capture filter to enable the capture of all protocols. Run Network Monitor to capture network traffic.
Install Network Monitor Tools on Server1. Run Network Monitor to capture network traffic.
Open Network Monitor on Server2 and increase the capture buffer from 1 MB to 20 MB in size. Run Network Monitor to capture network traffic.
第23题:
DML and SQL statement results that do not match between the capture and replay systems
When errors that occur in the capture system dont occur in the replay system
Top SQL statements
Infrastructure or system-configuration differences
Time-of-day differences between capture and replay systems
第24题:
Flashback queries
Shared server requests
Login and logoff activities of sessions
Direct path load of data from external files by using utilities such as SQL *loader
Data definition language (DDL) and data manipulation language (DML) operations