70-762 Free Practice Test

You have several real-time applications that constantly update data in a database. The applications run more than 400 transactions per second that insert and update new metrics from sensors.
A new web dashboard is released to present the data from the sensors. Engineers report that the applications take longer than expected to commit updates.
You need to change the dashboard queries to improve concurrency and to support reading uncommitted data. What should you do?

1. A. Use the NOLOCK option.
2. B. Execute the DBCC UPDATEUSAGE statement.
3. C. Use the max worker threads Option.
4. D. Use a table-valued parameter.
5. E. Set SET ALLOW SNAPSHOT ISOLATION to ON.
6. F. Set SET XACTJVBORT to ON.
7. G. Execute the alter table ti set (Lock_ESCALATION = auto); statement.
8. H. Use the output parameters.

Correct Answer: C

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some questions sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a 3-TB database. The database server has 64 CPU cores. You plan to migrate the database to Microsoft Azure SQL Database.
You need to select the service tier for the Azure SQL database. The solution must meet or exceed the current processing capacity.
Solution: You select the Premium service tier. Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A
Premium service is required for 3 TB of storage. Single database DTU and storage limits

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers-dtu

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some questions sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a 3-TB database. The database server has 64 CPU cores. You plan to migrate the database to Microsoft Azure SQL Database.
You need to select the service tier for the Azure SQL database. The solution must meet or exceed the current processing capacity.
Solution: You select the Standard service tier. Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: B
Premium service is required for 3 TB of storage. Single database DTU and storage limits

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers-dtu

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. A. Yes
2. B. No

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