Interview Q&A

Answer: Use ADO.NET connection pooling (default in .NET). Ensure DbContext is scoped per request in ASP.NET Core. Example: services.AddDbContext<MyDbContext>(options => options.UseSqlServer(connectionString));

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Enable Transparent Data Encryption (TDE). Configure firewall rules and VNet integration. Use AAD authentication or Managed Identity. Enable Advanced Threat Protection.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Restricts database access to specific IP ranges or VNets. Ensures only authorized clients can connect.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Provisioned throughput: Fixed Request Units (RUs) per second. Serverless: Automatically scales and billed per request. Use serverless for low or intermittent traffic.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

SQL (Core) API MongoDB API Cassandra API Gremlin (Graph) API Table API

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Azure.Cosmos NuGet package (v3+) is preferred. Example: var cosmosClient = new CosmosClient(endpointUri, primaryKey); var container = cosmosClient.GetContainer("DatabaseId", "ContainerId");

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

• Use QueryDefinition and FeedIterator with MaxItemCount.

var query = new QueryDefinition("SELECT * FROM c");
var iterator = container.GetItemQueryIterator<MyItem>(query,
requestOptions: new QueryRequestOptions { MaxItemCount = 10 });

while (iterator.HasMoreResults)

{
foreach (var item in await iterator.ReadNextAsync())
{

Console.WriteLine(item.Id);

}
}

• Cosmos DB supports Strong, Bounded Staleness, Session, Consistent Prefix,

Eventual.

• Set consistency when creating CosmosClient:

var clientOptions = new CosmosClientOptions
{

ConsistencyLevel = ConsistencyLevel.Session

};

var cosmosClient = new CosmosClient(endpointUri, primaryKey,

clientOptions);

Answer: Cosmos DB automatically indexes all properties by default. You can customize index paths for performance. { "indexingMode": "consistent", "includedPaths": [ {"path": "/name/?"}, {"path": "/age/?"} }

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Automatic backups every 4 hours (retention 7–30 days depending on config). Restore using point-in-time restore in Azure Portal or via CLI.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Azure Key Vault is a cloud service for securely storing and managing secrets, keys, and certificates. Helps protect sensitive information like connection strings, passwords, API keys, nd encryption keys.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Secrets: Strings, passwords, API keys, connection strings Keys: Cryptographic keys for encryption/decryption (RSA, EC) Certificates: SSL/TLS or client certificates

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

• Use Azure.Extensions.AspNetCore.Configuration.Secrets package to load

secrets into IConfiguration.

var builder = new ConfigurationBuilder()

.AddAzureKeyVault(new Uri("

new DefaultAzureCredential());

var configuration = builder.Build();
var secretValue = configuration["MySecret"];

Answer: Configure Access Policies in Azure Portal or via Azure CLI. Assign roles: Get → read secrets List → enumerate secrets Set → update secrets Use Managed Identity for apps instead of storing credentials.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Feature Secret Key Certificate Data type Any string Cryptographic key X.509 certificate Use case Passwords, connection strings Encryption, signing SSL/TLS or client auth Managed by Secret store Key store Certificate store

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

• Enable Managed Identity on your App Service or Function App.
• Grant Key Vault access policy to the identity.
• Access secrets without storing credentials:

var client = new SecretClient(new

Uri("

new

DefaultAzureCredential());

KeyVaultSecret secret = client.GetSecret("MySecret");
string value = secret.Value;

Answer: Enable diagnostic logging in Azure Key Vault. Logs include secret reads, updates, deletions, and authentication attempts. Can be sent to Log Analytics, Event Hub, or Storage Account.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Update via Azure Portal, Azure CLI, PowerShell, or SDK. Example using SDK: var client = new SecretClient(new Uri(" new DefaultAzureCredential()); client.SetSecret("MySecret", "NewValue");

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Store connection strings as secrets in Key Vault. Load them in ASP.NET Core via IConfiguration. Avoid storing secrets in appsettings.json or code.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Yes, using in-memory caching or Azure App Configuration with Key Vault integration. Improves performance and reduces frequent Key Vault calls.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Use Managed Identity instead of app credentials. Enable soft-delete and purge protection. Rotate secrets regularly. Restrict access using RBAC or access policies. Enable logging and monitoring for audit purposes.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: An Azure Storage Account is a container for all storage services in Azure. Provides Blob, Queue, Table, and File storage. Offers scalable, durable, and highly available storage.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

Answer: Containers are logical groups of blobs within a storage account. Like folders in a file system. Each blob must belong to one container.

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.

• Use Azure.Storage.Blobs NuGet package.

Upload example:

var blobServiceClient = new BlobServiceClient(connectionString);
var containerClient =

blobServiceClient.GetBlobContainerClient("mycontainer");

var blobClient = containerClient.GetBlobClient("file.txt");
using var fileStream = File.OpenRead("localfile.txt");

wait blobClient.UploadAsync(fileStream, overwrite: true);

Download example:

var downloadPath = "downloaded.txt";

wait blobClient.DownloadToAsync(downloadPath);

Answer: Blob tier determines cost and access latency. Can be set during upload or later: wait blobClient.SetAccessTierAsync(AccessTier.Cool); Hot: Frequently accessed Cool: Infrequent access Archive: Rarely accessed

What interviewers expect

• A clear definition tied to Azure in Microsoft Azure projects
• Trade-offs (performance, maintainability, security, cost)
• When you would and would not use it in production

Real-world example

In a production Microsoft Azure application, teams apply this when handling user-facing features or integration boundaries. For example, you might use it during a sprint where reliability and observability matter—logging metrics, validating edge cases, and documenting the decision in an ADR so future developers understand why the approach was chosen.

How to explain in the interview

1. Define the concept in one or two sentences.
2. Context — where it fits in Microsoft Azure architecture.
3. Example — a specific project, bug, or performance win.
4. Trade-off — what you gain vs what you sacrifice.

Tip: Practice aloud on Toolliyo mock interview or the Interview Q&A section before your real interview.