You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）

相似题目

• You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）

  A .  DBMS_WORKLOAD_REPOSITORY B .  DBMS_RESOURCE_MANAGER C .  DBMS_SQLTUNE D .  DBMS_ADVISOR

  查看最佳答案

• You are planning the migration of a Microsoft SQL Server 2008 database to SQL Azure.   You need to recommend an approach for ensuring that database connectivity does not degrade.   Which two actions should you recommend？（）

  A .  Implement transactions for database queries. B .  Close database connections in the application. C .  Use Microsoft ADO.NET in the data access layer. D .  Implement a retry policy in the data access layer.

  查看最佳答案

• You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）

  A .  assign users to consumer groups B .  set the resource plan for the instance C .  configure a simple resource plan and specify plan directives D .  configure a complex resource plan and specify plan directive

  查看最佳答案

• You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

  A .  Top SQL B .  snapshots C .  SQL Tuning sets D .  index access path E .  optimizer statistics F .  materialized view log

  查看最佳答案

• You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）

  A . More than one database is to be registered with the listener. B . The users will connect the database by using the host naming method. C . The Oracle Enterprise Manager is to be used to monitor an Oracle9i database. D . The database that is to be registered with the listener is configured in shared server mode. E . The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

  查看最佳答案

• You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）

  A . More than one database is to be registered with the listener. B . The users will connect the database by using the host naming method. C . The Oracle Enterprise Manager is to be used to monitor an Oracle9i database. D . The database that is to be registered with the listener is configured in shared server mode. E . The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

  查看最佳答案

• You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?（）

  A .  Named Pipes  B .  TCP/IP  C .  Shared Memory  D .  Virtual Interface Adapter (VIA)  E .  Multiprotocol&e

  查看最佳答案

• You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）

  A . The database must have multiplexed redo log files B . The database must be in the MOUNT state to execute the command C . The database must be in the NOMOUNT state to execute the command D . The database must be opened in RESTRICTED mode before this operation E . The database must be opened with the RESETLOGS option after the flashback operatio

  查看最佳答案

• Your company is planning to deploy Windows 7.   You have an image that is used to deploy Windows 7 on client computers.   You need to add a volume image to the existing Windows image.   What should you do？（）

  A . Service the image online. B . Use DiskPart to attach a new volume. C . Use ImageX to append the volume image. D . Use the Deployment Image Servicing and Management （DISM） tool to mount the image.

  查看最佳答案

• You plan to use Windows PowerShell scripts to configure system settings when you deploy Windows 7.   You need to ensure that Windows PowerShell scripts will run on the client computers during initial setup.   What should you do？（）

  A . Set the script execution policy to RemoteSigned. B . Set the script execution policy to AllSigned. C . Set the script execution policy to Restricted. D . Use Group Policy preferences.

  查看最佳答案

• An administrator named Admin1 plans to implement the planned App-V deployment. You need to recommend which protocol to use for the App-V deployment. Which protocol should you recommend？（）

  A . SMB B . HTTPS C . CIFS D . RTSPS

  查看最佳答案

• You are designing a Hyper-V solution. You plan to virtualize an application server. The application server requires failover clustering that uses shared storage. You need to choose the correct storage solution. What should you choose？（）

  A . two child partitions with VHDs stored on an iSCSI SAN B . two child partitions with volumes mounted from an iSCSI SAN C . two host servers with iSCSI-attached storage enabled for Cluster Shared Volumes （CSVs） D . two host servers with Fibre ChannelCattached storage enabled for Cluster Shared Volumes （CSVs）

  查看最佳答案

• You are planning the configuration of SQL1.You need to use the most appropriate Windows account for the SQL Server service. Which account should you use？（）

  A . a domain user account B . a local user account C . the NETWORK SERVICE account D . the LOCAL SYSTEM account

  查看最佳答案

• You plan to deploy Windows 7 images. You need ensure that you can deploy images by using the WindowsPreinstallation Environment (Windows PE).  What should you do add to the Windows PE image?（）

  A . Imagex.exe B . Loadstate.exe C . Mighost.exe D . Usmtutils.exe

  查看最佳答案

• When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics.  Which two statements describe the implications of this？（）

  A .  It produces less accurate results of the comparison analysis. B .  It automatically calls the SQL Tuning Advisor for recommendations. C .  It shortens the time of execution and reduces the impact on system resources. D .  Only the changes in the execution plan，and not performance regression，are detected.

  查看最佳答案

• You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）

  A . Top SQL B . snapshots C . SQL Tuning sets D . index access path E . optimizer statistics F . materialized view log

  查看最佳答案

• You plan to deploy an application by using Microsoft Application Virtualization （App-V） in standalone mode. You need to recommend which App-V components are required for the planned deployment. Which components should you recommend？（）

  A . the App-V Client B . the App-V Management Server C . the App-V Sequencer D . the App-V Management Console E . the App-V Streaming Server

  查看最佳答案

• You want to create a template to be used as a standard for all company reports, which are many different styles. How many different templates must you have if you plan to use multiple report styles?（）

  A . Two  B . One  C . One per report style D . One per report style + one more

  查看最佳答案

• You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）

  A . the SQL text SQL B . the execution plan C . the execution context D . the execution frequency E . the system change number (SCN)

  查看最佳答案

• The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?（）

  A . The optimizer adds the new plan to the plan history. B . The optimizer selects the new plan for the execution of the SQL statement. C . The optimizer adds the new plan to the SQL plan baseline as an accepted plan. D . The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state. E . The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

  查看最佳答案

• You are designing a Hyper-V solution. You plan to virtualize an application server. The application server requires failover clustering that uses shared storage. You need to choose the correct storage solution. What should you choose？（）

  A . Two child partitions with volumes mounted from an iSCSI SAN B . Two host servers with Fibre Channel-attached storage enabled for Cluster Shared Volumes （CSVs） C . Two host servers with iSCSI-attached storage enabled for Cluster Shared Volumes （CSVs） D . Two child partitions with VHDs stored on an iSCSI SAN

  查看最佳答案

• An administrator named Admin1 plans to deploy the planned VMs. You need to identify which servers can be converted to VMs by using physical-to-virtual machine （P2V） conversion. Which server or servers should you identify？（）

  A . Humongous2 B . Humongous4 C . Humongous3 D . Humongous1

  查看最佳答案

• You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

  A .  The database must have multiplexed redo log files B .  The database must be in the MOUNT state to execute the command C .  The database must be in the NOMOUNT state to execute the command D .  The database must be opened in RESTRICTED mode before this operation E .  The database must be opened with the RESETLOGS option after the flashback operatio

  查看最佳答案

• You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server.  Which two protocols can you use to achieve this goal？（）

  A . Named Pipes B . TCP/IP C . Shared Memory D . Virtual Interface Adapter （VIA） E . Multiprotocol

  查看最佳答案