Online Access Free 070-462 Practice Test

Which of the following is the default instance name in an SQL Server 2012 installation?

• A.MSSQLSERVER
• B.2012SQL
• C.MSSQL
• D.SQLSERVER12

You use Microsoft SQL Server 2012 to develop a database application. You need to implement a computed column that references a lookup table by using an INNER JOIN against another table.
What should you do?

• A.Create a BEFORE trigger that maintains the state of the computed column.
• B.Reference a user-defined function within the computed column.
• C.Add a default constraint to the computed column that implements hard-coded CASE statements.
• D.Add a default constraint to the computed column that implements hard-coded values.

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.Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.
• 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_FuzzyLookupTableMaintenanceInvoke stored procedure.
• E.Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.

You administer two Microsoft SQL Server 2012 databases named Contoso and ContosoWarehouse.
You plan to replicate tables from the Contoso database to the ContosoWarehouse database.
Indexes will be added to the tables in ContosoWarehouse to improve the performance of reports.
You need to ensure that the following requirements are met:
* Indexes are not modified when the subscriptions are reinitialized.
* Only the clustered index from Contoso will be replicated.
* Minimal transaction log activity during the reinitialization.
What should you do? Choose the correct option(s).

Correct Answer:

Explanation

You administer a Microsoft SQL Server database.
You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated privileges.
You need to ensure that the job step can run using a different user account.
What should you use?

• A.an alert
• B.an operator
• C.a proxy
• D.a schedule