Apr 2016 updated: transcender 70-462

Vivid of 70-462 free practice exam materials and paper for Microsoft certification for examinee, Real Success Guaranteed with Updated 70-462 pdf dumps vce Materials. 100% PASS Administering Microsoft SQL Server 2012 Databases exam Today!

2016 Apr 70-462 Study Guide Questions:

Q46. You plan to install Microsoft SQL Server 2012 for a web hosting company. 

The company plans to host multiple web sites, each supported by a SQL Server database. 

You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total cost of ownership. 

Which edition should you choose? 

A. Express Edition with Tools 

B. Standard Edition 

C. Web Edition 

D. Express Edition with Advanced Services 

Answer: B 


Q47. 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 to allow remote connections even if the SQL Server is unresponsive to client connections. 

What should you do? Choose all that apply. 

A. Enable inbound connections on TCP port 1434 in the Windows Firewall on the server. 

B. Execute the following Transact-SQL command: sp_configure 'remote admin connections', C. Execute the Reconfigure command. 

D. Execute the following Transact-SQL command: sp_configure 'remote access', 1 

E. Restart the SQL Server Agent Service. 

F. Enable inbound connections on TCP port 135 in the Windows Firewall on the server. 

Answer: ABC 


Q48. You administer a Microsoft SQL Server 2012 server. The MSSQLSERVER service uses a domain account named CONTOSO\SQLService. 

You plan to configure Instant File Initialization. 

You need to ensure that Data File Autogrow operations use Instant File Initialization. 

What should you do? Choose all that apply. 

A. Restart the SQL Server Agent Service. 

B. Disable snapshot isolation. 

C. Restart the SQL Server Service. 

D. Add the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy. 

E. Add the CONTOSO\SQLService account to the Server Operators fixed server role. 

F. Enable snapshot isolation. 

Answer: CD 


Q49. You administer a Microsoft SQL Server 2012 instance that has multiple databases. You have a two-node SQL Server failover cluster. The cluster uses a storage area network (SAN). 

You discover I/O issues. The SAN is at capacity and additional disks cannot be added. 

You need to reduce the I/O workload on the SAN at a minimal cost. 

What should you do? 

A. Move user databases to a local disk. 

B. Expand the tempdb data and log files. 

C. Modify application code to use table variables. 

D. Move the tempdb files to a local disk. 

Answer: D 


Q50. You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly. 

You discover that a large amount of memory is consumed by single-use dynamic queries. 

You need to reduce procedure cache usage from these statements without creating any additional indexes. 

What should you do? 

A. Add a HASH hint to the query. 

B. Add a LOOP hint to the query. 

C. Add a FORCESEEK hint to the query. 

D. Add an INCLUDE clause to the index. 

E. Add a FORCESCAN hint to the Attach query. 

F. Add a columnstore index to cover the query. 

G. Enable the optimize for ad hoc workloads option. 

H. Cover the unique clustered index with a columnstore index. 

I. Include a SET FORCEPLAN ON statement before you run the query. 

J. Include a SET STATISTICS PROFILE ON statement before you run the query. 

K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query. 

L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query. 

M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query. 

N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query. 

Answer: G 


70-462 brain dumps

Refresh sql server 2012 exam 70-462:

Q51. You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment. 

All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs access to the SQL Server. 

You need to create a server role named SpecialDBARole that can perform the following functions: 

View all databases. 

View the server state. 

Assign GRANT, DENY, and REVOKE permissions on logins. 

You need to add DOMAIN\JrDBAs to the server role. You also need to provide the least level of privileges necessary. 

Which SQL statement or statements should you use? Choose all that apply. 

A. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin; 

B. ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAIN\JrDBAs]; 

C. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin; 

D. GRANT VIEW DEFINITION TO [SpecialDBARole]; 

E. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin; 

F. GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole]; 

Answer: BCF 


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


Q53. You develop a database for a travel application. You need to design tables and other database objects. You need to store media files in several tables. Each media file is less than 1 MB in size. 

The media files will require fast access and will be retrieved frequently. 

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: F


Q54. You administer a Microsoft SQL Server 2012 database that includes a table named Application.Events. Application.Events contains millions of records about user activity in an application. 

Records in Application.Events that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts. 

You need to be able to modify Application.Events without requiring any changes to the applications that utilize Application.Events. 

Which type of solution should you use? 

A. Partitioned tables 

