PrepAway - Latest Free Exam Questions & Answers

Which table hint should you use?

You develop a Microsoft SQL Server 2012 database that contains a heap named OrdersHistorical.
You write the following Transact-SQL query:
INSERT INTO OrdersHistorical
SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement.
Which table hint should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
HOLDLOCK

B.
ROWLOCK

C.
XLOCK

D.
UPDLOCK

E.
TABLOCK

Explanation:
When importing data into a heap by using the INSERT INTO SELECT <columns> FROM statement, you can
enable optimized logging and locking for the statement by specifying the TABLOCK hint for the target table.
https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table

One Comment on “Which table hint should you use?”

  1. Robert says:

    passed 70-765 exam! come to share some 70-765 questions i got in my real test:
    QUESTION 93
    You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the Windows NT Service virtual accounts for all SQL Services.
    You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as a pull subscriber.
    The distribution agent on ProdSrv2 regularly fails, displaying the following error message:
    “Cannot access the file. Operating system error code 5 (Access is denied.).”
    You need to configure the distribution agent by granting only the minimum required access to all accounts.
    What should you do?

    A. Configure the Subscriber to use the Local System account.
    B. Configure the SQL Server Agent service to run under the Local System account. Configure the Subscriber to use the SQL Server Agent service account.
    C. Configure the SQL Server Agent service to run under a Windows domain account. Configure the Subscriber to use the SQL Server Agent service account. Grant FULL CONTROL access for the domain account to the ReplData share on ProdSrv1.
    D. Configure the Subscriber to use a Windows domain account. Grant READ access for the domain account to the ReplData share on ProdSrv1.

    Answer: D

    QUESTION 94
    You are a database administrator for a Microsoft SQL Server 2012 environment.
    You want to deploy a new application that will scale out the workload to at least five different SQL Server instances.
    You need to ensure that for each copy of the database, users are able to read and write data that will then be synchronized between all of the database instances.
    Which feature should you use?

    A. Database Mirroring
    B. Peer-to-Peer Replication
    C. Log Shipping
    D. Availability Groups

    Answer: B

    QUESTION 95
    You administer a Microsoft SQL Server 2012 instance that has multiple databases.
    You have a two-node SQL Server failover cluster. The cluster uses a storage area network (SAN).
    You discover I/O issues. The SAN is at capacity and additional disks cannot be added.
    You need to reduce the I/O workload on the SAN at a minimal cost.
    What should you do?

    A. Move user databases to a local disk.
    B. Expand the tempdb data and log files
    C. Modify application code to use table variables
    D. Move the tempdb files to a local disk

    Answer: D

    QUESTION 96
    You administer a Microsoft SQL Server 2012 database that includes a table named Application.Events. Application.Events contains millions of records about user activity in an application.
    Records in Application.Events that are more than 90 days old are purged nightly.
    When records are purged, table locks are causing contention with inserts.
    You need to be able to modify Application.Events without requiring any changes to the applications that utilize Application.Events.
    Which type of solution should you use?

    A. Partitioned tables
    B. Online index rebuild
    C. Change data capture
    D. Change tracking

    Answer: A

    QUESTION 97
    You administer a Microsoft SQL Server 2012 environment. One of the SQL Server 2012 instances contains a database named Sales.
    You plan to migrate Sales to Windows Azure SQL Database.
    To do so, you need to implement a contained database.
    What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

    A. Set database containment to AZURE.
    B. Enable server property contained database authentication.
    C. Disable server property cross db ownership chaining.
    D. Set database containment to PARTIAL.
    E. Disable server property contained database authentication.
    F. database containment to FULL.

    Answer: BD

    I have already uploaded 70-765 questions pdf here: https://drive.google.com/drive/folders/0B75b5xYLjSSNTnR6dFR2U3A5cFk?usp=sharing

    Wish they can help more people to pass the exam.




    0



    0

Leave a Reply