[Free] EnsurePass Microsoft 70-762 Real Exam Dumps Questions 51-60

Get Full Version of the Exam
http://www.EnsurePass.com/70-762.html

Question No.51

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.

You have a database that contains a table named Employees. The table stores information about the employees of your company.

You need to implement and enforce the following business rules: Limit the values that are accepted by the Salary column.

Prevent salaries less than $15,000 and greater than $300,000 from being entered. Determine valid values by using logical expressions.

Do not validate data integrity when running DELETE statements.

Solution: You implement cascading referential integrity constraints on the table. Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: A

Explanation:

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

Question No.52

HOTSPOT

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

You have a database named Sales that contains the following database tables: Customer, Order, and Products. The Products table and the Order table are shown in the following diagram.

image

The customer table includes a column that stores the data for the last order that the customer placed.

You plan to create a table named Leads. The Leads table is expected to contain approximately 20,000 records. Storage requirements for the Leads table must be minimized.

You need to create triggers that meet the following requirements: Optimize the performance and data integrity of the tables.

Provide a custom error if a user attempts to create an order for a customer that does not exist. In the Customers table, update the value for the last order placed.

Complete all actions as part of the original transaction.

In the table below, identify the trigger types that meet the requirements.

NOTE: Make only selection in each column. Each correct selection is worth one point.

image

Correct Answer:

image

Question No.53

HOTSPOT

You have a database that contains both disk-based and memory-optimized tables.

You need to create two modules. The modules must meet the requirements described in the following table.

image

Which programming object should you use for each module?

To answer, select the appropriate object types in the answer area.

image

Correct Answer:

image

Question No.54

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.

You have a database that contains a table named Employees. The table stored information about the employees of your company.

You need to implement the following auditing rules for the Employees table:

image

image

Record any changes that are made to the data in the Employees table. Customize the data recorded by the audit operations.

Solution: You implement a check constraint on the Employees table.

Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: B

Explanation:

Check constraints cannot be used to track changes in a table. References: https://msdn.microsoft.com/en-us/library/bb933994.aspx

Question No.55

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

You have a database that contains the following tables: BlogCategory, BlogEntry, ProductReview, Product, and SalesPerson. The tables were created using the following Transact SQL statements:

image

You must modify the ProductReview Table to meet the following requirements:

  1. The table must reference the ProductID column in the Product table

  2. Existing records in the ProductReview table must not be validated with the Product table.

  3. Deleting records in the Product table must not be allowed if records are referenced by the ProductReview table.

  4. Changes to records in the Product table must propagate to the ProductReview table.

You also have the following database tables: Order, ProductTypes, and SalesHistory, The transact-SQL statements for these tables are not available.

You must modify the Orders table to meet the following requirements:

  1. Create new rows in the table without granting INSERT permissions to the table.

  2. Notify the sales person who places an order whether or not the order was completed. You must add the following constraints to the SalesHistory table:

a constraint on the SaleID column that allows the field to be used as a record identifier

a constant that uses the ProductID column to reference the Product column of the ProductTypes table

a constraint on the CategoryID column that allows one row with a null value in the column a constraint that limits the SalePrice column to values greater than four

Finance department users must be able to retrieve data from the SalesHistory table for sales persons where the value of the SalesYTD column is above a certain threshold.

You plan to create a memory-optimized table named SalesOrder. The table must meet the following requirements:

The table must hold 10 million unique sales orders.

The table must use checkpoints to minimize I/O operations and must not use transaction logging. Data loss is acceptable.

Performance for queries against the SalesOrder table that use Where clauses with exact equality operations must be optimized.

You need to modify the design of the Orders table. What should you create?

  1. a stored procedure with the RETURN statement

  2. a FOR UPDATE trigger

  3. an AFTER UPDATE trigger

  4. a user defined function

Correct Answer: D

Explanation:

You must modify the Orders table to meet the following requirements:

  1. Create new rows in the table without granting INSERTpermissions to the table.

  2. Notify the sales person who places an order whether or not the order was completed. References: https://msdn.microsoft.com/en-us/library/ms186755.aspx

Question No.56

Note: This question is part of a series of questions that present the same scenario. Each question in this series contains a unique solution. Determine whether the solution meets the stated goals.

The Account table was created by using the following Transact-SQL statement:

image

There are more than 1 billion records in the Account table. The Account Number column uniquely identifies each account. The ProductCode column has 100 different values. The values are evenly distributed in the table. Table statistics are refreshed and up to date.

You frequently run the following Transact-SQL SELECT statements:

image

You must avoid table scans when you run the queries. You need to create one or more indexes for the table. Solution: You run the following Transact-SQL statement:

CREATE NONCLUSTERED INDEX IX_Account_ProductCode ON Account(ProductCode); Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: A

Explanation:

https://msdn.microsoft.com/en-za/library/ms189280.aspx

Question No.57

Note: This question is part of a series of questions that use the same answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You are developing an application to track customer sales. You create tables to support the application. You need to create a database object that meets the following data entry requirements:

image

What should you create?

  1. extended procedure

  2. CLR procedure

  3. user-defined procedure

  4. DML trigger

  5. DDL trigger

  6. scalar-valued function

  7. table-valued function

Correct Answer: C

Explanation:

https://msdn.microsoft.com/en-us/library/ms345075.aspx

Question No.58

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.

You have a database that contains a table named Employees. The table stores information about the employees of your company.

You need to implement and enforce the following business rules: Limit the values that are accepted by the Salary column.

Prevent salaries less than $15,000 and greater than $300,000 from being entered. Determine valid values by using logical expressions.

Do not validate data integrity when running DELETE statements. Solution: You implement a check constraint on the table.

Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: A

Explanation:

https://en.wikipedia.org/wiki/Check_constraint

Question No.59

You are experiencing performance issues with the database server.

You need to evaluate schema locking issues, plan cache memory pressure points, and backup I/O problems.

What should you create?

  1. a System Monitor report

  2. a sys.dm_tran_database_transaction dynamic management view query

  3. an Extended Events session that uses Query Editor

  4. an Activity Monitor session in Microsoft SQL Management Studio.

Correct Answer: D

Explanation:

https://msdn.microsoft.com/en-us/library/hh212951.aspx

Question No.60

Note: This question is part of a series of questions that present the same scenario. Each question in this series contains a unique solution. Determine whether the solution meets the stated goals.

Your company has employees in different regions around the world.

You need to create a database table that stores the following employee attendance information:

image

Employee ID

image

image

date and time employee checked in to work date and time employee checked out of work

Date and time information must be time zone aware and must not store fractional seconds. Solution: You run the following Transact-SQL statement:

image

Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: A

Explanation:

Datetimeoffset defines a date that is combined with a time of a day that has time zone awareness and is based on a 24-hour clock.

Syntaxis: datetimeoffset [ (fractional seconds precision) ] Forthe usequot;datetimeoffset(0)quot;, the Fractional seconds precision is 0, which is required here.

References: https://msdn.microsoft.com/en-us/library/bb630289.aspx

Get Full Version of the Exam
70-762 Dumps
70-762 VCE and PDF

Leave a Reply

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

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>