All Topics Flashcards
(266 cards)
What is Azure SQL Database Auto-Tune?
Automatic tuning is a fully managed intelligent performance service that uses built-in intelligence to continuously monitor queries executed on a database and automatically improve their performance. This is achieved through dynamically adapting a database to changing workloads and applying tuning recommendations. Automatic tuning learns horizontally from all databases on Azure through AI, and dynamically improves its tuning actions. The longer a database runs with automatic tuning on, the better it performs.
https://learn.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview?view=azuresql
What can Azure SQL Database Auto-Tune do?
- Force the last good execution plan to be used
- Add new indexes
- Remove unused indexes
https://learn.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview?view=azuresql
What is Azure Service Health?
Azure offers a suite of experiences to keep you informed about the health of your cloud resources. This information includes current and upcoming issues such as service impacting events, planned maintenance, and other changes that may affect your availability.
Azure Service Health is a combination of three separate smaller services.
- Azure status
- Service health
- Resource health
https://learn.microsoft.com/en-us/azure/service-health/overview
How would you debug an application on an Azure Virtual Machine?
You can debug a Visual Studio application that has been deployed on a different computer. To do so, you use the Visual Studio remote debugger.
https://learn.microsoft.com/en-us/visualstudio/debugger/remote-debugging?view=vs-2022
What is Studio Remote Tools?
You can debug a Visual Studio application that has been deployed on a different computer.
https://learn.microsoft.com/en-us/visualstudio/debugger/remote-debugging?view=vs-2022
What is AZCopy?
AzCopy is a command-line tool that moves data into and out of Azure Storage.
The advantage of azcopy is that some of the processes happen on the server side in the cloud. For instance, I could download a file from one container and then upload it to the second but that wouldn’t really be a copy and kind of defeats the purpose.
https://learn.microsoft.com/en-us/azure/storage/common/storage-ref-azcopy
What is Azure Storage Explorer?
Microsoft Azure Storage Explorer is a standalone app that makes it easy to work with Azure Storage data on Windows, macOS, and Linux.
https://learn.microsoft.com/en-us/azure/vs-azure-tools-storage-manage-with-storage-explorer?tabs=windows
What is the maximum number of storage accounts per region with standard endpoints per region per subscription?
250
What is a DNS?
The Domain Name System (DNS) is the phonebook of the Internet. Humans access information online through domain names, like nytimes.com or espn.com. Web browsers interact through Internet Protocol (IP) addresses. DNS translates domain names to IP addresses so browsers can load Internet resources.
What is the maximum number of storage accounts with Azure DNS zone endpoints per region per subscription?
5000
What is the maximum storage compacity in a Storage Account?
5 PiB
What is the maximum number of blob containers, blobs, file shares, tables, queues, entities, or messages per storage account?
No limit
What is the default maximum request per second rate per storage account?
20,000 requests per second
What is Event Hub?
Event Hub – (external events) If events are happening outside of Azure, then you would want to use Event Hub.
What are Storage Queues?
Storage Queues - a message queue - (think storage account containers) it is extremely cheap and reliable, but it is not the same as a Azure Service Bus queue.
What is IoT Hub?
IoT Hub – (external events) “Enable highly secure and reliable communication between your Internet of Things (IoT) application and the devices it manages.”
What is Event Grid?
Event Grid – (internal events) It is a way for different Azure services including your subscription level, your resource groups and other services that fire off events and then be triggered and picked up by other services.
What is Service Bus?
Service Bus is enterprise-grade message queue
What are the three CDN vendors in Azure?
- Verizon
- Akamai
- Microsoft
How does a CDN improve the performance of a website?
By reading the HTML as it serves it, it can prefetch the next set of URLs before the users browser even requests them; and it can apply dynamic compression to images if the browser client is on a slower internet connection or mobile device.
What is the primary function of a CDN?
The primary purpose of a content delivery network (CDN) is to reduce latency, or reduce the delay in communication created by a network’s design. Because of the global and complex nature of the internet, communication traffic between websites (servers) and their users (clients) has to move over large physical distances.
What does an application need to allow Azure Active Directory to be used as its authentication provider?
- Redirect URI
- Application ID
What is Azure Active Directory?
Azure Active Directory (Azure AD), is an enterprise identity service that provides single sign-on, multifactor authentication, and conditional access to guard against 99.9 percent of cybersecurity attacks.
What is Table Storage?
Table Storage is the most cost effective solution for storing data in table format, but does not offer the features and speed of other solutions