examen martes

You have a data warehouse in Azure Synapse Analytics. You need to ensure that the data in the data warehouse is encrypted at rest. What should you enable?. Transparent Data Encryption (TDE). Advanced Data Security for this database. Always Encrypted for all columns. Secure transfer required.

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?. From SQL Server Configuration Manager (SSMS), enable SQL Server Agent. From SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties. From SQL Server Management Studio (SSMS), create a Database Mail profile. From the Azure portal, create an Azure Monitor action group that has an Email/SMS/Push/Voice action.

You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains a database named DB1. You need to enable Transparent Data Encryption (TDE) for DB1. Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order. Solo el primero. a master key in the master database. a database encryption key in DB1. a certificate in the master database. a database encryption key in the master database.

You have an Azure SQL database named DB1. You need to encrypt DB1. The solution must meet the following requirements: • Encrypt data in motion. • Support comparison operators. • Provide randomized encryption. What should you include in the solution?. Always Encrypted with secure enclaves. Always Encrypted. column-level encryption. Transparent Data Encryption (TDE).

You have SQL Server on Azure virtual machines in an availability group. You have a database named DB1 that is NOT in the availability group. You create a full database backup of DB1. You need to add DB1 to the availability group. Which restore option should you use on the secondary replica?. Restore with Recovery. Restore with Norecovery. Restore with Standby.

You have an Azure subscription. You need to deploy a logical SQL server by using an Azure Resource Manager (ARM) template. The solution must ensure that the server will allow inbound connectivity from any Azure resource. How should you complete the template? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. "0.0.0.0". "*". Ninguna de las anteriores. "255.255.255.255".

You have a Microsoft SQL Server 2017 server that hosts five databases. You Plan to migrate the databases to Azure. You need to recommend a solution that meets the following requirements: • Automatically scales compute based on the workload demand • Provides per-second billing What should you include in the recommendation? Azure Services. An Azure SQL Database elastic pool. A single Azure SQL database in the provisioned compute tier. Azure SQL Managed Instance. A single Azure SQL database in the serverless compute tier.

You are developing an application that uses Azure Data Lake Storage Gen 2. You need to recommend a solution to grant permissions to a specific application for a limited time period. What should you include in the recommendation?. role assignments. account keys. shared access signatures (SAS). Azure Active Directory (Azure AD) identities.

You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII. You need to record whenever users query the CustomerPII table. Which two options should you enable? Each correct answer presents part of the solution. Solo la primera. server audit specification. SQL Server audit. database audit specification. a server principal.

Your on-premises network contains a server that hosts a 60-TB database named DB1. The network has a 10-Mbps internet connection. You need to migrate DB1 to Azure. The solution must minimize how long it takes to migrate the database. What should you use?. Azure Migrate. Azure Data Box. Azure Database Migration Service. Data Migration Assistant (DMA).

You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica. You need to initiate a full backup of DB1 on SQL2. Which statement should you run?. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (Differential, STATS=5, COMPRESSION);. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (COPY_ONLY, STATS=5, COMPRESSION);. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (File_Snapshot, STATS=5, COMPRESSION);. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (NoInit, STATS=5, COMPRESSION);.

You plan to deploy an Azure SQL managed instance. You need to restore database backups across regions. Which type of storage account should you use?. locally-redundant storage (LRS). zone-redundant storage (ZRS). geo-zone-redundant storage (GZRS). geo-redundant storage (GRS).

You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1. You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync. You need to recommend a database service for the deployment. The solution must minimize administrative effort. What should you include in the recommendation?. Azure SQL Managed instance. Azure SQL Database single database. Azure Database for PostgreSQL. SQL Server on Azure virtual machines.

You have an Azure subscription. You plan to deploy an instance of SQL Server on Azure Virtual Machines that supports Write Accelerator. Which virtual machine series should you use?. E-series. G-series. H-series. M-series.

You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1. You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements: • Ensure that all traffic to the public endpoint of SqlSrv1 is blocked. • Minimize the possibility of VM1 exfiltrating data stored in SqlDb1. What should you create on VNet1?. a VPN gateway. a service endpoint. a private link. an ExpressRoute gateway.

You are building an Azure virtual machine. You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS. You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB data file. The database requires 10,000 IOPS. You need to configure storage for the virtual machine to support the database. Which three objects should you create in sequence? Solo el primero. a virtual disk that uses the simple layout. a volume. a virtual disk that uses the stripe layout. a storage pool.

