Microsoft Administering a SQL Database Infrastructure - 070-764 FREE EXAM DUMPS QUESTIONS & ANSWERS

You need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights to view database information and server state for the Manufacturing database on MainDB1.
What should you do?

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 are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance. The environments that you manage are shown in the following table.

You need to configure the Contoso instance.
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.

You deploy a three node Windows Server Failover Clustering (WSFC) cluster. You configure a Microsoft SQL Server instance in failover cluster instance (FCI) mode.
You need to identify the actions that will take place if the motherboard on one server fails and automatic failover occurs.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

You maintain a database named DB1 that has a nonpartitioned table. You create an index in the table.
Automatic statistics updates are disabled.
Users report that some Microsoft SQL Server Reporting Service (SSRS) queries lake a long time to run. You determine that the issue is caused by stale statistics for Index1.
You need to update the statistics for the index.
What should you do?

You are implementing a SQL Server 2016 five-node failover cluster.
You need to choose a quorum configuration.
Which configuration should you use?

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 question 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 data warehouse that stores sales data. One fact table has 100 million rows.
You must reduce storage needs for the data warehouse.
You need to implement a solution that uses column-based storage and provides real-time analytics for the operational workload.
Solution: You remove any clustered indexes and load the table for processing.
Does the solution meet the goal?

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.
A company has offices in Vancouver, Tokyo, and Paris. The company uses Microsoft SQL Server 2016 Standard edition. You must design a reporting solution that uses data from a point of sale (POS) application's transactional database.
After data is entered into the POS system, users must be able to run reports within 24 hours. Latency must be minimized.
You need to implemented a solution that minimizes licensing costs.
What should you implement?

You install a Microsoft SQL Server 2016 instance.
The instance will store data extracted from two databases running on Windows Azure SQL Database.
You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the database.
You need to ensure that the data steward is given the correct client tools to perform these tasks.
Which set of tools should you install?

You work as a Database Administrator (DBA) for a company named ABC.com.
The company uses a Microsoft SQL Server 2012 infrastructure.
A server named ABC-SQL1 hosts multiple databases that are accessed using OLTP (Online Transaction Processing) applications.
You are concerned about the lack of redundancy provided by this single server solution.
You want to configure a solution that ensures high-availability for the databases while minimizing costs.
You need to ensure that the databases remain online in the event of a hardware failure of ABCSQL1.
You configure a second server named ABC-SQL2 and install SQL Server 2012.
Which of the following solutions would provide the high-availability and enable users to run reports on both copies of the databases?

You are the administrator of a Microsoft SQL Server 2016 server. Some applications consume significant resources.
You need to manage the server workload by restricting resource-intensive applications.
You need to dynamically limit resource consumption.
What should you do?