http://https://www.lead1pass.com/Microsoft/70-765-practice-exam-dumps.html (190 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 6
You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted domain.
You plan to configure database mirroring.
You need to be able to create database mirroring endpoints on both servers.
What should you do?
A. Configure the SQL Server service account to use Network Service.
B. Use a server certificate.
C. Use a database certificate.
D. Configure the SQL Server service account to use Local System.
Answer: B
Explanation/Reference:
Explanation:
To enable certificate authentication for database mirroring on a given server instance, the system administrator must configure each server instance to use certificates on both outbound and inbound connections.
References: https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/use-certificates-for- a-database-mirroring-endpoint-transact-sql

NEW QUESTION NO: 7
You administer a Microsoft SQL Server 2012 database. You want to make a full backup of the database to a file on disk.
In doing so, you need to output the progress of the backup.
Which backup option should you use?
A. STATS
B. COMPRESSION
C. CHECKSUM
D. IN IT
Answer: A
Explanation/Reference:
Explanation:
STATS is a monitoring option of the BACKUP command.
STATS [ =percentage ]
Displays a message each time another percentage completes, and is used to gauge progress. If percentage is omitted, SQL Server displays a message after each 10 percent is completed.
The STATS option reports the percentage complete as of the threshold for reporting the next interval. This is at approximately the specified percentage; for example, with STATS=10, if the amount completed is 40 percent, the option might display 43 percent. For large backup sets, this is not a problem, because the percentage complete moves very slowly between completed I/O calls.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql

NEW QUESTION NO: 8
You use a contained database named ContosoDb within a domain.
You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.
Which type of user should you create?
A. SQL user without login
B. User mapped to an asymmetric key
C. Domain user
D. login mapped to a virtual account
Answer: C
Explanation/Reference:
Explanation:
If the service must interact with network services, access domain resources like file shares or if it uses linked server connections to other computers running SQL Server, you might use a minimally-privileged domain account. Many server-to-server activities can be performed only with a domain user account.
References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows- service-accounts-and-permissions

NEW QUESTION NO: 9
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 one storage account that has one container. You create multiple VHDs in the container.
Does this meet the goal?
A. Yes
B. No
Answer: B
Explanation/Reference:
Expalantion:
Each Storage Account handles up to 20.000 IOPS, and 500TB of data.
References: https://www.tech-coffee.net/understand-microsoft-azure-storage-for-virtual-machines/

NEW QUESTION NO: 10
You develop a Microsoft SQL Server 2012 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?
A. HOLDLOCK
B. ROWLOCK
C. XLOCK
D. UPDLOCK
E. TABLOCK
Answer: E
Explanation/Reference:
Explanation:
When importing data into a heap by using the INSERT INTO SELECT <columns> FROM statement, you can enable optimized logging and locking for the statement by specifying the TABLOCK hint for the target table.
References: https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table

NEW QUESTION NO: 11
You administer a SQL Server 2012 server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales. UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema.
You need to ensure that the following requirements are met:
The Sales role does not have the Select permission on the Customers schema.

UserA has the Select permission on the Regions table.

Which Transact-SQL statement should you use?
A. REVOKE SELECT ON Schema::Customers FROM UserA
B. DENY SELECT ON Object::Regions FROM UserA
C. EXEC sp_addrolemember 'Sales', 'UserA'
D. DENY SELECT ON Object::Regions FROM Sales
E. REVOKE SELECT ON Object::Regions FROM UserA
F. DENY SELECT ON Schema::Customers FROM Sales
G. DENY SELECT ON Schema::Customers FROM UserA
H. EXEC sp_droprolemember 'Sales', 'UserA'
I. REVOKE SELECT ON Object::Regions FROM Sales
J. REVOKE SELECT ON Schema::Customers FROM Sales
Answer: J
Explanation/Reference:
Explanation:
Use REVOKE to remove the grant or deny of a permission.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/permissions-grant-deny-revoke-azure- sql-data-warehouse-parallel-data-warehouse

