READ Free Dumps For Microsoft- 70-461
| Question ID 15108 | You are maintaining a Microsoft SQL Server database that stores order information for an
online store website. The database contains a table that is defined by the following
Transact-SQL statement:
You need to ensure that purchase order numbers are used only for a single order.
What should you do?
|
| Option A | Create a new CLUSTERED constraint on the PurchaseOrderNumber column.
|
| Option B | Create a new UNIQUE constraint on the PurchaseOrderNumber column.
|
| Option C | Create a new PRIMARY constraint on the PurchaseOrderNumber column.
|
| Option D | Create a new FOREIGN KEY constraint on the PurchaseOrderNumber column.
|
| Correct Answer | B |
Explanation Explanation: You can use UNIQUE constraints to make sure that no duplicate values are entered in specific columns that do not participate in a primary key. Although both a UNIQUE constraint and a PRIMARY KEY constraint enforce uniqueness, use a UNIQUE constraint instead of a PRIMARY KEY constraint when you want to enforce the uniqueness of a column, or combination of columns, that is not the primary key. Reference: UNIQUE Constraints https://technet.microsoft.com/en-us/library/ms191166(v=sql.105).aspx
| Question ID 15109 | Your application contains a stored procedure for each country. Each stored procedure
accepts an employee identification number through the @EmpID parameter.
You need to build a single process for each employee that will execute the appropriate
stored procedure based on the country of residence.
Which approach should you use?
|
| Option A | A SELECT statement that includes CASE
|
| Option B | Cursor
|
| Option C | BULK INSERT
|
| Option D | View
|
| Option E | A user-defined function
|
| Correct Answer | E |
Explanation Explanation: SQL Server user-defined functions are routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value. The return value can either be a single scalar value or a result set.