Interview Q&A

Answer: Function keys are authentication tokens used to control access to Azure Functions. Can be function-level or host-level.

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 Azure Functions Core Tools: func start Supports local storage emulator and debugging in Visual Studio.

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: Consumption Plan: Automatically scales out based on trigger events. Premium Plan: Provides pre-warmed instances for faster response and scaling. Dedicated App Service Plan: Manual scaling like a normal App Service. Q&A

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.

• Input bindings: Provide data to the function from external sources (e.g., queue

message, blob content).

• Output bindings: Send data from the function to external destinations (e.g., Cosmos

DB, Storage Queue).

Example:

[FunctionName("QueueToBlobFunction")]

public static void Run(

[QueueTrigger("myqueue")] string queueMessage,

[Blob("output-container/{rand-guid}.txt", FileAccess.Write)] out

string blobContent,

ILogger log)

{

log.LogInformation($"Processing queue message: {queueMessage}");

blobContent = queueMessage; // Write to blob
}

Answer: Yes. A function can have one trigger and multiple input/output bindings. Simplifies reading/writing from multiple sources in a single execution.

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 [BlobTrigger] for input or [Blob] for output.

Example (input blob):

[FunctionName("BlobProcessor")]

public static void Run(

[BlobTrigger("input-container/{name}")] Stream blobStream,

string name,

ILogger log)

{

log.LogInformation($"Processing blob: {name}");

}

Example (output blob):

[Blob("output-container/output.txt", FileAccess.Write)] out string

outputBlob

• Use [CosmosDBTrigger] for input and [CosmosDB] for output.

Example (input Cosmos DB trigger):

[FunctionName("CosmosDBTriggerFunction")]

public static void Run(

[CosmosDBTrigger(

databaseName: "MyDatabase",

collectionName: "MyCollection",

ConnectionStringSetting = "CosmosDBConnection",

LeaseCollectionName = "leases")] IReadOnlyList<Document>

input,

ILogger log)

{
foreach (var doc in input)
{

log.LogInformation($"Document received: {doc.Id}");

}
}

Example (output Cosmos DB binding):

[CosmosDB(

databaseName: "MyDatabase",

collectionName: "MyCollection",

ConnectionStringSetting = "CosmosDBConnection")] out dynamic

outputDoc

outputDoc = new { id = Guid.NewGuid(), Name = "New Item" };

Answer: Remove manual SDK code for connecting to Azure services. Automatically serialize/deserialize data. Focus on business logic instead of plumbing.

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: In Function attributes (C#) like [Blob], [QueueTrigger] Or in function.json for configuration settings: { "type": "queueTrigger", "direction": "in", "name": "myQueueItem", "queueName": "myqueue", "connection": "AzureWebJobsStorage" }

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 secrets in Azure App Service Application Settings or Key Vault. Reference via Connection property in binding: [QueueTrigger("myqueue", Connection = "AzureWebJobsStorage")]

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 binding expressions like {name}, {rand-guid}, or {datetime}. Example (dynamic blob output): [Blob("container/{name}-{datetime}.txt", FileAccess.Write)] out string outputBlob

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.

Feature Azure SQL Cosmos DB

Type Relational NoSQL, multi-model

Schema Fixed Schema-less

Scaling Vertical/Horizontal Horizontal, automatic

Consistenc

CID Multiple consistency levels (Strong, Eventual, etc.)

Use Case OLTP, structured

data

Global apps, unstructured data, IoT

• Use connection string in appsettings.json:

"ConnectionStrings": {

"DefaultConnection":

"Server=tcp:myserver.database.windows.net,1433;Initial
Catalog=MyDb;Persist Security Info=False;User
ID=myuser;Password=mypassword;MultipleActiveResultSets=False;Encrypt
=True;TrustServerCertificate=False;Connection Timeout=30;"
}

• Inject DbContext using Entity Framework Core:

builder.Services.AddDbContext<MyDbContext>(options =>

options.UseSqlServer(builder.Configuration.GetConnectionString("Defa

ultConnection")));

Answer: SQL Authentication: Username and password. Azure Active Directory (AAD) authentication. Managed Identity: Use Azure App Service identity to connect without 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: Use Azure Data Migration Assistant (DMA). Use bacpac import/export. Use SQL Server Management Studio (SSMS) deploy options.

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 ADO.NET connection pooling (default in .NET). Ensure DbContext is scoped per request in ASP.NET Core. Example: services.AddDbContext&lt;MyDbContext&gt;(options =&gt; 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.

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.

• 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: 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: 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.

• 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;