2.1: Design a data storage solution for relational data Flashcards
What is the purpose of Azure Table storage?
Azure Table storage is a NoSQL key-value store that is suitable for storing large amounts of structured data. It offers a schema-less design, allowing for flexible data modeling and scalability.
Azure Table storage is commonly used for applications that require high availability, low latency, and massive scalability, such as IoT and web applications.
How can you transfer large amounts of data to Azure Storage?
To transfer large amounts of data to Azure Storage, you can use various methods such as
- Azure Data Box
- Azure Import/Export service
- Azure File Sync
- Azure Data Factory.
These services provide efficient and reliable ways to move data from on-premises or other cloud environments to Azure Storage, ensuring minimal downtime and optimal data transfer speeds.
What is the purpose of Azure Backup?
Azure Backup is a reliable and cost-effective solution for protecting and restoring data in Azure. It allows you to back up data to the cloud from:
- on-premises systems
- virtual machines
- Azure resources
With Azure Backup, you can schedule backups, retain data for longer periods, and easily recover data in case of accidental deletion, data corruption, or system failures
How can you monitor and analyze Azure Storage performance?
You can monitor and analyze Azure Storage performance using Azure Monitor.
Azure Monitor provides insights into the performance and health of your storage accounts, allowing you to identify bottlenecks, optimize resource utilization, and troubleshoot issues. It offers various monitoring capabilities, including:
- metrics
- logs
- alerts
- diagnostic settings
….which can be used to gain visibility into storage account activity and performance patterns.
What is the purpose of Soft Delete in Azure storage?
Soft Delete is a feature in Azure storage that helps protect against accidental data deletion or modification.
When Soft Delete is enabled, deleted data is retained for a specified period of time, allowing you to recover it if needed.
This feature provides an added layer of data protection and helps ensure data integrity, making it useful in scenarios where data retention and recovery are critical.
Which Azure service is designed for petabyte-scale analytics?
Azure Data Lake Analytics is the Azure service designed for petabyte-scale analytics. It enables you to process massive amounts of data in parallel and perform complex analytics using familiar languages such as SQL and .NET.
With Data Lake Analytics, you can gain valuable insights from big data and leverage Azure’s scalability and performance capabilities to handle large-scale analytics workloads.
How can you set up scalability parameters for Azure SQL Managed Instances?
To set up scalability parameters for Azure SQL Managed Instances, you can use the Azure portal or Azure PowerShell.
Through the portal, you can configure the number of vCores, storage size, and backup retention period for your managed instances.
With Azure PowerShell, you can automate and script the configuration process, making it easier to manage and adjust scalability parameters based on your workload requirements.
What are the benefits of using Azure SQL Database?
Azure SQL Database is a fully managed relational database service in Azure that offers several benefits.
It provides automatic patching, backups, and high availability, reducing the administrative burden.
Azure SQL Database also offers built-in intelligence for performance monitoring and tuning, advanced security features, and seamless integration with other Azure services.
With its scalability options, you can easily scale up or down based on your workload needs.
How does Azure Blob storage handle unstructured data?
Azure Blob storage is used to store and retrieve large amounts of unstructured data, such as documents, images, and media files.
It provides a simple and scalable solution for storing objects of any size.
Blob storage offers tiers, including hot, cool, and archive, allowing you to optimize the cost and performance of storing different types of data.
It also provides features like lifecycle management, which automates data movement between tiers based on specified policies.
What is the difference between Azure Files and Azure Blob storage?
Azure Files is a fully managed file share service that provides shared access to files over the Server Message Block (SMB) protocol.
It is suitable for scenarios that require file-level access and shared storage across multiple virtual machines.
Azure Blob storage is designed for storing large amounts of unstructured data as objects and is accessed using a RESTful API.
Blob storage is commonly used for scenarios like data backup, content distribution, and media streaming.
When it comes to providing the fastest read performance and minimizing storage costs, which option should you recommend for Azure Storage Accounts?
a) Azure Files
b) Azure Data Lake Storage Gen2
b) Azure Data Lake Storage Gen2
What is the correct statement regarding tables in an Azure Storage account that use Geo-redundant storage (GRS)?
a) Azure Table Storage offers NoSQL capabilities and provides a high level of compatibility.
b) Azure Table Storage offers SQL capabilities and provides a high level of compatibility.
c) Azure Table Storage offers NoSQL capabilities and provides geo-replication for enhanced data redundancy.
c) Azure Table Storage offers NoSQL capabilities and provides geo-replication for enhanced data redundancy.
What are the options for SQL databases within Azure?
a) Azure SQL Database and Azure SQL Managed Instance
b) Azure SQL Database, Azure SQL Managed Instance, and traditional Microsoft SQL running on a virtual machine
c) Azure SQL Database, Azure SQL Managed Instance, traditional Microsoft SQL, and MySQL
b) Azure SQL Database, Azure SQL Managed Instance, and traditional Microsoft SQL running on a virtual machine
What are the two main types of databases within Azure?
a) Azure Storage and Azure SQL
b) Azure Cosmos DB and Azure SQL
c) Azure Blob Storage and Azure Table Storage
b) Azure Cosmos DB and Azure SQL
What are the key features of Azure Cosmos DB?
a) Fully managed, high performing, and globally distributed database
b) Replication across regions for scalability
c) Support for both SQL and NoSQL databases
a) Fully managed, high performing, and globally distributed database
