Storing Data Flashcards
Identity and briefly explain the 3 different data types
Structured Data
* Relational containings sames fields and properties
* Updates can be difficult due to constriaints
Semi-Structured
* Non-relational
* More key values
* NoSQL and data serialization into XML, JSON, YAML
Unstructured Data
* Media Files
* Microsoft 365 files
* Text Files
* Log files
Determine Operational Needs, questions to consider
- Doing simple lookups?
- Query for one or more fields?
- Number of create, update and delete operations
- Queries run complex analytical operations?
- How quickly do these operations need to be processed?
Some examples include Product Catelog, Photos and Videos, and Business Data (All 3 needing have different operational needs)
Identity and briefly explain ACID prinicpals?
- Atomicity => means a transaction must execute once and it must be atomic (all of it completed or none at all)
- Consistency => data is consistent before and after the transaction
- Isolation => ensures each transaction is not affected by other transactions
- Durability => changes made as a result of the trasnaction are permantly saved in the system
What is OLTP?
Online Transaction Processing
High usages and volumes of data, short transactions
What is OLAP?
Online Analytics Processing
Less users, longer response times, large volume of data
Regarding the Product Catalog, Identity the following:
* Data Classification
* Operations
* Latency and Throughput
* Transaction Support
* Recommendation
NOTE: Could have used Azure SQL, however products may not have similar properties
Regarding storage and transaction needs of Photos and Videos, Identity the following:
* Data Classification
* Operations
* Latency and Throughput
* Transaction Support
* Recommendation
Regarding storage and transaction needs of Business Data, what would be the recommendation?
Can use Azure SQL Database but could also consider Azure Analysis Services
What are the considerations when determining the number of storage accounts?
Data Diverisity
* Data specific to country or region?
Costs
* Geo-redunancy more that local redundant
* Premium vs Standard Tier
* Hot access increases costs (access tier)
* You could split storage accounts and put critical data in geo-redundant and less critical use local redundant
Management Overhead
* Requires time to create and maintain
Three things to consider when choosing Account Settings
- Name => 3 - 24 characters and must be unique
- Deployment Model => Resource Manager (recommended) or Classic (Azure Service Manager API)
- Account Kind => Storage V2, Storage V1, and Blob Storage
Identity the various Account Creation Tools
- Azure Portal
- Azure CLI
- Azure PowerShell
- Management Client Libraries
Identity the 4 terms that define Microsoft Azure Storage
- Managed
- Durable => redundant
- Secure
- Scalable
How many Storage Accounts can a subscription have PER REGION
250
What are the 4 types of data supported by Azure Storage
- Blobs
- Fileshares
- Queues
- Table Storage
What are the 3 Blob Types?
- Block Blob
- Page Blob
- Append Blob