NEW QUESTION NO: 12
You have Microsoft SQL Server on a Microsoft Azure virtual machine.
You have two Windows accounts named serviceAccount1 and ServiceAccount2. The SQL Server Agent runs as ServiceAccount1.
You need to run SQL Server Agent job steps by using ServiceAccount2.
Which cmdlet should you run first?
A. Set-ADServiceAccount
B. Set-SqlCredential
C. New-ADServiceAccount
D. New-SqlCredential
Answer: C
Explanation/Reference:
Explanation:
The New-ADServiceAccount command creates a new Active Directory managed service account or group managed service account object.
Incorrect Answers:
A: The Set-ADServiceAccount cmdlet modifies the properties of an Active Directory managed service account (MSA). You can modify commonly used property values by using the cmdlet parameters.
B: The Set-SqlCredential cmdlet sets the Identity and password properties for a SQL Credential object using this cmdlet.
D: The New-SqlCredential cmdlet creates a new SQL Server credential object. A SQL Server credential object is used to store authentication information. The SQL Server credential is required when backing up to or restoring from the Windows Azure storage service, and is used to store the Windows Azure storage account name and access key information.
References: https://docs.microsoft.com/en-us/powershell/module/addsadministration/new- adserviceaccount?view=win10-ps

NEW QUESTION NO: 13
You manage a Microsoft SQL Server environment with several databases.
You need to ensure that queries use statistical data and do not initialize values for local variables.
Solution: you set the value of the MAXDOP parameter to 2.
Does the solution meet the goal?
A. Yes
B. No
Answer: B
Explanation/Reference:
Explanation:
When an instance of SQL Server runs on a computer that has more than one microprocessor or CPU, it detects the best degree of parallelism, that is, the number of processors employed to run a single statement, for each parallel plan execution. You can use the max degree of parallelism (MAXDOP) option to limit the number of processors to use in parallel plan execution.
References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max- degree-of-parallelism-server-configuration-option?view=sql-server-2017

NEW QUESTION NO: 14
You need to create an Elastic Database job to rebuild indexes across 10 Microsoft Azure SQL databases.
Which powershell cmdlet should you run?
A. New-AzureSqlJob
B. New-AzureWebsiteJob
C. New-AzureBatchJob
D. New-ScheduledJobOption
E. New-JobTrigger
Answer: A
Explanation/Reference:
Explanation:
The New-AzureSqlJob cmdlet, in the ElasticDatabaseJobs module, creates a job definition to be used for subsequent job runs.
References: https://docs.microsoft.com/en-us/powershell/module/elasticdatabasejobs/new-azuresqljob?
view=azureelasticdbjobsps-0.8.33

NEW QUESTION NO: 15
You deploy a new Microsoft Azure SQL database instance to support a variety of mobile application and public websites. You configure geo-replication with regions in Brazil and Japan.
You need to implement real-time encryption of the database and all backups.
Solution: You enable Transparent Data Encryption (TDE) on the primary instance.
Does the solution meet the goal?
A. Yes
B. No
Answer: A
Explanation/Reference:
Explanation:
Azure SQL Database and Data Warehouse offer encryption-at-rest by providing Transparent Data Encryption (TDE) for all data written to disk, including databases, log files and backups. This protects data in case of unauthorized access to hardware. TDE provides a TDE Protector that is used to encrypt the Database Encryption Key (DEK), which in turn is used to encrypt the data. With the TDE and Bring Your Own Key (BYOK) offering currently in preview, customers can take control of the TDE Protector in Azure Key Vault.
Taking advantage of TDE with BYOK for databases that are geo-replicated to maintain high availability requires to configure and test the scenario carefully.
References: https://azure.microsoft.com/en-us/blog/how-to-configure-azure-sql-database-geo-dr-with- azure-key-vault/

NEW QUESTION NO: 16
You administer a Microsoft SQL Server 2012 database that includes a table named Application.Events.
Application.Events contains millions of records about user activity in an application.
Records in Application.Events that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts.
You need to be able to modify Application.Events without requiring any changes to the applications that utilize Application.Events.
Which type of solution should you use?
A. Partitioned tables
B. Online index rebuild
C. Change data capture
D. Change tracking
Answer: A
Explanation/Reference:
Explanation:
Partitioning large tables or indexes can have manageability and performance benefits including:
You can perform maintenance operations on one or more partitions more quickly. The operations are more efficient because they target only these data subsets, instead of the whole table.
References: https://docs.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and- indexes