070-762 무료 덤프문제 온라인 액세스

You are developing an ETL process to cleanse and consolidate incoming data. The ETL process will use a reference table to identify which data must be cleansed in the target table. The server that hosts the tables restarts daily.
You need to minimize the amount of time it takes to execute the query and the amount of time it takes to populate the reference table.
What should you do?

• A.Convert the reference table to a memory-optimized table. Set the durability option to SCHEMA_ONLY.
• B.Convert the reference table to a memory-optimized table. Set the durability option to SCHEMA_AND_DATA>
• C.Create a native compiled stored procedure to implement the ETL process for both tables.
• D.Convert the target table to a memory-optimized table. Create a natively compiled stored procedure to cleanse and consolidate the data.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some questions sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a database that is 130 GB and contains 500 million rows of data.
Granular transactions and mass batch data imports change the database frequently throughout the day.
Microsoft SQL Server Reporting Services (SSRS) uses the database to generate various reports by using several filters.
You discover that some reports time out before they complete.
You need to reduce the likelihood that the reports will time out.
Solution: You partition the largest tables.
Does this meet the goal?

• A.Yes
• B.No

You have multiple stored procedures inside a transaction.
You need to ensure that all the data modified by the transaction is rolled back if a stored procedure causes a deadlock or times out.
What should you do?

• A.Execute the DBCC UPDATEUSAGE statement.
• B.Set SET XACT ABORT to ON.
• C.Set SET ALLOW SNAPSHOT ISOLATION to ON,
• D.Use the NOLOCK option.
• E.Use the max worker threads Option.
• F.Use a table-valued parameter.
• G.Use the output parameters.
• H.Execute the alter table T1 set (lock escalation = auto); statement.

You have a reporting application that uses a table named Table1. You deploy a new batch update process to perform updates to Table1.
The environment is configured with the following properties:
* The database is configured with the default isolation setting.
* The application and process use the default transaction handling.
You observe the application cannot access any rows that are in use by the process.
You have the following requirements:
* Ensure the application is not blocked by the process.
* Ensure the application has a consistent view of the data
* Ensure the application does not read dirty data.
You need to resolve the issue and meet the requirements with the least amount of administrative effort.
What should you do?

• A.Enable the database for the READ_COMITTED_SNAPSHOT isolation level.
• B.Enable the database for the ALLOW_SNAPSHOT_ISOLATION isolation level. Modify the application for the SERIALIZABLE isolation level.
• C.Enable the database for the ALLOW_SNAPSHOT_ISOLATION isolation level. Modify the application and the update process for the SNAPSHOT isolation level.
• D.Enable the application for the WITH (NOLOCK) hint.

You have multiple queries that take a long time to complete.
You need to identify the cause by using detailed information about the Transact-SQL statements in the queries. The Transact-SQL statements must not run as part of the analysis.
Which Transact-SQL statement should you run?

• A.SET SHOWPLAN_TEXT OFF
• B.SET SHOWPLAN_ALL ON
• C.SET STATISTICS PROFILE ON
• D.SET STATISTICS PROFILE OFF