← Back to exam page

70-462 – Administering Microsoft SQL Server 2012/2014 Databases

Loading demo links...

Showing 10–12 of 15 questions

Question 10 (Volume B)

You are the senior database administrator for a Microsoft SQL Server environment that uses Microsoft Azure SQL Database.

You need to grant a junior database administrator only the permissions required to create new logins.

Which Microsoft Azure SQL Database role should you assign the junior database administrator?

Select an option, then click Submit answer.

  • ○

    setupadmin
  • ○

    loginmanager
  • ○

    securityadmin
  • ○

    serveradmin
Question 11 (Volume B)

You need to install SQL Server on a server. The server must meet the following requirements:

Include SQL Server Integration Services (SSIS) Be able to run 32-bit SSIS legacy packages

You add the Integration Services shared feature to the installation.

Which other shared feature should you add to the installation?

Select an option, then click Submit answer.

  • ○

    Client Tools Connectivity
  • ○

    Master Data Services (MDS)
  • ○

    Management Tools - Complete
  • ○

    SQL Server Data Tools
Question 12 (Volume B)

You develop a database for a travel application.

You need to design tables and other database objects.

You create a stored procedure.

You need to supply the stored procedure with multiple event names and their dates as parameters.

What should you do?

Select an option, then click Submit answer.

  • ○

    Use the CAST function.
  • ○

    Use the DATE data type.
  • ○

    Use the FORMAT function.
  • ○

    Use an appropriate collation.
  • ○

    Use a user-defined table type.
  • ○

    Use the VARBINARY data type.
  • ○

    Use the DATETIME data type.
  • ○

    Use the DATETIME2 data type.
  • ○

    Use the DATETIMEOFFSET data type.
  • ○

    Use the TODATETIMEOFFSET function.