This page was exported from Lead2pass New Updated Exam Questions [ https://www.getfreevce.com ] Export date:Thu Jan 23 4:14:23 2025 / +0000 GMT ___________________________________________________ Title: New Released Free Version of Microsoft 70-465 Exam Study Materials in Lead2pass (51-60) --------------------------------------------------- All the Lead2pass Microsoft 70-465 questions & answers in this product are designed by Microsoft certified experts and were given utmost attention to guarantee that it is 100% factual and not fabricated. Pass Microsoft 70-465 exam in first attempt ! QUESTION 51 You need to recommend changes to the ERP application to resolve the search issue. The solution must minimize the impact on other queries generated from the ERP application. What should you recommend changing?A.    The collation of the Products table B.    The index on the ProductName column C.    The collation of the ProductName column D.    The data type of the ProductName column Answer: C QUESTION 52 You need to recommend a solution that addresses the concurrency requirement. What should you recommend? A.    Call the stored procedures in a Distributed Transaction Coordinator (DTC) transaction. B.    Modify the stored procedures to update tables in the same order for all of the stored procedures. C.    Make calls to Sales.Proc1 and Sales.Proc2 synchronously. D.    Break each stored procedure into two separate procedures, one that changes Sales.Table1 and one that changes Sales.Table2. Answer: B Explanation: * Concurrency Requirements You must reduce the likelihood of deadlocks occurring when Sales.Proc1 and Sales.Proc2 execute. QUESTION 53 You need to recommend a solution that addresses the backup issue. The solution must minimize the amount of development effort. What should you include in the recommendation? A.    Indexed views B.    Filegroups C.    Table partitioning D.    Indexes Answer: B Explanation: * Backup Issues Customers who have large amounts of historical purchase order data report that backup time is unacceptable. * For very large databases (and by that, I mean, at least 500gb, but more like 5-10tb or more), it can become too expensive to regularly run a straight full backup . So, where needed, you can choose to backup smaller pieces of the database by choosing to back up one of the files or file groups that make up a database. QUESTION 54 You need to recommend a solution that meets the data recovery requirement. What should you include in the recommendation? A.    A differential backup B.    A transaction log backup C.    Snapshot isolation D.    A database snapshot Answer: D QUESTION 55 You need to recommend a solution that resolves the missing data issue. The solution must minimize the amount of development effort. What should you recommend? A.    Denormalize the Products table. B.    Denormalize the OrderDetails table. C.    Normalize the OrderDetails table. D.    Normalize the Products table. Answer: D Explanation: * Scenario: / Missing Data Issues Customers report that when they make a price change in the Products table, they cannot retrieve the price that the item was sold for in previous orders. / The current database schema contains a table named OrderDetails. The OrderDetails table contains information about the items sold for each purchase order. OrderDetails stores the product ID, quantities, and discounts applied to each product in a purchase order. The product price is stored in a table named Products. QUESTION 56 You need to recommend a solution that reduces the time it takes to import the supplier data. What should you include in the recommendation? A.    Enable instant file initialization. B.    Reorganize the indexes. C.    Disable Resource Governor. D.    Enable Auto Update Statistics. Answer: C Explanation: * The ERP application relies on an import process to load supplier data. The import process updates thousands of rows simultaneously, requires exclusive access to the database, and runs daily. QUESTION 57 You need to recommend a solution that addresses the file storage requirements. What should you include in the recommendation? A.    FileStream B.    FileTable C.    The varbinary data type D.    The image data type Answer: B Explanation: * Scenario: File Storage Requirements The ERP database stores scanned documents that are larger than 2 MB. These files must only be accessed through the ERP application. File access must have the best possible read and write performance. * FileTables remove a significant barrier to the use of SQL Server for the storage and management of unstructured data that is currently residing as files on file servers. Enterprises can move this data from file servers into FileTables to take advantage of integrated administration and services provided by SQL Server. At the same time, they can maintain Windows application compatibility for their existing Windows applications that see this data as files in the file system. QUESTION 58 You need to recommend a solution that addresses the installation issues. What should you include in the recommendation? A.    Windows logins B.    Server roles C.    Contained users D.    Database roles Answer: C Explanation: * Scenario: Installation Issues The current version of the ERP application requires that several SQL Server logins be set up to function correctly. Most customers set up the ERP application in multiple locations and must create logins multiple times. * Creating contained users enables the user to connect directly to the contained database. This is a very significant feature in high availability and disaster recovery scenarios such as in an AlwaysOn solution. If the users are contained users, in case of failover, people would be able to connect to the secondary without creating logins on the instance hosting the secondary. This provides an immediate benefit. QUESTION 59 You need to recommend a solution that addresses the security requirement. What should you recommend? A.    Revoke user permissions on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the stored procedures. B.    Grant the users the SELECT permission on the tables. Create views that retrieve data from the tables. Grant the users the SELECT permission on the views. C.    Deny the users SELECT permission on the tables. Create views that retrieve data from the tables. Grant the users the SELECT permission on the views. D.    Deny the users the SELECT permission on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the stored procedures. Answer: C Explanation: * Security Requirements You must provide users with the ability to execute functions within the ERP application, without having direct access to the underlying tables. QUESTION 60 You need to recommend a solution to ensure that USP_4 adheres to the security requirements. What should you include in the recommendation? A.    Enable SQL Server Audit. B.    Enable trace flags. C.    Configure data manipulation language (DML) triggers. D.    Enable C2 audit tracing. Answer: A Explanation: * Scenario: A stored procedure named USP_4 calls stored procedures in the Sales, Customers, and Inventory databases. The nested stored procedures read tables from the Sales, Customers, and Inventory databases. USP_4 uses an EXECUTE AS clause. * Beginning in SQL Server 2008 Enterprise, you can set up automatic auditing by using SQL Server Audit. Lead2pass Microsoft 70-465 study guide is prepared by the expert professionals in the IT industry who help you prepare for all the leading IT vendor exams. We do thorough research and analyze the current trends and requirement to provide relevant and regularly updated preparation material for you. Lead2pass's 70-465 exam study material will help in preparing for the expected questions and let you answer the questions in the most accurate manner in your 70-465 certification exams. http://www.lead2pass.com/70-465.html --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2014-12-04 08:20:23 Post date GMT: 2014-12-04 08:20:23 Post modified date: 2014-12-04 08:20:23 Post modified date GMT: 2014-12-04 08:20:23 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com