Microsoft Provisioning SQL Databases - 70-765 FREE EXAM DUMPS QUESTIONS & ANSWERS
You manage a Microsoft SQL Server environment in a Microsoft Azure virtual machine.
You must enable Always Encrypted for columns in a database.
You need to configure the key store provider.
What should you do?
You must enable Always Encrypted for columns in a database.
You need to configure the key store provider.
What should you do?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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 Premium database pool that has 125 DTUs.
Does the solution meet the goal?
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 Premium database pool that has 125 DTUs.
Does the solution meet the goal?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have an on-premises SQL Server database named DB1 that contains a table named TB1. TB1 is stretched to Microsoft Azure.
A catastrophic hardware failure occurs on the on-premises SQL server.
You deploy a new on-premises server and restore all databases to the new server.
You need to resume Stretch Database operations to Azure.
Which statements should you execute?
A catastrophic hardware failure occurs on the on-premises SQL server.
You deploy a new on-premises server and restore all databases to the new server.
You need to resume Stretch Database operations to Azure.
Which statements should you execute?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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 Premium database that has 125 eDTUs.
Does this meet the goal?
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 Premium database that has 125 eDTUs.
Does this meet the goal?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You administer a Microsoft SQL Server 2014.
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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 need to run a Transact-SQL script against a Microsoft Azure SQL database daily at 01:00.
Solution: You deploy Microsoft SQL Server to an Azure virtual machine, and then you use the SQL Server Agent to schedule a job.
Does this meet the goal?
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 run a Transact-SQL script against a Microsoft Azure SQL database daily at 01:00.
Solution: You deploy Microsoft SQL Server to an Azure virtual machine, and then you use the SQL Server Agent to schedule a job.
Does this meet the goal?
Correct Answer: A
Vote an answer
You plan to deploy Microsoft SQL Server on a Microsoft Azure virtual machine. The virtual machine will have two databases. Each database will reside on a separate VHD and will be between 600 and 800 GB.
Each database will have the I/O requirements shown in the following table.
You are evaluating whether to use the P30 storage disk type.
What is the minimum number of disks required for each database when using P30 storage disk type? (Select two.)
Each database will have the I/O requirements shown in the following table.
You are evaluating whether to use the P30 storage disk type.
What is the minimum number of disks required for each database when using P30 storage disk type? (Select two.)
Correct Answer: E,I
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You administer a SQL Server 2014 database instance.
You need to configure the SQL Server Database Engine service on a failover cluster.
Which user account should you use?
You need to configure the SQL Server Database Engine service on a failover cluster.
Which user account should you use?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You manage a large data warehouse.
You must archive data that is more than two years old. The data must all be accessible without code changes. You create a new volume for the data archive and create a new file group named Archive.
You need to develop a storage that will minimize space utilization and protect data from accidental deletion.
Which four 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.
You must archive data that is more than two years old. The data must all be accessible without code changes. You create a new volume for the data archive and create a new file group named Archive.
You need to develop a storage that will minimize space utilization and protect data from accidental deletion.
Which four 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.
Correct Answer:
Explanation:
Step 1: Create an archive table on the new filegroup
Step 2: Create a partition scheme aligned to primary and archive filegroups Creates a scheme in the current database that maps the partitions of a partitioned table or index to filegroups.
Step 3: Apply partition scheme to tables
Step 4: Compress the archive table
References:
https://www.sqlshack.com/archiving-sql-server-data-using-partitions/
You have an on-premises Microsoft SQL server that has a database named DB1. DB1 contains several tables that are stretched to Microsoft Azure.
A network administrator upgrades the hardware firewalls on the network.
You need to verify whether data migration still runs successfully.
Which stored procedure should you run?
A network administrator upgrades the hardware firewalls on the network.
You need to verify whether data migration still runs successfully.
Which stored procedure should you run?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You administer a Microsoft SQL Server 2014 Enterprise Edition server that uses 64 cores.
You discover performance issues when large amounts of data are written to tables under heavy system load.
You need to limit the number of cores that handle I/O.
What should you configure?
You discover performance issues when large amounts of data are written to tables under heavy system load.
You need to limit the number of cores that handle I/O.
What should you configure?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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 Basic elastic pool that has 1.600 eDTUs.
Does this meet the goal?
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 Basic elastic pool that has 1.600 eDTUs.
Does this meet the goal?
Correct Answer: A
Vote an answer
You have Microsoft SQL Server on a Microsoft Azure virtual machine.
You create a SQL Server Agent job by using the following statement.
You need to send an email message if the job fails.
Which stored procedure should you use?
You create a SQL Server Agent job by using the following statement.
You need to send an email message if the job fails.
Which stored procedure should you use?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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?
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?
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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 deployed a GS-series virtual machine (VM) in Microsoft Azure. You plan to deploy Microsoft SQL Server.
You need to deploy a 30 megabyte (MB) database that requires 100 IOPS to be guaranteed while minimizing costs.
Which storage option should you use?
You have deployed a GS-series virtual machine (VM) in Microsoft Azure. You plan to deploy Microsoft SQL Server.
You need to deploy a 30 megabyte (MB) database that requires 100 IOPS to be guaranteed while minimizing costs.
Which storage option should you use?
Correct Answer: H
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).