070-462 試験問題を無料オンラインアクセス

You plan to install Microsoft SQL Server 2012 for a web hosting company.
The company plans to host multiple web sites, each supported by a SQL Server database.
You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total cost of ownership.
Which edition should you choose?

• A.Web Edition
• B.Express Edition with Advanced Services
• C.Express Edition with Tools
• D.Standard Edition

You administer a Microsoft SQL Server 2012 database.
The database uses SQL Server Agent jobs to perform regular FULL and LOG backups. The database uses the FULL recovery model.
You plan to perform a bulk import of a very large text file.
You need to ensure that the following requirements are met during the bulk operation:
* The database transaction log is minimally affected.
* The database is online and all user transactions are recoverable.
* All transactions are fully recoverable prior to the import.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

正解：

Explanation

Which of the following conditions must exist prior to restoring a system database in SQL Server 2012?

• A.The SQL Server 2012 instance must be removed.
• B.The hard drive must be reformatted.
• C.The SQL Server 2012 instance must be started in single-user mode.
• D.You must detach the user databases from the SQL 2012 instance.

You administer a Microsoft SQL Server database.
You create an availability group named haContosoDbs. Your primary replica is available at Server01\Contoso01.
You need to configure the availability group to prevent data loss. In the event of a database failure, the designed secondary database must come online automatically.
Which Transact-SQL statement should you use?

• A.ALTER AVAILABILITY GROUP haContosoDbsMODITY REPLICA ON
  'Server01'\Contoso01'WITH (AVAILABILITY _MODE=SYNCHRONOUS_COMMIT,
  FAILOVER_MODE=AUTOMATIC)
• B.ALTER AVAILABILITY GROUP haContosoDbsMODIFY REPLICA ON
  'Server01'\Contoso01'WITH (AVAILABILITY _MODE=ASYNCHRONOUS_COMMIT,
  FAILOVER_MODE=MANUAL)
• C.ALTER AVAILABILITY GROUP haContosoDbsMODITY REPLICA ON
  'Server01'\Contoso01'WITH (AVAILABILITY _MODE=ASYNCHRONOUS_COMMIT,
  FAILOVER_MODE=AUTOMATIC)
• D.ALTER AVAILABILITY GROUP haContosoDbsMODIFY REPLICA ON
  'Server01'\Contoso01'WITH (AVAILABILITY
  _MODE=SYNCHRONOUS_COMMIT,FAILOVER_MODE=MANUAL)

You administer a Microsoft SQL Server database that is used by an application.
Users of the application report performance issues.
You need to choose the appropriate tool for performance-tuning of SQL Server databases.
Which tool or tools should you use? (To answer, drag the appropriate tool or tools to their corresponding task or tasks in the answer area. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)

正解：

Explanation

References:
http://msdn.microsoft.com/en-us/library/bb630282.aspx
http://msdn.microsoft.com/en-us/library/ms191246.aspx
http://msdn.microsoft.com/en-us/library/ms181091.aspx