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

You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured.
When SQL Server Agent jobs fail, the error messages returned by the job steps are truncated. The
following error message is an example of the truncated error message:
"Executed as user CONTOSO\ServiceAccount. ...0.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-
2011. All rights reserved. Started 63513 PM Error 2012-06-23 183536.87 Code 0XC001000E Source
UserImport Description Code 0x00000000 Source Log Import Activity Descript... The package execution
fa... The step failed."
You need to ensure that all the details of the job step failures are retained for SQL Server Agent jobs.
What should you do?

• A.Disable the Limit size of job history log feature.
• B.Configure output files.
• C.Configure event forwarding.
• D.Expand agent logging to include information from all events.

You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment. All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs access to the SQL Server. You need to create a server role named SpecialDBARole that can perform the following functions:
View all databases.
View the server state.
Assign GRANT, DENY, and REVOKE permissions on logins.
You need to add DOMAIN\JrDBAs to the server role. You also need to provide the least level of privileges necessary. Which SQL statement or statements should you use? Choose all that apply.

• A.GRANT VIEW DEFINITION TO [SpecialDBARole];
• B.GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];
• C.CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin;
• D.ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAIN\JrDBAs];
• E.CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin;
• F.CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;

You use Microsoft SQL Server 2012 to write code for a transaction that contains several statements. There is high contention between readers and writers on several tables used by your transaction. You need to minimize the use of the tempdb space. You also need to prevent reading queries from blocking writing queries. Which isolation level should you use?

• A.READ COMMITTED SNAPSHOT
• B.REPEATABLE READ
• C.SERIALIZABLE
• D.SNAPSHOT

You administer a Microsoft SQL Server 2012 database. The database contains a Product table created by using the following definition:

You need to ensure that the minimum amount of disk space is used to store the data in the Product table. What should you do?

• A.Convert all indexes to Column Store indexes.
• B.Implement page-level compression.
• C.Implement Unicode Compression.
• D.Implement row-level compression.

You use Microsoft SQL Server 2012 to develop a database application. You create a table by using the following definition:
CREATE TABLE Prices (
PriceId int IDENTITY(1,1) PRIMARY KEY,
ActualPrice NUMERIC(16,9),
PredictedPrice NUMERIC(16,9) )
You need to create a computed column based on a user-defined function named udf_price_index. You also need to ensure that the column supports an index. Which three Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)
Build List and Reorder:

정답: