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

You administer a Microsoft SQL Server 2012 database. You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do?

• A.In SQL Server Management Studio, expand the Storage leaf under the database. Select the transaction log file and set the maximum size of the file.
• B.Use the ALTER DATABASE...SET LOGFILE command along with the midsize parameter.
• C.In SQL Server Management Studio, right-click the database, select Properties, and then click Files. Open the Transaction log Autogrowth window and set the maximum size of the file.
• D.In SQL Server Management Studio, right-click the instance and select Database Settings. Set the maximum size of the file for the transaction log.

HOTSPOT You administer a Microsoft SQL Server 2012 database. The database contains a table that has the following definition: You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard. You need to ensure that the following requirements are met:

The first row of the file contains the first row of data.
Each record is of the same length.
The date follows the U.S. date format.
The file supports international characters.
What should you do? (To answer, simply select the option or options in the answer area that you would configure.)
Hot Area:

정답:

Explanation:
--Burgos - NO
Reference: http://msdn.microsoft.com/en-us/library/ms178804.aspx Reference: http://msdn.microsoft.com/en-us/library/ms187828.aspx

You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly. Your investigation shows the root cause is a query against a read-only table that has a clustered index. The query returns the following six columns: * One column in its WHERE clause contained in a non-clustered index * Four additional columns * One COUNT (*) column based on a grouping of the four additional columns.
You need to optimize the statement. What should you do?

• A.Add an INCLUDE clause to the index.
• B.Add a columnstore index to cover the query.
• C.Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
• D.Cover the unique clustered index with a columnstore index.
• E.Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.
• F.Add a HASH hint to the query.
• G.Include a SET FORCEPLAN ON statement before you run the query.
• H.Add a FORCESEEK hint to the query.
• I.Enable the optimize for ad hoc workloads option.
• J.Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
• K.Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
• L.Include a SET STATISTICS PROFILE ON statement before you run the query.
• M.Add a LOOP hint to the query.
• N.Add a FORCESCAN hint to the Attach query.

You use Microsoft SQL Server 2012 to develop a database application. You create a stored procedure named dbo.ModifyData that can modify rows. You need to ensure that when the transaction fails, dbo. ModifyData meets the following requirements:
Does not return an error
Closes all opened transactions
Which Transact-SQL statement should you use?

• A.BEGIN TRANSACTION
  BEGIN TRY
  EXEC dbo.ModifyData
  COMMIT TRANSACTION
  END TRY
  BEGIN CATCH
  IF @@ERROR != 0
  ROLLBACK TRANSACTION;
  THROW;
  END CATCH
• B.BEGIN TRANSACTION
  BEGIN TRY
  EXEC dbo.ModifyData
  COMMIT TRANSACTION
  END TRY
  BEGIN CATCH
  IF @@ TRANCOUNT = 0
  ROLLBACK TRANSACTION;
  END CATCH
• C.BEGIN TRANSACTION
  BEGIN TRY
  EXEC dbo.ModifyData
  COMMIT TRANSACTION
  END TRY
  BEGIN CATCH
  IF @@TRANCOUNT = 0
  ROLLBACK TRANSACTION;
  THROW;
  END CATCH
• D.BEGIN TRANSACTION
  BEGIN TRY
  EXEC dbo.ModifyData
  COMMIT TRANSACTION
  END TRY
  BEGIN CATCH
  IF @@ERROR != 0
  ROLLBACK TRANSACTION;
  END CATCH

You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports a highly active OLTP application. Users report abnormally long wait times when they submit data into the application. You need to identify which queries are taking longer than 1 second to run over an extended period of time. What should you do?

• A.Use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of more than 1,000.
• B.Run the DBCC TRACEON 1222 command from a query window and review the SQL Server event log.
• C.Run the sp_who command from a query window.
• D.Use the Job Activity monitor to review all processes that are actively running. Review the Job History to find out the duration of each step.
• E.Use sp_configure to set a value for blocked process threshold. Create an extended event session.