Microsoft-Administering Microsoft SQL Server 2012 Databases Set 3

You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with multiple event names and their dates as parameters. What should you do?

You develop a Microsoft SQL Server 2012 database. The database is used by two web applications that access a table named Products. You want to create an object that will prevent the applications from accessing the table directly while still providing access to the required data. You need to ensure that the following requirements are met: Future modifications to the table definition will not affect the applications' ability to access data. The new object can accommodate data retrieval and data modification. You need to achieve this goal by using the minimum amount of changes to the applications. What should you create for each application?

You administer a Microsoft Azure SQL Database instance 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?

You work as the Senior Database Administrator (DBA) at ABC.com. The company has a main office and 10 branch offices. Each branch office contains a single database server running Microsoft SQL Server 2012. The main office has multiple clustered servers running Microsoft SQL Server 2012. Your role includes the management of the entire Microsoft SQL Server 2012 infrastructure. The company runs a custom application that stores data in a large Microsoft SQL Server 2012 database. The primary database is hosted in the main office. Each branch office SQL Server hosts a copy of the database. You need to configure a solution that will replicate the entire primary database from the main office SQL Server every weekend. What should you include in your solution?

You work as a Database Administrator (DBA) at ABC.com. The infrastructure includes servers running Microsoft SQL Server 2012. All databases are hosted on a SAN (Storage Area Network). You need to design a database solution for a new application. You are tasked with designing a high-availability database solution. The solution must include a single copy of the database to save disk space and the database must remain online in the event of a SQL Server failure. What should you include in your solution?

You work as a Database Administrator (DBA) at ABC.com. The infrastructure includes servers running Windows Server 2008 R2 and Microsoft SQL Server 2012. The company uses several custom applications that store data in databases on the Microsoft SQL Server 2012 servers. A full backup of all databases is taken every night at midnight. A differential backup of all databases is taken on the hour every hour starting at 3am until the last backup at 11pm. A log backup is taken every 15 minutes for databases configured with the Full Recovery Model. One application named ABCApp1 stores data in a database named ABCApp1DB. ABCApp1DB is configured with the Simple Recovery Model. ABCApp1DB fails at 3:25am. You discover that the last differential backup of ABCApp1DB failed. You need to restore ABCApp1DB from backup as quickly as possible and minimize data loss. Which of the following steps should you perform to restore ABCApp1DB? (Choose one or more answers).

You are planning on deploying a server that will be dedicated for ETL (Extraction, Transformation, and Loading) processes. You want to ensure that SSIS (SQL Server Integration Services) packages will run on this dedicated ETL server and not on any other server on which they were started. Which of the following features must you install on the ETL server in addition to SSIS to accomplish this goal?

You have installed the SQL Server Integration Services (SSIS) feature on a server running Windows Server 2008 R2 SP1. Which of the following features must you install if you want to ensure that you can run packages in 32-bit mode?

You have recently removed a SQL 2012 Database Engine instance from a computer running the Windows Server 2008 R2 operating system. Prior to the removal of the instance, you had configured affinity so that the default instance used CPU 0 and 1 and the second instance used CPU 2 and 3. You want to ensure that the default instance can use all processors available to the host. Which of the following commands would you use to accomplish this goal?

You have configured Resource Governor with three resource pools. You have assigned the first resource pool a minimum CPU and memory value of 20%. You have assigned the second resource pool a minimum CPU and memory value of 30%. You want to assign maximum CPU and memory values to the third resource pool. What is the maximum CPU and memory value you can assign to this resource pool?