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. Determine whether the solution meets stated goals.
Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure virtual machines.
You need to create the templates.
Solution: You use Visual Studio to create a JSON template that defines the deployment and configuration settings for the SQL Server environment.
Does the solution meet the goal?

• A.No
• B.Yes

You install Microsoft SQL Server onto a virtual machine (VM) and then run sysprep.
Corporate policy requires the use of Windows authentication for access to all production SQL Server instances.
You need to prepare the newly deployed SQL Server for use.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

정답:

1 - Rename the VM to the chosen name.
2 - Run the following system stored procedures on the SQL Server instance: sp_DropServer sp_AddServer
3 - Jonin the VM to the domain
Explanation:
Box 1: Rename the VM to the chosen name.
Box 2:
For a renamed computer that hosts a default instance of SQL Server, run the following procedures:
sp_dropserver <old_name>;
GO
sp_addserver <new_name>, local;
GO
Restart the instance of SQL Server.
Note: When you use sysprep to generalize the image, the SID for the machine is deleted and Windows users you created will be deleted as well. If you rely on Windows login to access SQL Server, you won't be able to log in.
Box 3: Join the VM to the domain
Incorrect:
* The Get-Host cmdlet gets an object that represents the program that is hosting PowerShell.
References:
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/rename-a-computer-that-hosts-a-stand-alone-instance-of-sql-server?view=sql-server-2017

You have a database named DB1 that uses simple recovery mode.
Full backups of DB1 are taken daily and DB1 is checked for corruption before each backup.
There was no corruption when the last backup was complete.
You run the sys.columns catalog view and discover corrupt pages.
You need to recover the database. The solution must minimize data loss.
What should you do?

• A.Run RESTORE DATABASE WITH RECOVERY.
• B.Run DBCC CHECKDB and specify the REPAIT_REBUILD parameter.
• C.Run DBCC CHECKDB and specify the REPAIR_ALLOW_DATA_LOSS parameter.
• D.Run RESTORE DATABASE WITH PAGE.

A company plans to use a Microsoft Azure Resource Manager template to deploy a SQL Server in Azure. A partition of the Azure Resource Manager template is displayed.

Use the drop-down menus to select the answer choice that answers each question.
NOTE: Each correct selection is worth one point.

정답:

Explanation:
Box 1: at rest
Transparent Data Encryption (TDE) encrypts SQL Server, Azure SQL Database, and Azure SQL Data Warehouse data files, known as encrypting data at rest.
Box 2: resource group ID
References:
https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-2017

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 use a Microsoft Azure SQL database as a data warehouse. The database is in the Standard service tier and has 400 elastic database throughput units (eDTUs).
You load data to the database by using Azure Data Factory.
You need to reduce the amount of time it takes to load the data.
Solution: You move the database to a Standard elastic pool that has 800 eDTUs.
Does this meet the goal?

• A.No
• B.Yes