Your transactional database requirements exceed the maximum capacity of a single Azure SQL database in the General Purpose service tier.What should you implement to resolve the capacity issue?Select only one answer.elastic poolsread scale-outsharding

You need to migrate an on-premises SQL Server database to Azure. The solution must include support for SQL Server Agent.Which Azure SQL architecture should you recommend?Select only one answer.Azure SQL Database with the Business Critical service tierAzure SQL Database with the General Purpose service tierAzure SQL Database with the Hyperscale service tierAzure SQL Managed Instance with the General Purpose service tier

You plan to implement Azure Files to host a transaction-heavy workload.You need to select the optimal tier for the workload to meet the following requirements:Storage must run on solid-state drives (SSDs).Costs must be minimized.Which tier should you select?Select only one answer.CoolHotPremiumTransaction optimized

Which Azure service provides a scalable cloud database with multi-region, multi-model, and multi-API capabilities?Azure Table StorageAzure Blob StorageAzure SQL DatabaseAzure Cosmos DB

What is the primary benefit of Azure Storage's scalability?Increased securityAbility to handle growing data needsCost-effectivenessIntegration with other Azure services

You've recently taken over support for an Azure Database for PostgreSQL database in your company. You've noticed that the amount of storage required for the database appears to be growing at a rate greater than you would expect. What should you do to investigate? Check the server parameters to ensure autovacuum is switched OFF.Prevent users from adding more data to the database until the problem has been solved.Run a SELECT query to find dead rows that are no longer needed in the database.