Explore Service Connection types for specific Azure resources and Services

[webtonize]

Story

As a Product Owner I want best practice recommendations for all service connection types. As limited Azure sponsoring is available, I want to eplore all service connection types for Azure related resources so we can build and test these usecases before funding ends.

Acceptance Criteria

• Inventory of best practices with references documented in this issue.
• Follow up issues created for required rules, 1 issue per service connection type.