Free Download Microsoft 70-464 PDF Full Version Now (21-30)

QUESTION 21
You execute the following code.

image
You need to reduce the amount of time it takes to execute the query. What should you do?

A.    change SUBSTRING (JobTitle, l, l) = ‘c’ to LEFT(JobTitle,1) = ‘c’.
B.    Change SUBSTRING(JobTitle, l, l) = ‘c’ to JobTitle LIKE ‘c%\
C.    Partition the table and use the JobTitle column for the partition scheme.
D.    Replace IX_Employees with a clustered index.

Answer: C

QUESTION 22
You use a contained database named ContosoDb within a domain.
You need to create a user who can log on to the ContosoDb database.
You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.
Which type of user should you create?

A.    User mapped to a certificate
B.    SQL user without login
C.    Domain user
D.    SQL user with login

Answer: C

QUESTION 23
You administer a Microsoft SQL Server 2012 database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sales schema.
You need to manage users who are prevented from deleting records in the Sales schema.
You need to achieve this goal by using the minimum amount of administrative effort.
What should you do?

A.    Create a custom database role that includes the users. Deny Delete permissions on the Sales schema
for the custom database role.
B.    Include the Sales schema as an owned schema for the db_denydatawriter role. Add the users to the
db_denydatawriter role.
C.    Deny Delete permissions on each table in the Sales schema for each user.
D.    Create a custom database role that includes the users. Deny Delete permissions on each table in the
Sales schema for the custom database role.

Answer: A

QUESTION 24
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.    CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin;
B.    ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAIN\JrDBAs];
C.    CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;
D.    GRANT VIEW DEFINITION TO [SpecialDBARole];
E.    CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin;
F.    GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];

Answer: BCF

QUESTION 25
You administer a Microsoft SQL Server 2012 database. You provide temporary securityadmin access to User1 to the database server. You need to know if User1 adds logins to securityadmin. Which server-level audit action group should you use?

A.    SERVER_STATE_CHANGE_GROUP
B.    SERVER_PRINCIPAL_IMPERSONATION_GROUP
C.    SUCCESSFUL_LOGIN_GROUP
D.    SERVER_ROLE_MEMBER_CHANGE_GROUP

Answer: D

QUESTION 26
You administer a Microsoft SQL Server 2012 instance.
You need to stop a blocking process that has an SPID of 64 without stopping other processes. What should you do?

A.    Execute the following Transact-SQL statement:
EXECUTE sp_KillSPID 64
B.    Restart the SQL Server service.
C.    Execute the following Transact-SQL statement:
KILL 64
D.    Execute the following Transact-SQL statement:
ALTER SESSION KILL ’64’

Answer: C

QUESTION 27
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.    Execute sp_configure ‘max log size’, 2G.
B.    use the ALTER DATABASE…SET LOGFILE command along with the maxsize parameter.
C.    In SQL Server Management Studio, right-click the instance and select Database Settings.
Set the maximum size of the file for the transaction log.
D.    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.

Answer: D

QUESTION 28
You administer a Microsoft SQL Server 2012 server. You plan to deploy new features to an application. You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance. What should you do?

A.    Query the sys.dm_db_index_usage_stats DMV.
B.    Query the sys.dm_db_missing_index_details DMV.
C.    Use the Database Engine Tuning Advisor.
D.    Query the sys.dm_db_missing_index_columns DMV.

Answer: C

QUESTION 29
You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01. What should you create?

A.    a Database Audit Specification
B.    a Policy
C.    an Alert
D.    a SQL Profiler Trace
E.    a Resource Pool
F.    an Extended Event session
G.    a Server Audit Specification

Answer: G

QUESTION 30
You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to be notified immediately when fatal errors occur on Server01. What should you create?

A.    an Alert
B.    a Server Audit Specification
C.    an Extended Event session
D.    a Resource Pool
E.    a Policy
F.    a SQL Profiler Trace
G.    a Database Audit Specification

Answer: A

If you want to pass Microsoft 70-464 successfully, donot missing to read latest lead2pass Microsoft 70-464 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/70-464.html

Lead2pass Testking Pass4sure Actualtests Others
$99.99 $124.99 $125.99 $189 $29.99-$49.99
Up-to-Dated
Real Questions
Error Correction
Printable PDF
Premium VCE
VCE Simulator
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back