Weekend Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Question # 4

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

A.

Azure Storage

B.

Azure Event Hubs

C.

Azure Log Analytics

Full Access
Question # 5

You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements.

What should you do?

A.

Create an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group.

B.

Add a diagnostic setting that logs QueryStoreRuntimeStatistics and streams to an Azure event hub.

C.

Add a diagnostic setting that logs Timeouts and streams to an Azure event hub.

D.

Create an Azure Monitor alert rule that has a dynamic threshold and assign the alert rule to an action group.

Full Access
Question # 6

What should you implement to meet the disaster recovery requirements for the PaaS solution?

A.

Availability Zones

B.

failover groups

C.

Always On availability groups

D.

geo-replication

Full Access
Question # 7

You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements.

What should you create?

A.

a table that has a FOREIGN KEY constraint

B.

a table the has an IDENTITY property

C.

a user-defined SEQUENCE object

D.

a system-versioned temporal table

Full Access
Question # 8

You have a database named db1.

The log for db1 contains the following entry.

You need to ensure That db1 can process transactions.

Full Access
Question # 9

You have an Azure SQL database named DBI that contains a nonclustered index named index1.

End users report slow queries when they use index1.

You need to identify the operations that are being performed on the index.

Which dynamic management view should you use?

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 10

You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements.

Which Azure Storage functionality should you include in the solution?

A.

time-based retention

B.

change feed

C.

lifecycle management

D.

soft delete

Full Access
Question # 11

You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements.

What should you include in the solution? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 12

Task 2

You need to configure your user account as the Azure AD admin for the server named sql3700689S.

Full Access
Question # 13

Task 3

You need to ensure that all queries executed against dbl are captured in the Query Store.

Full Access
Question # 14

Task 10

You need to protect all the databases on sql37006S95 from SQL injection attacks.

Full Access
Question # 15

Task 12

You need to configure high availability for dbl. The solution must tolerate the loss of an Azure datacenter without data loss or the need to modify application connection strings.

Full Access
Question # 16

Task 1

In an Azure SQL database named db1, you need to enable page compression on the PK_SalesOrderHeader_SalesOrderlD clustered index of the SalesLT.SalesOrderHeader table.

Full Access
Question # 17

Task 11

You have a legacy application written for Microsoft SQL Server 2012. The application will be the only application that accesses db1 You need to ensure that db1 is compatible with all the features and syntax of SQL Server 2012.

Full Access
Question # 18

Task 7

You plan to create an automation runbook that will create database users in db1 from Azure AD identities. You need to configure sq1370O6895 to support the creation of new database users.

Full Access
Question # 19

Task 8

You plan to perform performance testing of db1.

You need prevent db1 from reverting to the last known good query plan.

Full Access
Question # 20

Task 9

You need to generate an email alert to admin@contoso.com when CPU percentage utilization for db1 is higher than average.

Full Access
Question # 21

Task 6

You need to ensure that any enhancements made to the Query Optimizer through patches are available to dbl and db2 on sql37006895.

Full Access
Question # 22

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.

Full Access
Question # 23

Task 4

You need to enable change data capture (CDC) for db1.

Full Access
Question # 24

You create all of the tables and views for ResearchDB1.

You need to implement security for ResearchDB1. The solution must meet the security and compliance requirements.

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.

Full Access
Question # 25

You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements.

What should you include in the plan?

A.

Configure the Deleted databases settings for ResearchSrvOL

B.

Deploy and configure an Azure Backup server.

C.

Configure the Advanced Data Security settings for ResearchDBL

D.

Configure the Manage Backups settings for ResearchSrvOL

Full Access
Question # 26

You need to identify the cause of the performance issues on SalesSQLDb1.

Which two dynamic management views should you use? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A.

sys.dm_pdw_nodes_tran_locks

B.

sys.dm_exec_compute_node_errors

C.

sys.dm_exec_requests

D.

sys.dm_cdc_errors

E.

sys.dm_pdw_nodes_os_wait_stats

F.

sys.dm_tran_locks

Full Access
Question # 27

Which windowing function should you use to perform the streaming aggregation of the sales data?

A.

Sliding

B.

Hopping

C.

Session

D.

Tumbling

Full Access
Question # 28

You need to recommend which service and target endpoint to use when migrating the databases from SVR1 to Instance1. The solution must meet the availability requirements.

What should you recommend? To answer, select the appropriate options in the answer area.

NOTE Each correct selection is worth one point.

Full Access
Question # 29

You need to recommend a solution to ensure that the performance of DB3 is optimized after the migration to Azure SQL Database. The solution must meet availability requirements.

What should you include in the recommendation?

A.

Resource Governor

B.

a custom resource pool

C.

vertical scaling

D.

horizontal scaling

Full Access
Question # 30

You plan to deploy Instance1 by using the following script.

You need to specify the licenseType and storagenedundancy parameters. The deployment must meet the availability requirements and the business requirements for DB1 and DB2.

To what should you set each parameter? To answer, select the appropriate options in the answer area.

Full Access
Question # 31

You need to recommend a process to automate the management of DB3. The solution must meet the management requirements. What should be the first step of the process?

A.

Configure Microsoft Entra authentication for the logical server that hosts DB3.

B.

Create a database that has database-scoped credentials.

C.

Configure a private endpoint for connectivity to DB3.

D.

Create data base-scoped credentials in DB3.

Full Access
Question # 32

You need to recommend a solution that will enable remote developers to access DB1 and DB2. The solution must support the planned changes and meet the secunty requirements.

What should you include in the recommendation?

A.

a public endpoint via a database-level firewall rule

B.

a private endpoint

C.

a public endpoint via a server-level firewall rule

D.

a Point-to-Site (P2S) VPN

Full Access
Question # 33

You need to identify the event_file target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements.

What should you use as the event_file target?

A.

an Azure SQL database

B.

an Azure Blob Storage container

C.

a SQL Server filegroup

D.

an Azure Files share

Full Access
Question # 34

You need to recommend which configuration to perform twice to enable access to the primary and secondary replicas of DB3. The solution must meet the availability requirements.

What should you recommend?

A.

Configure virtual network service endpoints.

B.

Enable database firewall rules.

C.

Create database-scoped credentials.

D.

Configure connection strings that reference the read-write listener.

Full Access
Question # 35

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?

A.

Run the sys.5p_cdc_en«ble_db stored procedure.

B.

Run the alter table statement and specify the enable chahgc_tracking clause.

C.

Run the alter database statement and specify the set cmange_trackinc> - on clause.

D.

Run the sp_addarticle stored procedure.

Full Access
Question # 36

You need to recommend a backup solution to restore DB3. The solution must meet the availability requirements. Which type of backup should you use?

A.

transaction log

B.

point-in-time restore (PITR)

C.

differential

D.

long-term retention (LTR)

Full Access
Question # 37

You need to recommend an authentication solution for App1 access to DB1 and DB2 after their migration to Instance1. The solution must meet the availability requirements.

Which actions should you perform in sequence? To answer, drag the appropriate actions to the correct order. Each action 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.

Full Access
Question # 38

Which counter should you monitor for real-time processing to meet the technical requirements?

A.

SU% Utilization

B.

CPU% utilization

C.

Concurrent users

D.

Data Conversion Errors

Full Access
Question # 39

You need to recommend a service tier and a method to offload analytical workloads for the databases migrated from SVR1. The solution must meet the availability and business requirements.

What should you recommend? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 40

You need to identify the event_flle target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements,

What should you use as the event_file target?

A.

an Azure SQL database

B.

an Azure Blob Storage container

C.

a SQL Server filegroup

D.

an Azure Files share

Full Access