ExamGecko
Login
Home / Microsoft / DP-300 / List of questions
Ask Question

Microsoft DP-300 Practice Test - Questions Answers, Page 2

List of questions

Question 11

Report
Export
Collapse

HOTSPOT

You are evaluating the role assignments.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.


Microsoft DP-300 image Question 11 89828 10022024015907000
Correct answer: Microsoft DP-300 image answer Question 11 89828 10022024015907000

Explanation:

Box 1: Yes

DBAGroup1 is member of the Contributor role.

The Contributor role grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC, manage assignments in Azure Blueprints, or share image galleries.

Box 2: No

Box 3: Yes

DBAGroup2 is member of the SQL DB Contributor role.

The SQL DB Contributor role lets you manage SQL databases, but not access to them. Also, you can't manage their security-related policies or their parent SQL servers. As a member of this role you can create and manage SQL databases.

Reference:

https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles

asked 02/10/2024
Paolo D Amelio
36 questions

Question 12

Report
Export
Collapse

You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals. What should you include in the recommendation?

For each customer, grant the customer ddl_admin to the existing schema.
For each customer, grant the customer ddl_admin to the existing schema.
For each customer, create an additional schema and grant the customer ddl_admin to the new schema.
For each customer, create an additional schema and grant the customer ddl_admin to the new schema.
For each customer, create an additional schema and grant the customer db_writer to the new schema.
For each customer, create an additional schema and grant the customer db_writer to the new schema.
For each customer, grant the customer db_writer to the existing schema.
For each customer, grant the customer db_writer to the existing schema.
Suggested answer: B
asked 02/10/2024
Tommy Basnes
39 questions

Question 13

Report
Export
Collapse

You are evaluating the business goals.

Which feature should you use to provide customers with the required level of access based on their service agreement?

dynamic data masking
dynamic data masking
Conditional Access in Azure
Conditional Access in Azure
service principals
service principals
row-level security (RLS)
row-level security (RLS)
Suggested answer: D

Explanation:

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15

asked 02/10/2024
Naveen Nama
37 questions

Question 14

Report
Export
Collapse

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

Business Critical 4-vCore
Business Critical 4-vCore
Hyperscale
Hyperscale
General Purpose v-vCore
General Purpose v-vCore
Serverless
Serverless
Suggested answer: A

Explanation:

There are CPU and Data I/O spikes for the PaaS prototype. Business Critical 4-vCore is needed.

Incorrect Answers:

B: Hyperscale is for large databases

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview

asked 02/10/2024
David Wilson
39 questions

Question 15

Report
Export
Collapse

Which audit log destination should you use to meet the monitoring requirements?

Azure Storage
Azure Storage
Azure Event Hubs
Azure Event Hubs
Azure Log Analytics
Azure Log Analytics
Suggested answer: C

Explanation:

Scenario: Use a single dashboard to review security and audit data for all the PaaS databases.

With dashboards can bring together operational data that is most important to IT across all your Azure resources, including telemetry from Azure Log Analytics. Note: Auditing for Azure SQL Database and Azure Synapse Analytics tracks database events and writes them to an audit log in your Azure storage account, Log Analytics workspace, or Event Hubs.

Reference:

https://docs.microsoft.com/en-us/azure/azure-monitor/visualize/tutorial-logs-dashboards

asked 02/10/2024
Kinzonji Tavares
42 questions

Question 16

Report
Export
Collapse

A data engineer creates a table to store employee information for a new application. All employee names are in the US English alphabet. All addresses are locations in the United States. The data engineer uses the following statement to create the table.

Microsoft DP-300 image Question 1 89899 10022024015907000000

You need to recommend changes to the data types to reduce storage and improve performance.

Which two actions should you recommend? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Change Salary to the money data type.
Change Salary to the money data type.
Change PhoneNumber to the float data type.
Change PhoneNumber to the float data type.
Change LastHireDate to the datetime2(7) data type.
Change LastHireDate to the datetime2(7) data type.
Change PhoneNumber to the bigint data type.
Change PhoneNumber to the bigint data type.
Change LastHireDate to the date data type.
Change LastHireDate to the date data type.
Suggested answer: A, E
asked 02/10/2024
AHMED MAHMOUD NASR Hassan
31 questions

Question 17

Report
Export
Collapse

You have an Azure SQL database.

You identify a long running query.

You need to identify which operation in the query is causing the performance issue.

What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?

Live Query Statistics
Live Query Statistics
an estimated execution plan
an estimated execution plan
an actual execution plan
an actual execution plan
Client Statistics
Client Statistics
Suggested answer: A

Explanation:

https://www.mssqltips.com/sqlservertip/3685/live-query-statistics-in-sql-server-2016/

asked 02/10/2024
Rajiv Ranjan
52 questions

Question 18

Report
Export
Collapse

You have a version-8.0 Azure Database for MySQL database.

