This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Fri Nov 22 11:32:39 2024 / +0000 GMT ___________________________________________________ Title: Improve Your Microsoft 70-464 Exam Score Reporting By Using Braindump2go's New Released 70-464 Tests Dumps (141-155) --------------------------------------------------- 2015 Latest 70-464 Real exam questions to master and practice upon! Braindump2go Offers the New Updated Microsoft 70-464 191 Exam Questions in PDF & VCE files that can also be downloaded on every mobile device for preparation! Vendor: Microsoft Exam Code: 70-464 Exam Name: Developing Microsoft SQL Server 2014 Databases Exam  QUESTION 141You 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 142You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment. All DBAs are members of the DOMAINJrDBAs Active Directory group. You grant DOMAINJrDBAs 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 DOMAINJrDBAs 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 [DOMAINJrDBAs];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 143You 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_GROUPB.    SERVER_PRINCIPAL_IMPERSONATION_GROUPC.    SUCCESSFUL_LOGIN_GROUPD.    SERVER_ROLE_MEMBER_CHANGE_GROUP Answer: D QUESTION 144You 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 64B.    Restart the SQL Server service.C.    Execute the following Transact-SQL statement:KILL 64D.    Execute the following Transact-SQL statement:ALTER SESSION KILL '64' Answer: C QUESTION 145You 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 146You 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 147You 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 SpecificationB.    a PolicyC.    an AlertD.    a SQL Profiler TraceE.    a Resource PoolF.    an Extended Event sessionG.    a Server Audit Specification Answer: G QUESTION 148You 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 AlertB.    a Server Audit SpecificationC.    an Extended Event sessionD.    a Resource PoolE.    a PolicyF.    a SQL Profiler TraceG.    a Database Audit Specification Answer: A QUESTION 149You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server. What should you create? A.    an Extended Event sessionB.    a PolicyC.    a Database Audit SpecificationD.    an AlertE.    a Server Audit SpecificationF.    a SQL Profiler TraceG.    a Resource Pool Answer: F QUESTION 150You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently, HA/Server01 is the primary replica. You have multiple queries that read data and produce reports from the database. You need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica. What should you do? A.    Set the Availability Mode property of HA/Server02 to Asynchronous commit.B.    Set the Readable Secondary property of HA/Server02 to Read-intent only.C.    Set the Connections in Primary Role property of HA/Server01 to Allow read/write connections.D.    Set the Availability Mode property of HA/Server01 to Asynchronous commit. Answer: B QUESTION 151You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted domain. You plan to configure database mirroring. You need to be able to create database mirroring endpoints on both servers. What should you do? A.    Configure the SQL Server service account to use Network Service.B.    Use a server certificate.C.    Use a database certificate.D.    Configure the SQL Server service account to use Local System. Answer: B QUESTION 152You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply. A.    Disable FILESTREAM on the Database.B.    Enable FILESTREAM on the Server Instance.C.    Configure the Database for Partial Containment.D.    Create a non-empty FILESTREAM file group.E.    Enable Contained Databases on the Server Instance.F.    Set the FILESTREAM directory name on the Database. Answer: BDF QUESTION 153You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do? A.    Configure the application as data-tiered.B.    Open port 1433 on the Windows firewall on the server.C.    Configure the named SQL Server instance to use an account that is a member of the Domain Admins group.D.    Start the SQL Server Browser Service. Answer: D QUESTION 154You have a SQL Server 2012 database named Database1. You execute the following code:You insert 3 million rows into Sales. You need to reduce the amount of time it takes to execute Proc1.What should you do? A.    Run the following: ALTER TABLE Sales ALTER COLUMN OrderDate datetime NOT NULL;B.    Change the WHERE clause to the following: WHERE OrderDate BETWEEN CAST(@date1,char(10)) AND CAST(@date2,char(10))C.    Remove the ORDER BY clause from the stored procedure.D.    Run the following:DROP INDEX IX_Sales_OrderDate;GOCREATE INDEX IX_Sales_OrderDate ON Sales(OrderDate); GO Answer: CExplanation:http://www.c-sharpcorner.com/UploadFile/skumaar_mca/good-practices-to-write-the-stored-procedures-in-sqlserver/ QUESTION 155Your network contains a server that has SQL Server 2012 installed.You create a table by using the following script:You need to recommend a solution to ensure that each combination of ProductName and ProductManufacturer is not duplicated.What should you recommend creating? A.    A UNIQUE constraintB.    A CHECK constraintC.    A filtered indexD.    A column store index Answer: A Want Pass 70-464 Exam At the first try? Come to Braindump2go! Download the Latest Microsoft 70-464 Real Exam Questions and Answers PDF & VCE from Braindump2go,100% Pass Guaranteed Or Full Money Back! http://www.braindump2go.com/70-464.html --------------------------------------------------- Images: http://www.itexamquiz.com/braindump2go/bdimages/049d4f83eedc_F82A/1922.png http://www.itexamquiz.com/braindump2go/bdimages/049d4f83eedc_F82A/wpsE4E9.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/049d4f83eedc_F82A/wps2D6.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/049d4f83eedc_F82A/1522.png --------------------------------------------------- --------------------------------------------------- Post date: 2015-03-03 09:39:07 Post date GMT: 2015-03-03 09:39:07 Post modified date: 2015-03-03 09:39:08 Post modified date GMT: 2015-03-03 09:39:08 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com