Online Access Free 70-462 Exam Questions

You are a database administrator for a Microsoft SQL Server 2012 database named AdventureWorks2012.
You create an Availability Group defined by the following schema. (Line numbers are included for reference only.)

You need to implement an AlwaysOnAvailablity Group that will meet the following conditions:
* Production transactions should be minimally affected.
* The secondary server should allow reporting queries to be performed.
* If the primary server goes offline, the secondary server should not automatically take over.
Which Transact-SQL statement should you insert at line 06?

• A.AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,FAILOVER_MODE =
  MANUALSECONDARY_ROLE (ALLOW_CONNECTIONS =
  READ_ONLY,READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433')
• B.AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,FAILOVER_MODE =
  MANUALSECONDARY_ROLE (ALLOW_CONNECTIONS =
  READ_ONLY,READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433')
• C.AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,FAILOVER_MODE =
  MANUALSECONDARY_ROLE (ALLOW_CONNECTIONS =
  READ_ONLY,READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433')PRIMARY_ROLE (ALLOW_CONNECTIONS = READ_WRITE,READ_ONLY_ROUTING_LIST = NONE)
• D.AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,FAILOVER_MODE =
  MANUALSECONDARY_ROLE (ALLOW_CONNECTIONS =
  YES,READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433')

You administer a Microsoft SQL Server database.
You create in availability group named haContosoDbs. The primary replica is available at Server01\Contoso01.
You need to configure the availability group to have the highest availability. You also need to ensure that no data is lost Which Transact-SQL statement should you run?
A)

B)

C)

D)

• A.Option B
• B.Option D
• C.Option A
• D.Option C

You are the senior database administrator for a Microsoft SQL Server environment that uses Windows Azure SQL Database.
You need to grant a junior database administrator only the permissions required to create new logins.
Which Windows Azure SQL Database role should you assign the junior database administrator?

• A.securityadmin
• B.loginmanager
• C.serveradmin
• D.setupadmin

You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation.
The reference data to be used in the transformation does not change.
You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance.
What should you do?

• A.Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.
• B.Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.
• C.Select the DropExistingMatchIndex option in the Fuzzy Lookup Transformation Editor.
• D.Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.
• E.Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.

You have a SQL Server database named DB1.
You plan to load 10 million rows to DB1 by running bcp.exe.
You need to modify DB1 to minimize the amount of space required to store the transaction logs during the load operation. The solution must ensure that you can perform a point-in-time restore.
What data base setting should you modify?

• A.Compatibility level to 120
• B.Containment type to Partial
• C.Recovery model to Bulk logged
• D.Recovery model to Simple