B. Online index rebuild 

C. Change data capture 

D. Change tracking 

Answer: A 


Q55. You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured. 

When SQL Server Agent jobs fail, the error messages returned by the job steps do not provide the required detail. 

The following error message is an example error message: 

"The job failed. The Job was invoked by User CONTOSO\ServiceAccount. The last step to run was step 1 (Subplan_1)." 

You need to ensure that all available details of the job step failures for SQL Server Agent jobs are retained. 

What should you do? 

A. Configure output files. 

B. Expand agent logging to include information from all events. 

C. Disable the Limit size of job history log feature. 

D. Configure event forwarding. 

Answer: B 


70-462 exam cost

Real 70-462 braindump:

Q56. You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. 

You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. 

You need to configure the SQL Server environment to support these packages. 

What should you do? 

A. Create SSIS configuration files for the packages. 

B. Create an Integration Services catalog. 

C. Install Data Quality Services. 

D. Install Master Data services. 

Answer: B 


Q57. You administer a Microsoft SQL Server 2012 database named ContosoDB. The database contains a table named Suppliers and a column named IsActive in the Purchases schemA. 

You create a new user named ContosoUser in ContosoDB. ContosoUser has no permissions to the Suppliers table. 

You need to ensure that ContosoUser can delete rows that are not active from Suppliers. You also need to grant ContosoUser only the minimum required permissions. 

Which Transact-SQL statement should you use? 

A. GRANT DELETE ON Purchases. Suppliers TC ContosoUser 

B. CREATE PROCEDURE Purchases.PurgelnactiveSuppliers WITH EXECUTE AS USER = 'dbo' AS DELETE FROM Purchases.Suppliers WHERE IsActive = 0 GO GRANT EXECUTE ON Purchases.PurgelnactiveSuppliers TO ContosoUser 

C. GRANT SELECT ON Purchases.Suppliers TO ContosoUser 

D. CREATE PROCEDURE Purchases. PurgeInactiveSuppliers AS DELETE FROM Purchases.Suppliers WHERE IsActive = 0 GO GRANT EXECUTE ON Purchases. PurgeInactiveSuppliers TO ContosoUser 

Answer: B 


Q58. You administer a Microsoft SQL Server 2012 database. 

The database contains a customer table created by using the following definition: 


You need to ensure that the minimum amount of disk space is used to store the data in the customer table. 

What should you do? 

A. Implement row-level compression. 

B. Implement page-level compression. 

C. Convert all indexes to Column Store indexes. 

D. Implement Unicode compression. 

Answer: B 


Q59. You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. 

The recovery model and backup schedule are configured as shown in the following table: 


The differential backup of the reporting database fails. Then, the reporting database fails at 14:00 hours. 

You need to ensure that the reporting database is restored. You also need to ensure that data loss is minimal. 

What should you do? 

A. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup. 

B. Perform a point-in-time restore. C Restore the latest full backup. 

C. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup. 

D. Restore the latest full backup. Then, restore the latest differential backup. 

E. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup. 

F. Perform a page restore. 

G. Perform a partial restore. 

Answer: C 


Q60. 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 a dedicated LUN (drive E). 

. Drive D has 1 terabyte of free disk space. . Drive E has 5 GB of free disk space. 

The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. 

Five percent of the existing data is modified each day. 

The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. 

Each data load adds 3 GB of data to the database. 

These data load operations must occur in the minimum amount of time. 

A full database backup is performed every Sunday at 10:00 hours. 

Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours. 

You implement log shipping of the financial database to another SQL Server 2012 instance. 

You decide to failover to this secondary database. 

You need to ensure that all transactions will be replicated to the secondary database. 

Which backup option should you use? 

A. Differential 

B. Transaction Log 

C. FULL 

D. SIMPLE 

E. SKIP 

F. RESTART 

G. STANDBY 

H. CHECKSUM 

I. DBO_ONLY 

J. COPY_ONLY 

K. NORECOVERY 

L. NO_CHECKSUM 

M. CONTINUE_AFTER_ERROR 

N. BULK_LOGGED 

Answer: K 



see more 70-462 - Administering Microsoft SQL Server 2012 Databases

Microsoft 70-462 Certification Sample Questions and Answers: http://www.braindumpsall.net/70-462-dumps/

P.S. New 70-462 dumps PDF: http://www.4easydumps.com/70-462-dumps-download.html