- All Exams Instant Download
Which data import command and recovery model should you choose?
DRAG DROP You administer a Microsoft SQL Server database. You want to import data from a text file to the database. You need to ensure that the following requirements are met: - Data import is performed by using a stored procedure. - Data is loaded as a unit and is...
What should you do?
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?A . Query the sys.dm_db_index_usage_stats DMC . Query the sys.dm_db_missing_index_details DME . Use the Database...
Which Transact-SQL statement should you use?
You administer a SQL Server 2012 server that contains a database named SalesDB. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales. UserA is granted the Select permission on the Regions table and the Sales...
What should you do?
You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply.A . Disable FILESTREAM on the Database.B . Enable FILESTREAM on the Server Instance.C . Configure the Database for Partial Containment.D . Create a non-empty...
Which recovery model should the database use?
You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: A data file of 2 terabytes is located on a dedicated LUN (drive D). A transaction log of 10 GB is located on...
Which Transact-SQL statement should you use?
You administer a SQL 2012 server that contains a database named SalesDB. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales. UserA is granted the Select permission on the Regions table. The Sales role 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....
What should you do?
You administer a Microsoft SQL Server 2012 default instance. The instance is hosted by a server that has a local firewall configureD. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server. You need to ensure that the instance is configured...
Which tool or tools should you use?
DRAG DROP You administer a Microsoft SQL Server database that is used by an application. Users of the application report performance issues. You need to choose the appropriate tool for performance-tuning of SQL Server databases. Which tool or tools should you use? (To answer, drag the appropriate tool or tools...
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...
