Tag: 70-764 PDF

Get Full Version of the Examhttp://www.EnsurePass.com/70-764.html Question No.201OverviewGeneral OverviewADatum Corporation has offices in Miami and Montreal.The network contains a single Active Directory forest named adatum.com. The offices connect to each other by using a WAN link that has 5-ms latency. A.Datum standardizes its database platform by using SQL Server 2014 Enterprise edition.DatabasesEach office contains databases named Sales, Inventory, Customers, Products, Personnel, and Dev.Servers Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/70-764.html Question No.211You need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights to view database information and server state for the Manufacturing database on MainDB1. What should you do?You should configure a Database Role.You should configure a Server Role.You should configure a Shared SQL Server Login.D.You should configure a Local Security Group.Correct Answer: B Question No.212You Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/70-764.html Question No.221You need to address the Sales Director#39;s requirements regarding the customer classification. You need to recommend a solution for changing the classifications. What should you recommend?Add each classification change to a new row in the Customers table.Record each change to the classification of each customer in a new row in the Customers table.Add a new row to the Customers table for each new classification.Record Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/70-764.html Question No.181OverviewYou are a database administrator for a company named Litware, Inc.Litware is a book publishing house. Litware has a main office and a branch office.You are designing the database infrastructure to support a new web-based application that is being developed.The web application will be accessed at www.litwareinc.com. Both internal employees and external partners will use the application.You have an existing Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/70-764.html Question No.191You plan to create a database. The database will be used by a Microsoft .NET application for a special event that will last for two days. During the event, data must be highly available. After the event, the database will be deleted. You need to recommend a solution to implement the database while minimizing costs. The solution must not affect any existing applications. What should you recommend? More than one answer Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/70-764.html Question No.161You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01.You need to be notified immediately when fatal errors occur on Server01. What should you create?an Alerta Server Audit Specificationan Extended Event sessiona Resource Poola Policya SQL Profiler Tracea Database Audit SpecificationCorrect Answer: AExplanation:http://www.sqlskills.com/blogs/glenn/creating-sql-server-agent-alerts-for-critical-errors/ Question Read more [...]