In relation to contained Azure SQL Database users, which of the following is true?
- They can access all databases in the same Azure subscription.
- They can only access a single database.
- They can access all databases on the same server.
- They can access all databases in the same resource group.
Azure SQL Database is an example of what type of service?
- PaaS
- SaaS
- IaaS
- BpaaS
If you have configured Azure SQL Database Alerts, and you are receiving alerts too frequently, for the same issue, which configuration parameters do you need to review, to reduce the volume of alerts?
- Resource and period
- Metric and threshold
- Metric and condition
- Threshold and period
In relation to Azure SQL Database firewall rules, which of the following is true?
- They are stored in the master database for the server.
- They are configured using T-SQL statements.
- They can be configured in the Azure portal.
- All the options
Which of the following characteristics relate to Azure SQL Database?
- Most administration duties are managed by Azure
- High availability is already built-in
- You control the data and access
- All the options
When migrating an existing on-premises SQL Server database, what type of export file needs to be created when both schema and data need to be exported?
- .schema
- .dacpac
- .bacpac
- .data
You are concerned that someone may try to insert malicious statements into your database. Which type of threat detection event should you enable?
- Monitor entries
- Identity entries
- SQL Injection
- Detect breaches
Templates for Azure Resource Manager deployment are written in which format?
- XML
- T-SQL
- CSV
- JSON
Where is the output of Azure SQL Database Auditing stored?
- In a protected table in a master database
- In the Windows security log
- In a protected table in the user database
- In a log written to Azure storage
In relation to Azure SQL Database export to the storage, which of the following is not true?
- It may be canceled if it takes longer than 20 hours
- All user table data is exported
- It can be written faster to Azure Premium Storage
- The output BACPAC file cannot exceed 200GB
In relation to Azure SQL Database, which of the following is true?
- Additional database files can be added via Transact-SQL statements.
- All databases on a server must be the same database Edition.
- The maximum size of a database is determined by its database Edition.
- Additional database filegroups can be added via Transact-SQL statements.
How is Azure SQL Database Auditing configured?
- T-SQL query to the master database
- Via an Azure portal configuration
- T-SQL query to the msdb database
- T-SQL query to the user database
Which of the following tools can be used to connect to Azure SQL Database?
- SSIS
- SQL-CMD
- SSMS, SQL-CMD, SSIS
- SSMS
Which of the following is a key benefit of using Azure SQL Database compared to using SQL Server on-premises?
- Faster provisioning time
- Virtual network support
- Ability to query using Transact-SQL language
- Support for spatial data types
Which three of the following settings need to be configured for a new Azure SQL Server?
- Server admin login
- Server name
- Location
- All the options
If an Azure SQL Database is not going to be used for a few weeks, which of the following methods could be used to minimize ongoing costs?
- Pause the Azure SQL database
- Pause the Virtual machine
- Stop the Azure SQL database
- None of the options
Which of the following is/are the standard monitoring uses for Dynamic Management Views available in Azure SQL Database?
- Query performance
- Connections
- Query plans
- All the options
Before users can connect from their applications to an Azure SQL server that has just been created, what must you configure?
- Firewall Rule
- IP address of the server
- Network protocol of the server
Active Geo-Replication allows you to configure up to how many readable secondary databases?
- 2
- 3
- 4
- 6
You have enabled database threat detection. Which of the following is not a threat detection type?
- SQL Injection
- Denied Database Connection
- SQL Injection Vulnerability
- Login from new location
Which four of the following detection types are available to Azure SQL Database Threat Detection? Choose the correct option from below list
- SQL Injection
- SQL Injection vulnerability
- Unusual usage pattern
- Login from new location
- All the options
Do we require storage account for Azure Databases?
- Yes
- No
What storage does Azure Sql Database Use?
- Blob Storage
- File Storage
- Table Storage
- Queue Storage
Topics that you should learn in Microsoft Azure Databases Services:
- Learn to provision or deploy Databases in Azure
- Manage Azure Databases using various tools offered by azure and other services.
- Learn import, export or self-service restore
- Monitor Azure Databases through auditing and threat detection
What are the types of solutions for relational data services in Azure?
Microsoft Azure offers two types of solutions for relational data services.
- Azure SQL Database (PaaS)
- Database (IaaS)
What are the Azure Services that Offers Support for Relational data?
Azure provides many services for managing relational data such as:
- Azure SQL data warehouse, a completely managed relational data as a service.
- Azure Data Factory Service, offers extraction, transformation, and loading functionality of data.
- Azure Data Analytics, delivers analysis services based on any combination of unstructured, semi-structured, and structured data.