- All Exams Instant Download
Which four Transact-SQL statements should you use?
DRAG DROP You administer a Microsoft SQL Server 2012 server that has a database named Contoso. The Contoso database has a table named EmployeeSalary in a schema named HumanResources. You need to create a script that writes audit events into the application log whenever data in the EmployeeSalary table is...
Which permission or permissions should you assign to UserC?
You administer a Microsoft SQL Server 2012 database. The database has a table named Customers owned by UserA and another table named Orders owned by UserB. You also have a stored procedure named GetCustomerOrderInfo owned by UserB. GetCustomerOrderInfo selects data from both tables. You create a new user named UserC....
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that data changes are sent to a non-SQL Server database server in near real time. You also need to ensure that data on the primary server is unaffected. Which configuration should you use?A...
Which permission or permissions should you choose?
DRAG DROP You administer a Microsoft SQL Server 2012 server along with a Windows Azure SQL Database database. For both servers, you need to grant users the ability to create logins and create databases. You need to determine which permission to grant users in each instance. Which permission or permissions...
Which user account should you use?
You administer a SQL Server 2012 database instance. You need to configure the SQL Server Database Engine service on a failover cluster. Which user account should you use?A . A domain userB . The BUILTINSYSTEM accountC . A local user with Run as Service permissionsD . TheSQLBrowser accountView AnswerAnswer: A
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 server that has multiple databases. You need to ensure that users are unable to create stored procedures that begin with sp_. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to...
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company. A database contains a large product catalog that is updated periodically. You need to be able to send the entire product catalog to all branch offices on a monthly basis. Which configuration should you use?A . •...
Which user account should you use?
You administer a SQL Server 2012 database instance. You need to configure the SQL Server Database Engine service on a failover cluster. Which user account should you use?A . A domain userB . The BUILTINSYSTEM accountC . A local user with Run as Service permissionsD . TheSQLBrowser accountView AnswerAnswer: A
What should you do?
You administer a Microsoft SQL Server 2012 instance. You discover that the SQL Agent Error Log file is rapidly growing in size. You need to ensure that the SQL Agent Error Log file does not grow rapidly when SQL Server agent jobs execute. What should you do?A . Execute the...
Which type of solution should you use?
You administer a Microsoft SQL Server 2012 database that includes a table named dbo.Log. This table contains millions of records about user activity in an application. Records in dbo.Log that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts....
