最新的Microsoft Provisioning SQL Databases - 70-765免費考試真題
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 sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are migrating an on-premises Microsoft SQL Server instance to SQL Server on a Microsoft Azure virtual machine. The instance has 30 databased that consume a total of 2 TB of disk space.
The instance sustains more than 30,000 transactions per second.
You need to provision storage for the virtual machine. The storage must be able to support the same load as the on-premises deployment.
Solution: You create 30 storage accounts that each has one container. You create a VHD in each container.
Does this meet the goal?
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are migrating an on-premises Microsoft SQL Server instance to SQL Server on a Microsoft Azure virtual machine. The instance has 30 databased that consume a total of 2 TB of disk space.
The instance sustains more than 30,000 transactions per second.
You need to provision storage for the virtual machine. The storage must be able to support the same load as the on-premises deployment.
Solution: You create 30 storage accounts that each has one container. You create a VHD in each container.
Does this meet the goal?
正確答案: B
說明：（僅 Fast2test 成員可見）
You are a database administrator for a Microsoft SQL Server 2014 database named AdventureWorks2012.
You create an Availability Group defined by the following schema. (Line numbers are included for reference only.)
You need to implement an AlwaysOnAvailablity Group that will meet the following conditions:
Production transactions should be minimally affected. The secondary server should allow reporting queries to be performed. If the primary server goes offline, the secondary server should not automatically take over.
Which Transact-SQL statement should you insert at line 06?
You create an Availability Group defined by the following schema. (Line numbers are included for reference only.)
You need to implement an AlwaysOnAvailablity Group that will meet the following conditions:
Production transactions should be minimally affected. The secondary server should allow reporting queries to be performed. If the primary server goes offline, the secondary server should not automatically take over.
Which Transact-SQL statement should you insert at line 06?
正確答案: B
說明：（僅 Fast2test 成員可見）
You are building the database platform for a multi-tenant application. The application will have one database per tenant and will have at least 30 tenants. Each tenant will have a separate resource group for billing purposes.
The application will require at least 10 GB of clustered columnstore indexes for each database.
You need to implement the database platform for the application. The solution must minimize costs.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
The application will require at least 10 GB of clustered columnstore indexes for each database.
You need to implement the database platform for the application. The solution must minimize costs.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正確答案:
Explanation:
The Standard tier service allows for 1TB of data. Here 30 x 10 GB, 0.3 TB, is required.
You have an on-premises database.
You plan to migrate the database to Microsoft SQL Server on a Microsoft Azure virtual machine.
You move the database files to Azure.
You need to attach the database files to the SQL Server instance on the virtual machine. The solution must ensure that you can run file snapshot backups.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You plan to migrate the database to Microsoft SQL Server on a Microsoft Azure virtual machine.
You move the database files to Azure.
You need to attach the database files to the SQL Server instance on the virtual machine. The solution must ensure that you can run file snapshot backups.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正確答案:
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-sql-server-transact-sql
You plan to create an AlwaysOn availability group that will have two replicas in Microsoft Azure and two onpremises replicas.
You need to ensure that a replica in Azure is always available.
Which cmdlet should you run before you deploy the virtual machines?
You need to ensure that a replica in Azure is always available.
Which cmdlet should you run before you deploy the virtual machines?
正確答案: F
說明：（僅 Fast2test 成員可見）
You plan to enable Stretch Database for a table named Table1.
You need to configure Table1 to move the data to Microsoft Azure. The data must be moved at a later time.
How should you complete the statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You need to configure Table1 to move the data to Microsoft Azure. The data must be moved at a later time.
How should you complete the statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
正確答案:
Explanation:
When you enable Stretch for a table by specifying ON, you also have to specify MIGRATION_STATE = OUTBOUND to begin migrating data immediately, or MIGRATION_STATE = PAUSED to postpone data migration.
Syntax:
<stretch_configuration> ::=
{
SET (
REMOTE_DATA_ARCHIVE
{
= ON ( <table_stretch_options> )
| = OFF_WITHOUT_DATA_RECOVERY ( MIGRATION_STATE = PAUSED )
| ( <table_stretch_options> [, ...n] )
}
)
}
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-2017
You have a database named db1 and an application named App1. App1 queries DB1.
You discover that a non-clustered index in obi is corrupt.
You need to repair the index- App1 must be able to query osi while the index is being repaired.
What should you do?
You discover that a non-clustered index in obi is corrupt.
You need to repair the index- App1 must be able to query osi while the index is being repaired.
What should you do?
正確答案: D
You develop a Microsoft SQL Server 2014 database that contains a heap named OrdersHistorical.
You write the following Transact-SQL query:
INSERT INTO OrdersHistorical
SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement.
Which table hint should you use?
You write the following Transact-SQL query:
INSERT INTO OrdersHistorical
SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement.
Which table hint should you use?
正確答案: B
說明：（僅 Fast2test 成員可見）
Note: This questions 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 manage on-premises and Microsoft Azure SQL Database instances for a company. Your environment must support the Microsoft SQL Server 2012 ODBS driver.
You need to encrypt only specific columns in the database.
What should you implement?
You manage on-premises and Microsoft Azure SQL Database instances for a company. Your environment must support the Microsoft SQL Server 2012 ODBS driver.
You need to encrypt only specific columns in the database.
What should you implement?
正確答案: A
You have an on-premises Microsoft SQL Server instance.
You create a database named DB1.
You need to configure DB1 to support In-Memory OLTP.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE; Each correct selection is worth one point.
You create a database named DB1.
You need to configure DB1 to support In-Memory OLTP.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE; Each correct selection is worth one point.
正確答案: B,D
說明：（僅 Fast2test 成員可見）