MS Knowledge Check Flashcards
Some of the Microsoft knowledge check questions.
How is data in a relational table organized?
Rows and Columns
What is an index?
A structure that enables you to locate rows in a table quickly, using an indexed value
You are building a system that monitors the temperature throughout a set of office blocks, and sets the air conditioning in each room in each block to maintain a pleasant ambient temperature. Your system has to manage the air conditioning in several thousand buildings spread across the country or region, and each building typically contains at least 100 air-conditioned rooms. What type of NoSQL data store is most appropriate for capturing the temperature data to enable it to be processed quickly?
A key-value store.
A key-value store can ingest large volumes of data rapidly. A thermometer in each room can send the data to the database
What is data ingestion?
Capturing raw data streaming from various sources and storing it.
The purpose of data ingestion is to receive raw data and save it as quickly as possible. The data can then be processed and analyzed.
When using an Azure SQL Database managed instance, what is the simplest way to implement backups?
Backups are automatically handled.
A managed instance comes with the benefit of automatic backups and the ability to restore to a point in time.
What is the best way to transfer the data in a PostgreSQL database running on-premises into a database running Azure Database for PostgreSQL service?
Use the Azure Database Migration Services.
The Database Migration Service offers the safest way to push your on-premises PostgreSQL database into Azure.
What are the elements of an Azure Table storage key?
Partition key and row key
The partition key identifies the partition in which a row is located, and the rows in each partition are stored in row key order.
When should you use a block blob, and when should you use a page blob?
Use a page blob for blobs that require random read and write access. Use a block blob for discrete objects that change infrequently.
Why might you use Azure File storage?
To enable users at different sites to share files.
You can create a file share in Azure File storage, upload files to this file share, and grant access to the file share to remote users.
You are building a system that monitors the temperature throughout a set of office blocks, and sets the air conditioning in each room in each block to maintain a pleasant ambient temperature. Your system has to manage the air conditioning in several thousand buildings spread across the country/region, and each building typically contains at least 100 air-conditioned rooms. What type of NoSQL data store is most appropriate for capturing the temperature data to enable it to be processed quickly?
Send the data to an Azure Cosmos DB database and use Azure Functions to process the data.
Cosmos DB can ingest large volumes of data rapidly. A thermometer in each room can send the data to a Cosmos DB database. You can arrange for an Azure Function to run as each item is stored. The function can examine the temperature, and kick off a remote process to configure the air conditioning in the room.
What is provisioning?
The act of running series of tasks that a service provider performs to create and configure a service.
What is a security principal?
An object that represents a user, group, service, or managed identity that is requesting access to Azure resources.
Azure authentication uses security principal to help determine whether a request to access a service should be granted.
What is the common flow of activity in Power BI?
Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile.
A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in Power BI?
An app is a collection of ready-made visuals, pre-arranged in dashboards and reports. You can get apps that connect to many online services from the AppSource.
You have a large amount of data held in files in Azure Data Lake storage. You want to retrieve the data in these files and use it to populate tables held in Azure Synapse Analytics. Which processing option is most appropriate?
Synapse SQL pool. You can use PolyBase from a SQL pool to connect to the files in Azure Data Lake as external tables, and then ingest the data.
