Which Transact-SQL batch should you use?

Correct Answer for the following Question is given below You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail.You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline.Which Transact-SQL batch should you use?http://msdn.microsoft.com/en-us/library/ms188388.aspx Question: Which Transact-SQL … Read more

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 logins for the server:CORPEmployees – All company employeesCORPHRAdmins – HR administrators onlyHR Administrators are also company employees.You need to grant users … Read more

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 need to ensure that you can port the database to different database servers within the domain without additional user account configurations.Which … Read more

Which Transact-SQL statement should you use before attempting the restore?

Correct Answer for the following Question is given below You administer a Microsoft SQL Server 2012 database.You configure Transparent Data Encryption (TDE) on the Orders database by using the following statements:CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘MyPassword1!’ CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = ‘TDECertificate’; BACKUP CERTIFICATE TDE_Certificate TO FILE = ”d:TDE_Certificate.cer’ WITH PRIVATE KEY … Read more

What should you do?

Correct Answer for the following Question is given below 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?http://msdn.microsoft.com/en-us/library/ms174202.aspx Question: What should you do? Options: Query the sys.dm_db_index_usage_stats DMV. Query the … Read more

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 a table of valuesCannot be referenced within a viewWhich object should you use? Question: Which object should you use? Options: Scalar-valued … Read more

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 tables in the database and execute the stored procedure.You need to grant only the necessary permissions.What should you do? Question: What … Read more

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 SQL Server Agent jobs and execute SQL Server agent jobs owned by UserATo which role should you add UserA? Question: Which … Read more