Implement Storage Flashcards
URL/Domain for Blob Storage?
https://[account name].blob.core.windows.net
URL/Domain for Table Storage?
https://[account name].table.core.windows.net
URL/Domain for Queue Storage?
https://[account name].queue.core.windows.net
URL/Domain for File Storage?
https://[account name].file.core.windows.net
What are the 2 types of Blob Storage?
Page and Block
What type of blob is a virtual machine hard disk created as?
Page
What are the 4 storage account replication options?
- Locally redundant (LRS)
- Zone redundant (ZRS)
- Geographically redundant (GRS)
- read-access geographically redundant (RAGRS)
True/False: Zone replicated storage accounts only support block blobs?
True
What is the async blob copy service?
A server side based service that can copy files you specify from a source location to a destination in an Azure Storage account. The source blob can be located in another Azure Storage account, or it can even be outside of Azure as long as the storage service can access the blob directly for it to copy.
Max size of Azure File Shares for SMB?
5TB
When should you leverage the Azure Import and Export service for storage?
When it is either not possible or prohibitively expensive to upload or download the data directly
What is the Azure import and Export Service for storage?
Allows you to ship data into or out of an Azure Storage account by physically shipping disks to an Azure datacenter.
Requirements of the drives for Azure import and export service for storage?
- A 3.5-inch SATA II or III disk
- Disk <= 4TB
- NTFS formatted
What tool is used to prepare the drives for the Azure import and export service for storage?
WAImportExport.exe
When using a CDN, how can you control the expiration of the blob data?
Cache-Control metadata property
Default TTL of a CDN cache in Azure
7 days
What DNS record do you need for a custom domain in Azure for the CDN?
CNAME that points to the blob url and the cdn url
How many Access Keys are available in a storage account?
2
How is a Shared Access Signature (SAS) Key different than a Access Key?
- A Shared Access Signature (SAS) is a URI that grants access to specific containers, blob, queues, and tables and can leverage an expiration date.
- An Access Key has full access permissions to the storage account.
True/False: Captured metrics are stored in the table storage of the Azure Storage account being monitored, with table names that begin with $Metric and Captured logs are stored in blob storage in the $logs container.
True
What are DTU’s in relation to SQL?
Database Throughput Units
True/False: A database must be restored to a new database for a point-in-time restore. (Azure SQL)
True
How do you fail over a SQL database to it’s replica leveraging standard geo-replication?
By clicking the Stop Now button in the management portal on the secondary database. This action stops replication immediately with the primary database and brings the secondary database online as a read/write database
When doing a fail over on a Azure SQL database with standard geo-replication, why should you stop the replication on the secondary database instead of the primary?
Stopping replication on the primary database does not wait for in-flight transactions to complete. There may be data loss.
Which replication strategy is used to load-balance queries across 4 SQL database instances?
Active Geo-Replication
What is a BACPC file used for in in Azure SQL?
Used to import or export data from SQL databases. Use this instead of .bak file
What are the max Point In Time recovery options for Azure SQL?
Basic - 7 days
Standard - 14 days
Premium - 32 days
What are the max database sizes for basic, standard, and premium tiers?
Basic - 2Gb
Standard - 250GB
Premium - 500GB or 4TB (plan dependent)
Size Guidelines for Azure Backup cache?
Cache location should have 10-15 percent of the size of the data to be backed up
