Online Access Free 70-469 Practice Test

---
You have a SQL Server instance on a server named Server1.
You need to recommend a solution to perform the following tasks every week:
Rebuild the indexes by using a new fill factor.
Run a custom T-SQL command.
Back up the databases.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.A trigger
• B.A maintenance plan
• C.An alert
• D.A system policy
• E.Windows PowerShell

DRAG DROP
Your network contains a server named Server1 that runs SQL Server 2012. Server1 contains an instance named Instance1. Instance1 contains a database named ContentDatabase.
ContentDatabase uses transaction log backups.
The recovery model of ContentDatabase is set to FULL.
You need to shrink the ContentDatabase_Log log file to 10 MB. The solution must ensure that you can continue to back up the transaction log.
Which three code segments should you execute?
To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

Correct Answer:

You are creating a table named Orders.
You need to ensure that every time a new row is added to the Orders table, a user-defined function is called to validate the row before the row is added to the table.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.A FOREIGN KEY constraint
• B.A DEFAULT constraint
• C.A data manipulation language (DML) trigger
• D.A CHECK constraint
• E.A Data Definition Language (DDL) trigger

You need to recommend a solution to meet the security requirements of the junior database administrators.
What should you include in the recommendation?

• A.A credential
• B.A database role
• C.A shared login
• D.A server role

You need to add a new column named Confirmed to the Employees table. The solution must meet the following requirements:
- Have a default value of TRUE. - Minimize the amount of disk space used.
Which code segment should you use?

• A.Option A
• B.Option D
• C.Option C
• D.Option B