What should you do?
Correct Answer for the following Question is given below You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the...
Category: Microsoft >> 70-764
Which feature should you use?
Correct Answer for the following Question is given below You are a database administrator for a Microsoft SQL Server 2012 environment.You want to deploy a new application that will scale out the workload to...
Which edition should you choose?
Correct Answer for the following Question is given below You plan to install Microsoft SQL Server 2012 for a web hosting company.The company plans to host multiple web sites, each supported by a SQL...
Which role should you add UserA?
Correct Answer for the following Question is given below You administer a Microsoft SQL Server 2012 database instance. You create a new user named UserA.You need to ensure that UserA is able to create...
What should you do?
Correct Answer for the following Question is given below You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.Users need to be able to SELECT from all...
What should you do?
Correct Answer for the following Question is given below You administer a Microsoft SQL Server 2012 instance that has multiple databases. You have a two-node SQL Server failover cluster. The cluster uses a storage...
What should you use?
Correct Answer for the following Question is given below You administer a Microsoft SQL Server 2012 database.You have a SQL Server Agent job instance that runs using the service account. You have a job...
Which object should you use?
Correct Answer for the following Question is given below You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that meets the following requirements:Takes an input variableReturns...
What should you do?
Correct Answer for the following Question is given below You administer a Windows Azure SQL Database database named Human_Resources. The database contains 2 tables named Employees and SalaryDetails. You add two Windows groups as...
Which type of user should you create?
Correct Answer for the following Question is given below 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...