Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 May Microsoft Official New Released 70-462
100% Free Download! 100% Pass Guaranteed!

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?

  1. Use the CAST function.

  2. Use the DATE data type.

  3. Use the FORMAT function.

  4. Use an appropriate collation.

  5. Use a user-defined table type.

  6. Use the VARBINARY data type.

  7. Use the DATETIME data type.

  8. Use the DATETIME2 data type.

  9. Use the DATETIMEOFFSET data type.

  10. Use the TODATETIMEOFFSET function.

Answer: E

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.)

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

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?

  1. BACKUP DATABASE Orders TO DISK = #39;D:\Orders.bak#39;RESTORE DATABASE Orders_Reporting FROM DISK = #39;D:\Orders.bak

  2. BACKUP DATABASE Orders TO DISK = #39;D:\Orders.bak#39;CREATE DATABASE Orders_Reporting FROM DISK = #39;D:\Orders.bak

  3. CREATE DATABASE Orders_Reporting AS COPY OF Orders

  4. BACKUP DATABASE Orders TO DISK = #39;D:\Orders.bak#39;MIRROR TO DISK = #39;Orders_Reporting

Answer: C

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.)

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 165 – (Topic 2)

Which of the following is NOT a hardware requirement for SQL Server 2012?

  1. 6GB of hard drive space

  2. 1GB of memory

  3. 1GHZ CPU speed

  4. a graphics card with 2GB video memory

Answer: D

Explanation: References:

https://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx

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?

  1. CREATE INDEX SalesDate ON SALES (DATEOFSALE);

  2. MAKE INDEX SalesDate ON SALES (DATEOFSALE);

  3. CREATE INDEX ON SALES (DATEOFSALE);

  4. CREATE INDEX SalesDate ON SALES DATEOFSALE;

Answer: A

Explanation: References:

https://msdn.microsoft.com/en-us/library/ms188783(v=sql.110).aspx

Question No: 167 DRAG DROP – (Topic 2)

You create a view based on the following statement:

Dumps4Cert 2018 PDF and VCE

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.)

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Explanation:

Dumps4Cert 2018 PDF and VCE

Explanation/Reference:

http://msdn.microsoft.com/en-us/library/hh213020.aspx http://msdn.microsoft.com/en-us/library/ms186819.aspx http://msdn.microsoft.com/en-us/library/ms173846.aspx

Question No: 168 – (Topic 2)

Which of the following is the default port for an SQL Server database to communicate over?

A. 1433

B. 21 C. 1344 D. 1521

Answer: A

Explanation: References:

https://msdn.microsoft.com/en-us/library/ms177440(v=sql.110).aspx

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?

  1. Configure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource Governor

  2. Set up Service Broker to ensure that application are not allowed to consume more than the specified amount of resource

  3. Create a new rule for each application that sets the resource limit allowed

  4. Create a new plan Guide with a Scope Type of sql and define the resource limits for each application

Answer: A

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?

  1. SQL Server Management Studio and Distributed Reply Client

  2. Data Quality Client and SQL Server Data Tools

  3. Data Quality Client and Distributed Replay Client

  4. SQL Server Management Studio and Master Data Services

Answer: B

100% Dumps4cert Free Download!
Download Free Demo:70-462 Demo PDF
100% Dumps4cert Pass Guaranteed!
70-462 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No