- No—an Elastic pool can also be configured for databases that already exist.
- Yes—Azure SQL Database Managed Instances are based on the last stable SQL Server on-premises database engine.
- Yes—failover groups automatically manage the geo-replication relationship between the databases, the failover at scale, and the connectivity.
Chapter 19: Developing Solutions That Use a Relational Database
by Sjoukje Zaal
Microsoft Azure Architect Technologies: Exam Guide AZ-300
- Title Page
- Copyright and Credits
- About Packt
- Contributors
- Preface
- Section 1: Deploying and Configuring Infrastructure
- Analyzing Resource Utilization and Consumption
- Creating and Configuring Storage Accounts
- Technical requirements
- Understanding Azure Storage accounts
- Creating and configuring a storage account
- Installing and using Azure Storage Explorer
- Configuring network access to the storage account
- SAS and access keys
- Implementing Azure Storage replication
- Summary
- Questions
- Further reading
- Implementing and Managing Virtual Machines
- Implementing and Managing Virtual Networking
- Creating Connectivity between Virtual Networks
- Managing Azure Active Directory (Azure AD)
- Implementing and Managing Hybrid Identities
- Section 2: Implementing Workloads and Security
- Migrating Servers to Azure
- Understanding Azure Migrate
- Azure Migrate tools
- Migrating on-premises machines to Azure
- Summary
- Questions
- Further reading
- Configuring Serverless Computing
- Implementing Application Load Balancing
- Integrating On-Premises Networks with Azure Virtual Network
- Managing Role-Based Access Control (RBAC)
- Implementing Multi-Factor Authentication (MFA)
- Section 3: Creating and Deploying Apps
- Creating Web Apps by Using PaaS
- Designing and Developing Apps That Run in Containers
- Section 4: Implementing Authentication and Secure Data
- Implementing Authentication
- Technical requirements
- Understanding Azure App Service authentication
- Implementing Windows-integrated authentication
- Implementing authentication by using certificates
- Understanding OAuth2 authentication in Azure AD
- Understanding managed identities
- Implementing managed identities for Azure resources service principal authentication
- Summary
- Questions
- Further reading
- Implementing Secure Data Solutions
- Technical requirements
- Understanding data security in Azure
- Encrypting and decrypting data at rest
- Encrypting and decrypting data in transit
- Encrypting data with Always Encrypted
- Understanding Azure confidential computing
- Creating, reading, updating, and deleting keys, secrets, and certificates by using the Key Vault API
- Summary
- Questions
- Further reading
- Section 5: Developing for the Cloud and for Azure Storage
- Developing Solutions That Use Cosmos DB Storage
- Developing Solutions That Use a Relational Database
- Technical requirements
- Understanding Azure SQL Database
- Provisioning and configuring an Azure SQL database
- Creating, reading, updating, and deleting data tables by using code
- Configuring elastic pools for Azure SQL Database
- Understanding Azure SQL Database managed instances
- Summary
- Questions
- Further reading
- Message-Based Integration Architecture and Autoscaling
- Mock Questions
- Mock Answers
- Assessments
- Chapter 1: Analyzing Resource Utilization and Consumption
- Chapter 2: Creating and Configuring Storage Accounts
- Chapter 3: Implementing and Managing Virtual Machines
- Chapter 4: Implementing and Managing Virtual Networking
- Chapter 5: Creating Connectivity between Virtual Networks
- Chapter 6: Managing Azure Active Directory (Azure AD)
- Chapter 7: Implementing and Managing Hybrid Identities
- Chapter 8: Migrating Servers to Azure
- Chapter 9: Configuring Serverless Computing
- Chapter 10: Implementing Application Load Balancing
- Chapter 11: Integrating On-Premises Networks with Azure Virtual Networks
- Chapter 12: Managing Role-Based Access Control (RBAC)
- Chapter 13: Implementing Multi-Factor Authentication (MFA)
- Chapter 14: Creating Web Apps by Using PaaS
- Chapter 15: Designing and Developing Apps That Run in Containers
- Chapter 16: Implementing Authentication
- Chapter 17: Implementing Secure Data Solutions
- Chapter 18: Developing Solutions That Use Cosmos DB Storage
- Chapter 19: Developing Solutions That Use a Relational Database
- Chapter 20: Message-Based Integration Architecture and Autoscaling
- Another Book You May Enjoy
Chapter 19: Developing Solutions That Use a Relational Database
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.