AZ-305 FlashCards

1
Q

Azure SQL Managed Instance max DB size

A

2-8 TB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

When to use Azure SQL Serverless Databases

A

Azure SQL Database Serverless used for database with infrequent use. It pauses database when not active

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Benefits of Azure SQL Hyperscale

A

Supports multiple secondary and read only replicas
Scales up to 100 TB
Supports auto replication between primary and secondary replicas
Supports failover between primary and secondary replicas within 15 mins
Supports geo replications with a 15 min RTO

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is Azure Batch

A

Is a cloud service for job scheduling and computes resource management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Azure Monitor Data Collection Endpoint

A

Helps you setup the endpoint to which logs will be sent to. A data collection endpoint is connected to your log analytics workspace in the same region

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Always Encrypted

A

Not even cloud administrators can see the data. The encryption and de-encryption is transparently handled by the client application by using keys managed by the application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

TDE Encryption

A

Will not prevent cloud admins from seeing the data. This encryption works at the page level–this encrypts the entire database. This service does not allow encryption of specific columns like social security numbers for example

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Azure Data Factory

A

Azure Data Factory is a managed cloud service that’s built for hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Azure Entra Enterprise Application

A

This is a service that integrates your on-prem apps with Azure Entra. This provides an identity solution for these on-prem apps.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Azura Entra Application Proxy

(Used to be called Azure AD application proxy)

A

The proxy makes your on-prem web apps accessible to users outside your corp network (off network). A connector is downloaded and installed on a on-prem server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is SQL Edge

A

Is basically used for IOT devices–its basically a scaled down version of SQL for receiving data from IOT devices

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is Azure Bicep

A

Is the more streamlined version of an arm template–you create the template in bicep and then its converted to json template

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

SQL Managed Instance Features

A
  1. Supports user initiated backups
  2. Supports multiple automictically replicated instances across Azure regions
  3. Minimizes admin effort
  4. Also uses auto failover groups
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

User Delegated Shared Access Signature for block blobs

A
  1. Maximize security
  2. Prevents the use of shared access keys
  3. Supports time-limited access to storage accounts storing block blobs
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

You need to maximize security for file shares- limited time access and prevent key sharing

A

Azure AD creds

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Azure Synapse pools to ingest data from Data Lake into hash-distributed tables

A

Azure SQL dedicated pools

17
Q

Azure synapse pools to implement query, and update data in a Data lake

A

Serverless Apache Spark Pool

18
Q

Azure Key Vault solution for storing and accessing API keys with minimum admin effort

A

Secrets

19
Q

Migrate SQL server offline migration with low admin effort

A

Azure database migration services

20
Q

Azure Data Explorer

A

Is a powerful analytics service optimized for analyzing large volumes of data quickly and interactively.

21
Q

Azure Service Principal

A

Provides authentication for both Azure resources and on-prem resources

22
Q

Azure Managed Identity

A

Only provides authentication between Azure resources

23
Q

You need to recommend an authentication solution for Azure Functions. Must minimize admin effort

A

System Assigned Managed identity

24
Q

A company has just setup an Azure subscription and an Azure tenant. They want to use the below features in Azure AD
– Ability to provision and managed group-based access.

Which price tier?

A

Basic- This feature is available with the Basic pricing tier for Azure AD

25
Q

A company has just setup an Azure subscription and an Azure tenant. They want to use the below features in Azure AD

“Allow Self-service password reset for cloud-based users’
What price tier?

A

Basic- the key word is cloud-based users

26
Q

Collect IIS logs from the Windows virtual machines located in Azure and send them across to Azure Storage

A

Azure Diagnostics Agent

27
Q

Collect metrics from the on-premise Windows virtual machines

A

Log Analytics Agent

28
Q

-Collect metrics from the on-premise Linux virtual machines

A

Log Analytics Agent

29
Q

A company is developing an application that will be hosted using the Azure Kubernetes Service. The application modules need to transmit files to a destination location and must make use of an encryption key for the encryption of the files before transmission. Which of the following will be used for managing the storage of the encryption keys?

A

Kubernetes Deployment YAML file

30
Q

A company is developing an application that will consist of different modules. The different modules need to communicate asynchronously with each other. Which of the following is the ideal service to use for this requirement?

A

Azure Queue Storage

31
Q

A company is planning on deploying a stateless based application based on microservices using the Azure Service Fabric service. You need to design the infrastructure that would be required in the Azure Service Fabric service. Which of the following should you consider?

2 answers

A
  1. Number of node types in the cluster
  2. Properties of each node type
32
Q

What does Azure Logic Apps do

A

Cloud platform where you can create and run automated workflows with little to no code.

Azure Logic Apps is more of a workflow-based application.

33
Q

Recommend a solution to copy new info from the data sources to Data Lake by using ETL

A

Azure Data Factory

34
Q

You are designing an Azure resource deployment that will use Azure Resource Manager templates. The deployment will use Azure Key Vault to store secrets.
You need to recommend a solution to meet the following requirements:
Prevent the IT staff that will perform the deployment from retrieving the secrets directly from Key Vault.

Use the principle of least privilege.

Which two actions should you recommend?

A
  1. From Access policies in key vault, enable access to the ARM template deployment
  2. Assign the IT staff custom role that includes the microsoft.keyvaullt.deployaction permission