- All Exams Instant Download
Which three actions should you perform?
You administer a Microsoft SQL Server instance. You need to configure a new database to support FILETABLES. Which three actions should you perform? Each correct answer presents part of the solution.A . Disable FILESTREAM on the Database.B . Enable FILESTREAM on the Server Instance.C . Configure the Database for Partial...
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 Transact-SQL command should you use?
You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a database named Orders. Users report that a query that filters on OrderDate is taking an exceptionally long time. You discover that an index named IX_OrderDate on the CustomerOrder table is...
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 four actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 clustered instance that has two nodes named Node 1 and Node 2. Node 1 fails and the cluster fails over to Node 2. You need to replace Node 1 and add it to the cluster. Which four actions should you perform...
Which two permission or permissions should you assign to UserC?
You administer a Microsoft SQL Server 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. You...
What should you do?
You administer a Microsoft SQL Server database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sales schema. You need to manage users who are prevented from deleting records in the Sales schema. You need to...
How should you configure HaContoso?
You create an availability group named HaContoso that has replicas named Server01/HA, Server02/HA, and Server03/HA. Currently, Server01/HA is the primary replica. You need to ensure that the following requirements are met: - Backup operations occur on Server02/HA. - If Server02/HA is unavailable, backup operations occur on Server03/HA. - Backup operations...
Which Transact-SQL statement should you use?
You administer a Microsoft SQL Server database. You create an availability group named haContosoDbs. Your primary replica is available at Server01Contoso01. You need to configure the availability group to prevent data loss. In the event of a database failure, the designed secondary database must come online automatically. Which Transact-SQL statement...
What should you do?
You administer two instances of Microsoft SQL Server. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?A...
