Administering Microsoft SQL Server 2012 Databases
Question No: 161 – (Topic 2)
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?
Use the CAST function.
Use the DATE data type.
Use the FORMAT function.
Use an appropriate collation.
Use a user-defined table type.
Use the VARBINARY data type.
Use the DATETIME data type.
Use the DATETIME2 data type.
Use the DATETIMEOFFSET data type.
Use the TODATETIMEOFFSET function.
Question No: 162 DRAG DROP – (Topic 2)
You are a database administrator of a Microsoft SQL Server 2012 environment. The environment contains two servers named SQLServer01 and SQLServer02. The database Contoso exists on SQLServer01.
You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring.
You need to prepare the Contoso database for database mirroring.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Question No: 163 – (Topic 2)
You administer a Windows Azure SQL Database database named Orders. You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?
BACKUP DATABASE Orders TO DISK = #39;D:\Orders.bak#39;RESTORE DATABASE Orders_Reporting FROM DISK = #39;D:\Orders.bak
BACKUP DATABASE Orders TO DISK = #39;D:\Orders.bak#39;CREATE DATABASE Orders_Reporting FROM DISK = #39;D:\Orders.bak
CREATE DATABASE Orders_Reporting AS COPY OF Orders
BACKUP DATABASE Orders TO DISK = #39;D:\Orders.bak#39;MIRROR TO DISK = #39;Orders_Reporting
Question No: 164 DRAG DROP – (Topic 2)
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 minimally logged.
Which data import command and recovery model should you choose? (To answer, drag the appropriate data import command or recovery model to the appropriate location or locations in the answer area. Each data import command or recovery model may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)
Question No: 165 – (Topic 2)
Which of the following is NOT a hardware requirement for SQL Server 2012?
6GB of hard drive space
1GB of memory
1GHZ CPU speed
a graphics card with 2GB video memory
Question No: 166 – (Topic 2)
Which of the following statements will create an index called “SalesDate” on the DATEOFSALE column on the SALES table residing in the WAREHOUSE database?
CREATE INDEX SalesDate ON SALES (DATEOFSALE);
MAKE INDEX SalesDate ON SALES (DATEOFSALE);
CREATE INDEX ON SALES (DATEOFSALE);
CREATE INDEX SalesDate ON SALES DATEOFSALE;
Question No: 167 DRAG DROP – (Topic 2)
You create a view based on the following statement:
You grant the Select permission to User1 for this view. You need to change the view so that it displays only the records that were processed in the month prior to the current month. You need to ensure that after the changes, the view functions correctly for User1. Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)
Question No: 168 – (Topic 2)
Which of the following is the default port for an SQL Server database to communicate over?
B. 21 C. 1344 D. 1521
Question No: 169 – (Topic 2)
You are the administrator of a Microsoft SQL Server 2012 server.
Some applications consume significant resources. You need to manage the server workload by restricting resource-intensive applications
You need to dynamically limit resource consumption. What should you do?
Configure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource Governor
Set up Service Broker to ensure that application are not allowed to consume more than the specified amount of resource
Create a new rule for each application that sets the resource limit allowed
Create a new plan Guide with a Scope Type of sql and define the resource limits for each application
Question No: 170 – (Topic 2)
You install a Microsoft SQL Server 2012 instance.
The instance will store data extracted from two databases running on Windows Azure SQL Database.
You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the data.
You need to ensure that the data steward is given the correct client tools to perform these tasks.
Which set of tools should you install?
SQL Server Management Studio and Distributed Reply Client
Data Quality Client and SQL Server Data Tools
Data Quality Client and Distributed Replay Client
SQL Server Management Studio and Master Data Services