What is the maximum number of concurrent logins you can have with the Azure SQL database using the Basic pricing tier?
Up to how many online secondary backups are available within a premium pricing tier?
You have exported your SQL database and can't find the exported file. What file extension type should you look for?
You have the Standard service tier. How many days are your backups retained?
You are creating a Firewall Blocked alert for your SQL Server database. You are using the Azure portal and need to specify a time span to monitor the metric data. Which parameter do you configure?
- Period
- draft
- Isometric
- Duration
You are creating an alert for your SQL Server database. Which of the following is not a metric that you would select?
- Memory usage
- Cross connections
- Total GB size
- Format extension
When loading data into Azure SQL Data Warehouse, what is the method that enables parallel reader loading?
- Bulk process
- PolyBase
- Azure data entry
- SQL Server Integration Services
If it takes 15 minutes to load 3 tables into an Azure SQL Data Warehouse that has been provisioned with 100 DWUS, how many DWUS will it take to load those same tables in 3 minutes?
Which three of the following settings need to be configured for a new Azure SQL Server?
- Server admin login
- All the options mentioned
- Location
- Server name
Templates for Azure Resource Manager deployment are written in which format?
Which of the following is/are the standard monitoring uses for Dynamic Management Views available in Azure SQL Database?
- Query plans
- All the options mentioned
- Query performance
- Connections
Which four of the following detection types are available to Azure SQL Database Threat Detection?
- Unusual usage pattern
- SQL Injection vulnerability
- Login from new location
- SQL Injection
- All the options mentioned
You have enabled database threat detection. Which of the following is not a threat detection type?
- Login from system
- SQL project
- Denied Database Connection
- SQL Injection
Before users can connect from their applications to an Azure SQL server that has just been created, what must you configure?
- Firewall Rule
- Network Connector
- Login address
- IP Connector
You are concerned that someone may try to insert malicious statements into your database. Which type of threat detection event should you enable?
- Identity entry
- Detection breaches
- login entries
- SQL Injection
In relation to the Azure SQL database active geo-replication, which of the following is not true?
- Primary databases are available for failover if a data center
- All databases
- All databases need to be in the same data center
- Secondary data
Active Geo-Replication allows you to configure up to how many readable secondary databases?
How is Azure SQL Database Auditing configured?
- T-SQL query
- msdb database
- Via an Azure portal configuration
- user database
Which of the following characteristics relate to Azure SQL Database?
- You control the data and access
- High availability is already built-in
- Most administration duties are managed by Azure
- All the options mentioned
Which of the following services is designed for storage, automatic indexing, and rapid querying of JSON documents that are commonly found in NOSQL applications?
- Azure Blob storage entry
- Azure Document DB
- Azure table storage device
- Azure SQL data warehouse hub
Which of the following is a key benefit of using Azure SQL Database compared to using SQL Server on-premises?
- Support for partial data types
- Transact-SQL language
- Virtual network support system
- Faster provisioning time
Which of the following tools can be used to connect to Azure SQL Database?
- SSMS, SQL-CMD, SSIS
- SQL
- NASCORP
- HTML
Azure SQL Database is an example of what type of service?
In relation to contained Azure SQL Database users, which of the following is true?
- They can access all databases in the box
- They cannot access all databases in the same Azure subscription.
- They can access all databases on the hub.
- They can only access a single database.
What is the default replication schemes for a storage account?
Which of the following is used in grouping a set of blobs?
- Container
- Page
- Block
- Append
Maximum lifetime of message in a Queue is days.
What are client protocols employed in File Share in a mounted Drive?
- SMB 3.0
- All the options mentioned
- REST
- SMB 2.1
Which storage service has limited access through Azure Portal?
- File doc
- Blobs
- Table
- Queue storage
The PartitionKey and RowKey uniquely identify every entity in the table.
What is the combination of two or more disks called?
- Drives pool
- Clusters
- Storage
- Storage Pool
Which data is replicated three times within the primary region, and is also replicated three times in a secondary region hundreds of miles away from the primary region?
What is the size of an SQL Database?
- 10 GB
- 105 TB
- 500 GB
- 50 TB
The backed up secondary copies of databases have only Read-only access.
The shared pool of resources are computed using eDTUs.
Elastic pools scale automatically and provide predictable costs.
What is the full form of DTU?
- All of the options
- Digi Transaction Unit
- Data Total Unit
- Database Transaction Units
Azure CDN supports File Compression for faster transfer of Data.
Apart from the requested user, other users can also access the cached data.
Azure CDN ___to provide maximum throughput for securely delivering content to users.
- Web content
- All the options
- Makes copies
- Caches web content
The cache remains active in edge location for___days by default.
______is needed in the region to backup and recover.
- Vault
- VMs
- Storage device
- Data
Azure Backup offers and type of replication options.
- GRS and RA-GRS
- GRS and ZRS
- LRS and ZRS
- LRS and GRS
A SAS is a URI that grants restricted access rights to Azure Storage resources.
Storage Analytics has a____limit on the amount of stored data that is independent of the total limit for your storage account.
The aggregated logging data is stored in___.
- Blobs
- Exelsheet
- File format
- Queue
The aggregated metrics data is stored in___.
- Exelsheet
- File format
- Queue
- Table
Which is enabled by default while the creation of a storage account?
- All the options
- Storage metrics
- Storage passward
Storage analytics logging is not available for___.
- Queue arrows
- Table formats
- Files
- Blobs shortcut
A storage account can be converted from standard storage to Premium storage and vice versa.
What is the default replication schemes for storage account?
Which component is not suited for backup of VMs and Application data?
- Azure laas VM backup file
- System centre
- Azure Backup
- Azure Backup (MARS) agent
Which of the following is an unsupported workload for Azure backup?
- Disks file
- Read-only volumes
- Files
- System
Which is enabled by default while creating a storage account?
- Storage metrics
- Storage
- All the options
Which disks are registered as SCSI disks?
- None of the options
- OS
- Temporary Disks
- Data Disks
Which data is replicated three times within the primary region, and is also replicated three times in a secondary region hundreds of miles away from the primary region?
During recovery, we can set the location to original or can be changed.
In Azure Backup, which type of Vault is recommended for better protection?
- None of the options
- The backup vault service
- Both the options
- Recovery Services vault
CORS rule in Azure storage is a/an ____file.
- XML
- JSONe
- Text file
- None of the options
Capacity metrics are only available for___storage service.
- Blobs
- Queue
- Table and sheets
- Files format
Azure Backup offers___and____type of replication options.
- GRS and RA-GRS
- LRS and GRS
- LRS and ZRS
- GRS and ZRS
The name of the container should always be in small letters.
Which of the following is used in grouping a set of blobs?
- Pager Blobs
- Block Blob
- Append Blobs
- Container
Resource Manager model is recommended by Azure to create storage because it supports ____.
- Encryptions
- RBAC
- SASe
- Analytics spending
In which of the following models, the independent database Storage and compute can be selected?
- None of the options mentioned
- Vcore based model
- Both the options
- DTU
Storage Analytics has a_____limit on the amount of stored data that is independent of the total limit for your storage account.
If you choose this redundancy, you cannot convert to another redundancy strategy without creating a new storage account and copying the data to the account.
Azure Site recovery performs both Replication and Orchestration for____
- Hyper V workloads
- Regular VM
- All the options
- VMware workloads
Which of the following factor decides the number of data disks that can be attached to a VM?
- All the options
- Image of VM
- Size of VM
- Type of Disks