You have a Microsoft SQL Server 2017 server that hosts five databases. You Plan to migrate the databases to Azure. You need to recommend a solution that meets the following requirements: • Automatically scales compute based on the workload demand • Provides per-second billing What should you include in the recommendation? Service tier: General Purpose. Basic. Standard. -.

Las respuestas expresan los tres parámetros: Exposed Prefix, Padding String, Exposed Suffix. 0, XXX-XXX, 3. 0, XXXXXX, 4. 0, XXX-XXX, 4. 0, XXX-XXX, 5.

You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to implement a disaster recovery solution that meets the following requirements: • Returns the solution to an operational state within 15 minutes of a failure • Can perform disaster recovery testing in an isolated environment • Minimizes administrative effort What should you include in the solution?. active geo-replication. auto-failover groups. Azure Site Recovery. a failover cluster instance (FCI).

Your company wants to create an Azure SQL Database. The database will contain a table that would have Employee information. There are columns which contain sensitive information. You have to enabled Always Encryption for the data stored in the Employee table. Which of the following could be used to store the encryption keys required for enabling Always Encrypted for the table?. Windows certificate store. Private Encryption keys. Public Encryption keys. Azure Key vault.

You have SQL Server on an Azure virtual machine named SQL1. SQL1 has an agent job to back up all databases. You add a user named dbadmin1 as a SQL Server Agent operator. You need to ensure that dbadmin1 receives an email alert if a job fails. Which three actions should you perform in sequence? Solo la primera de las tres. Create a job. Enable the email settings for the SQL Server Agent. Enable Database Mail. Create a job notification.

You are training a new administrator for your company's Azure data services, which includes database deployed on Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure virtual machines (VMs). You need to identify the fixed roles that are supported by Azure SQL Database only. Which two fixed roles are available with Azure SQL Database only?. sysadmin. loginmanager. dbcreator. db_securityadmin.

You plan to move two 100-GB databases to Azure. You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?. An Azure SQL Database elastic pool. SQL Server on Azure virtual machines. an Azure SQL Database managed instance. Azure SQL databases.

You have an Azure SQL database named DB1. You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment option and pricing tier should you configure?. Azure SQL Database managed instance General Purpose. Azure SQL Database Hyperscale. Azure SQL Database Premium. Azure SQL Database managed instance Business Critical.

You have an Azure subscription. You plan to deploy a new Azure virtual machine that will host a Microsoft SQL Server instance. You need to configure the disks on the virtual machine. The solution must meet the following requirements: • Minimize latency for transaction logs. • Minimize the impact on IO Of the virtual machine. Which type of disk should you use for Transaction logs?. Standard SSD. Ultra Disk. Local. Premium SSD.

You have 10 you suspect are related to the connection nes that have SQL Server installed. You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups. What should you include in the backup strategy?. Automated Backup in the SQL virtual machine settings. Azure Backup. Azure Site Recovery. SQL Server Agent jobs.

You deploy an instance of SQL Server on Azure Virtual Machines: named SQL1 that hosts multiple databases. You configure the full recovery model for all the databases. You perform a full backup of the master database on SQL1. You need to a perform an additional backup of the master database on SQL1. The solution must minimize how long it takes to perform the backup. Which type of backup should you perform?. log. full. differential. tail-log.

You have a Microsoft SQL Server 2017 server. You need to migrate the server to Azure. The solution must meet the following requirements: • Ensure that the latest version of SQL Server is used. • Support the SQL Server Agent service. Minimize administrative effort. What should you use?. SQL Server on Azure Virtual Machines. Azure SQL Database. an Azure SQL Database elastic pool. Azure SQL Managed Instance.

You have an Azure SQL database named DB1. You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment option and pricing tier should you configure?. Azure SQL Database Premium. Azure SQL Database serverless. Azure SQL Database managed instance Business Critical. Azure SQL Database Standard.

You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to implement a disaster recovery solution that meets the following requirements: • Returns the solution to an operational state within 15 minutes of a failure • Can perform disaster recovery testing in an isolated environment • Minimizes administrative effort What should you include in the solution?. active geo-replication. auto-failover groups. Azure Site Recovery. a failover cluster instance (FCI).