[Free] 2018(June) Dumps4cert Microsoft 70-462 Dumps with VCE and PDF Download 131-140

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: 131 – (Topic 2)

You use Microsoft SQL Server 2012 to develop a database application. You need to implement a computed column that references a lookup table by using an INNER JOIN against another table.

What should you do?

  1. Reference a user-defined function within the computed column.

  2. Create a BEFORE trigger that maintains the state of the computed column.

  3. Add a default constraint to the computed column that implements hard-coded values.

  4. Add a default constraint to the computed column that implements hard-coded CASE statements.

Answer: A

Question No: 132 – (Topic 2)

You administer a Windows Azure SQL Database database named Human_Resources. The database contains 2 tables named Employees and SalaryDetails.

You add two Windows groups as logins for the server:

->CORP\Employees – All company employees

->CORP\HRAdmins – HR administrators only

->HR Administrators are also company employees.

You need to grant users access according to the following requirements:

->CORP\Employees should have SELECT access to the Employees table.

->Only users in CORP\HRAdmins should have SELECT access to the SalaryDetails table.

->Logins are based only on Windows security groups.

What should you do?

A.

Create a database role called Employees.

Add CORP\Employees to the db_datareader role.

Add all company employees except HR administrators to the Employees role. Deny SELECT access to the SalaryDetails table to the Employees role.

B.

Create a database role called HRAdmins.

Add all company employees except HR administrators to the db_datareader role, Add all HR administrators to the HRAdmins role.

Grant SELECT access to the SalaryDetails table to the HRAdmins role. Deny SELECT access to the SalaryDetails table to the db_datareader role. C.

Create two database roles: Employees and HRAdmins. Add all company employees to the Employees role.

Add HR administrators to the HRAdmins role.

Grant SELECT access to all tables except SalaryDetails to the Employees role. Grant SELECT access to the SalaryDetails table to the HRAdmins role.

Deny SELECT access to the SalaryDetails table to the Employees role.

D. Create a database role called Employees.

Add all HR administrators to the db_datareader role. Add all company employees to the Employees role.

Grant SELECT access to all tables except the SalaryDetails table to the Employees role. Deny SELECT access to the SalaryDetails table to the Employees role.

Answer: D

Question No: 133 DRAG DROP – (Topic 2)

You administer a Microsoft SQL Server database instance that uses transparent database encryption.

You plan to move the database from the current server to a new server by using Backup and Restore.

You need to ensure that the database can be restored to the new server. You also need to ensure that the database remains encrypted at all times.

Which four 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: 134 – (Topic 2)

Which of the following permissions must a user have in order to query all of the built-in Dynamic Management views?

  1. VIEW ALL

  2. SELECT ALL VEWS

  3. VIEW SERVER INFO

  4. VIEW SERVER STATE

Answer: D

Explanation: References:

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

Question No: 135 – (Topic 2)

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?

  1. Partitioned tables

  2. Online index rebuild

  3. Change data capture

  4. Change tracking

Answer: A

Question No: 136 – (Topic 2)

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?

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

Reference: http://msdn.microsoft.com/en-us/library/ms188362.aspx

Question No: 137 DRAG DROP – (Topic 2)

You administer several Microsoft SQL Server 2012 servers.

You want to run scheduled checks to confirm that the databases on the servers are not configured to AutoShrink.

You need to create a policy to check the condition.

What should you do? (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

Explanation:

Box 1:

Dumps4Cert 2018 PDF and VCE

Box 2:

Dumps4Cert 2018 PDF and VCE

Box 3:

Dumps4Cert 2018 PDF and VCE

Note:

  • @autoshrink is used to enable/disable the autoshrink feature.

  • The Evaluation Mode defines the combination of 1) when the policy will be evaluated and

2) what the system will do in case of policy violation. The following evaluation modes are supported:

Dumps4Cert 2018 PDF and VCE

Question No: 138 – (Topic 2)

Which of the following DBCC commands shows optimizer statistics for objects such as tables?

  1. STATS

  2. SHOW_STATISTICS

  3. OBJECT_STATS

  4. OPTIMIZER

Answer: B

Explanation: References:

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

Question No: 139 – (Topic 2)

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

  1. Restore the latest full backup.

  2. Restore the latest differential backup

  3. Restore the latest log backup

  4. Restore each differential backup taken since the last full backup.

  5. Restore each log backup since the last full backup.

Answer: A

Question No: 140 – (Topic 2)

You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores.

You discover performance issues when complex calculations are performed on large amounts of data under heavy system load.

You need to limit the number of cores that process the calculations. What should you configure?

  1. Max worker threads

  2. Processor affinity

  3. I/O affinity

  4. Lightweight pooling

Answer: B Explanation:

To carry out multitasking, the operating system sometimes moves process threads among different processors. This is efficient from an operating system point of view, but can reduce SQL Server performance under heavy system loads, as each processor cache is repeatedly reloaded with data. Assigning processors to specific threads can improve performance under these conditions by eliminating processor reloads; such an association between a thread and a processor is called processor affinity.

References:

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

100% Dumps4cert Free Download!
Download Free Demo:70-462 Demo PDF
100% Dumps4cert Pass Guaranteed!
Download 2018 Dumps4cert 70-462 Full Exam PDF and VCE

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.