70-462 Exam Questions - Online Test

70-462 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

Proper study guides for Improved Microsoft Administering Microsoft SQL Server 2012 Databases certified begins with Microsoft microsoft 70 462 preparation products which designed to deliver the Refined 70 462 pdf questions by making you pass the 70 462 exam dumps test at your first time. Try the free 70 462 training kit pdf demo right now.

Q41. You administer a single server that contains a Microsoft SQL Server 2012 default instance. 

You plan to install a new application that requires the deployment of a database on the server. The application login requires sysadmin permissions. 

You need to ensure that the application login is unable to access other production databases. 

What should you do? 

A. Use the SQL Server default instance and configure an affinity mask. 

B. Install a new named SQL Server instance on the server. 

C. Use the SQL Server default instance and enable Contained Databases. 

D. Install a new default SQL Server instance on the server. 

Answer: B 

Q42. 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 FILESTREAM file group. 

E. Enable Contained Databases on the Server Instance. 

F. Set the FILESTREAM directory name on the Database. 

Answer: BDF 

Q43. You administer a Windows Azure SQL Database database 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? 

A. Grant EXECUTE permission on p_AddInventory to all users. Grant VIEW DEFINITION to all users. 

B. Grant EXECUTE permission on p_AddInventory to all users. Add all users to the db_datawriter role. 

C. Add all users to the db_owner role. 

D. Grant EXECUTE permission on p_Add!nventory to all users. Add all users to the db_datareader role. 

Answer: D 

Q44. Your database contains a table named Purchases. The table includes a DATETIME column named PurchaseTime that stores the date and time each purchase is made. There is a non-clustered index on the PurchaseTime column. The business team wants a report that displays the total number of purchases made on the current day. You need to write a query that will return the correct results in the most efficient manner. 

Which Transact-SQL query should you use? 

A. SELECT COUNT(*) 

FROM Purchases 

WHERE PurchaseTime = CONVERT(DATE, GETDATE()) 

B. SELECT COUNT(*) 

FROM Purchases 

WHERE PurchaseTime = GETDATE() 

C. SELECT COUNT(*) 

FROM Purchases 

WHERE CONVERT(VARCHAR, PurchaseTime, 112) = CONVERT(VARCHAR, 

GETDATE(), 112) 

D. SELECT COUNT(*) 

FROM Purchases 

WHERE PurchaseTime >= CONVERT(DATE, GETDATE()) 

AND PurchaseTime < DATEADD(DAY, 1, CONVERT(DATE, GETDATE())) 

Answer: D

Q45. You administer two instances of Microsoft SQL Server 2012. 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. Use the Data Quality Client to configure the application. 

B. Start the SQL Server Browser Service. 

C. Use the Master Data Services Configuration Manager to configure the application. 

D. Start the SQL Server Integration Services Service. 

Answer: B 

Q46. You are implementing a SQL Server 2012 five-node failover cluster. 

You need to choose a quorum configuration. 

Which configuration should you use? 

A. Distributed File System (DFS) 

B. Node Majority 

C. Cluster Shared Volume (CSV) 

D. Node and Disk Majority 

Answer: D

Q47. You develop a database for a travel application. You need to design tables and other database objects. You create a view that displays the dates and times of the airline schedules on a report. 

You need to display dates and times in several international formats. 

What should you do? 

A. Use the CAST function. 

B. Use the DATE data type. 

C. Use the FORMAT function. 

D. Use an appropriate collation. 

E. Use a user-defined table type. 

F. Use the VARBINARY data type. 

G. Use the DATETIME data type. 

H. Use the DATETIME2 data type. 

I. Use the DATETIMEOFFSET data type. 

J. Use the TODATETIMEOFFSET function. 

Answer: C

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

You need to ensure that UserC can call the GetCustomerOrderInfo stored procedure. You also need to assign only the minimum required permissions to UserC. 

Which permission or permissions should you assign to UserC? Choose all that apply. 

A. The Select permission on Customers 

B. The Execute permission on GetCustomerOrderInfo 

C. The Take Ownership permission on Customers 

D. The Control permission on GetCustomerOrderInfo 

E. The Take Ownership permission on Orders 

F. The Select permission on Orders 

Answer: AB 

Q49. You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports a highly active OLTP application. 

Users report abnormally long wait times when they submit data into the application. 

You need to identify which queries are taking longer than 1 second to run over an extended period of time. 

What should you do? 

A. use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of more than 1,000. 

B. Use sp_configure to set a value for blocked process threshold. Create an extended event session. 

C. Use the Job Activity monitor to review all processes that are actively running. Review the Job History to find out the duration of each step. 

D. Run the sp_who command from a query window. 

E. Run the DBCC TRACEON 1222 command from a query window and review the SQL Server event log. 

Answer: E 

Q50. You administer a Microsoft SQL Server 2012 database named Orders. 

Users report that during peak usage periods, certain operations are taking more time than expected. Your initial analysis suggests that blocking is the cause. 

You need to gather more data to be able to determine which processes are being blocked and to identify the root cause. 

What should you do? 

A. Start a trace using SQL Server Profiler to catch the Lock: Deadlock event. 

B. Use sp_configure to set the blocked process threshold. Start a trace using SQL Server Profiler to catch the Blocked Process Report event. 

C. Schedule a SQL Agent job to run every 60 seconds and insert the results of executing the sys.dm_os_wait_stats DMV into a table. 

D. Use System Monitor to catch the Lock Waits/sec event. 

Answer: B