← Back to exam page

70-461 – Querying Microsoft SQL Server 2012

Loading demo links...

Showing 10–12 of 15 questions

Question 10

You have several SQL Server queries.

You plan to optimize the queries to improve performance.

You run the queries in SQL Server Management Studio.

You need to compare query runs to expose the indexing issues of the queries.

Which three actions should you perform from SQL Server Management Studio? Each correct answer presents part of the solution.

Select all that apply, then click Submit answer.

  • ○

    Enable the Debug option.
  • ○

    Add the STATISTICS TIME execution setting to the query.
  • ○

    Add the STATISTICS IO execution setting to the query.
  • ○

    Add the STATISTICS PROFILE execution setting to the query.
  • ○

    Enable the Include Actual Execution Plan option.
Question 11

You use a Microsoft Azure SQL Database instance. The instance contains a table named Customers that has columns named Id, Name, and IsPriority.

You need to create a view named VwPriorityCustomers that:

returns rows from Customer that have a value of True in the IsPriority column, and does not allow columns to be altered or dropped in the underlying table.

Which Transact-SQL statement should you run?

Select an option, then click Submit answer.

  • ○

    CREATE VIEW VwPriorityCustomers
    AS
    SELECT Id, Name FROM dbo.Customers WHERE IsPriority=1 WITH CHECK OPTION
  • ○

    CREATE VIEW VwPriorityCustomers
    WITH VIEW_METADATA
    AS
    SELECT Id, Name FROM dbo.Customers WHERE IsPriority=1
  • ○

    CREATE VIEW VwPriorityCustomers
    WITH ENCRYPTION
    AS
    SELECT Id, Name FROM dbo.Customers WHERE IsPriority=1
  • ○

    CREATE VIEW VwPriorityCustomers
    WITH SCHEMABINDING
    AS SELECT Id, Name FROM dbo.Customers WHERE IsPriority=1
Question 12

You are working with a table that has an XML column that contains information about books. Each book may have an associated price.

You need to write a query that returns each author on a separate row in XML format.

Which XML method should you use?

Select an option, then click Submit answer.

  • ○

    Value()
  • ○

    Nodes()
  • ○

    Query()
  • ○

    Exist()