You need to identify which database queries consume the most resources.

Which tool should you use?

Query Store
Query Store
Metrics
Metrics
Query Performance Insight
Query Performance Insight
Alerts
Alerts
Suggested answer: A

Explanation:

The Query Store feature in Azure Database for MySQL provides a way to track query performance over time. Query Store simplifies performance troubleshooting by helping you quickly find the longest running and most resource-intensive queries. Query Store automatically captures a history of queries and runtime statistics, and it retains them for your review. It separates data by time windows so that you can see database usage patterns. Data for all users, databases, and queries is stored in the mysql schema database in the Azure Database for MySQL instance.

Reference: https://docs.microsoft.com/en-us/azure/mysql/concepts-query-store

asked 02/10/2024
Maija Janite
38 questions

Question 19

Report
Export
Collapse

You have SQL Server on an Azure virtual machine that contains a database named DB1.

You have an application that queries DB1 to generate a sales report.

You need to see the parameter values from the last time the query was executed.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Enable Last_Query_Plan_Stats in the master database
Enable Last_Query_Plan_Stats in the master database
Enable Lightweight_Query_Profiling in DB1
Enable Lightweight_Query_Profiling in DB1
Enable Last_Query_Plan_Stats in DB1
Enable Last_Query_Plan_Stats in DB1
Enable Lightweight_Query_Profiling in the master database
Enable Lightweight_Query_Profiling in the master database
Enable PARAMETER_SNIFFING in DB1
Enable PARAMETER_SNIFFING in DB1
Suggested answer: B, E

Explanation:


asked 02/10/2024
Sana Mehak
26 questions

Question 20

Report
Export
Collapse

You deploy a database to an Azure SQL Database managed instance.

You need to prevent read queries from blocking queries that are trying to write to the database.

Which database option should set?

PARAMETERIZATION to FORCED
PARAMETERIZATION to FORCED
PARAMETERIZATION to SIMPLE
PARAMETERIZATION to SIMPLE
Delayed Durability to Forced
Delayed Durability to Forced
READ_COMMITTED_SNAPSHOT to ON
READ_COMMITTED_SNAPSHOT to ON
Suggested answer: D

Explanation:

In SQL Server, you can also minimize locking contention while protecting transactions from dirty reads of uncommitted data modifications using either:

The READ COMMITTED isolation level with the READ_COMMITTED_SNAPSHOT database option set to ON.

The SNAPSHOT isolation level.

If READ_COMMITTED_SNAPSHOT is set to ON (the default on SQL Azure Database), the Database Engine uses row versioning to present each statement with a transactionally consistent snapshot of the data as it existed at the start of the statement. Locks are not used to protect the data from updates by other transactions.

Incorrect Answers:

A: When the PARAMETERIZATION database option is set to SIMPLE, the SQL Server query optimizer may choose to parameterize the queries. This means that any literal values that are contained in a query are substituted with parameters. This process is referred to as simple parameterization. When SIMPLE parameterization is in effect, you cannot control which queries are parameterized and which queries are not.

B: You can specify that all queries in a database be parameterized by setting the PARAMETERIZATION database option to FORCED. This process is referred to as forced parameterization.

C: Delayed transaction durability is accomplished using asynchronous log writes to disk. Transaction log records are kept in a buffer and written to disk when the buffer fills or a buffer flushing event takes place. Delayed transaction durability reduces both latency and contention within the system.

Some of the cases in which you could benefit from using delayed transaction durability are:

You can tolerate some data loss.

You are experiencing a bottleneck on transaction log writes.

Your workloads have a high contention rate.

Reference:

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql

asked 02/10/2024
Sergio da Costa
35 questions
Total 342 questions
Go to page: of 35
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1. You need to ensure that an automatic email notification is sent once the job completes. What should you include in the solution?
You have an Azure subscription. You create a logical SQL server that hosts four databases Each database will be used by a separate customer. You need to ensure that each customer can access only its own database. The solution must minimize administrative effort Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.
Task 5 You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.
Task 10 You need to protect all the databases on sql37006S95 from SQL injection attacks.
DRAG DROP You have an Azure SQL database that contains a table named Employees. Employees contains a column named Salary. You need to encrypt the Salary column. The solution must prevent database administrators from reading the data in the Salary column and must provide the most secure encryption. 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.
HOTSPOT You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1. You need to protect the contents of Column1 at rest, in transit, and in use. How should you protect the contents of Column1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You are planning disaster recovery for the failover group of an Azure SQL Database managed instance. Your company's SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs. You set the Read/Write failover policy to Automatic. What are two results of the configuration? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information. What should you include in the recommendation?
You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2. You need to migrate the databases hosted on SQL 1 to Azure. The solution must meet the following requirements: The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections. Administrative effort must be minimized. What should you use to host the databases?
You need to recommend a solution to meet the security requirements and the business requirements for DB3. What should you recommend as the first step of the solution?