Online Access Free 070-762 Exam Questions

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?

• A.Yes
• B.No

Note: This question is part of a series of questions that use the same or similar 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 have a Microsoft SQL Server database named DB1 that contains the tables described in the following table:

There are no foreign key relationships between TBL1 and TBL2.
You need to minimize the amount of time required for queries that use data from TBL1 and TBL2 to return data.
What should you do?

• A.Create clustered indexes on TBL1 and TBL2.
• B.Create a nonclustered index on tbl2 only.
• C.Drop existing indexes on TBL1 and then create a clustered columnstore index. Create a nonclustered columnstore index on TBL1. Create noncluster index on TBL2.
• D.Create unique constraints on both TBL1 and TBL2.Create a partitioned view that combines columns from TBL1 and TBL2.
• E.Create a clustered index on TBL1. Create a nonclustered index on TBL2 and add the most frequently queried columns as included columns.
• F.Drop existing indexes on TBL1 and then create a clustered columnstore index. Create a nonclustered columnstore index on TBL1 Make no changes to TBL2.

You have an existing Microsoft SQL Trace script. You plan to convert the script to an Extended Events session.
You need to collect the trace ID and other required information.
Which system table should you use?

• A.sysdbmaintplan.
• B.dbo.syssessions
• C.dbo. syinotifications
• D.trace xenction_map

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 need to collect data from the following two sources:
* The performance counters of the operating system
* Microsoft SQL Server events
You must analyze the two datasets side-by side by using a single tool.
Solution: You use SQL Server Profiler and SQL Server Extended Events to collect performance data. You use SQL Server Profiler to analyze the data.
Does this meet the goal?

• A.Yes
• B.No

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 named DB1 that includes a table named Sales-Orders.
You grant a user named User1 select permissions on the sales schema.
You need to ensure that User1 can select data from the sales .orders table without specifying the schema name in any Transact-SQL statements.
Solution: You create a stored procedure in the sales schema that selects the data from the sales. orders table.
Does the solution meet the goal?

• A.Yes
• B.No