|What do you get when you use Cool access tier for Azure Blob Storage? The fastest way to retrieve files in Azure for high-performance needs A way to archive files that are needed only in emergency, but take a few hours to recover if you need them Less expensive per GB to store the file, and more expensive to access the file The lease expensive way to store files per GB in Azure.
Which of the following is considered a downside to using a non-relational data store compared to a relational database? Non-relational data store does not support different data storage types It's harder to modify the data schema of a non-relational data store Relational data stores are better for extremely high-throughput An non-relational data store does not enforce a consistent data state within the database.
What is the difference between a clustered and unclustered index in SQL Server? A nonclustered index sort and store the data rows based on their key values. Clustered indexes have a structure separate from the data rows. There is no performance cost to inserting data into a table with a clustered index, while inserting data into a table with an nonclustered index is an expensive operation. A clustered index uses a single column as a key, while a nonclustered index uses multiple columns. A clustered index sort and store the data rows based on their key values. Nonclustered indexes have a structure separate from the data rows.
Which of the following techniques is an example of Least Privileged Access? Enable auditing and logging. Have users regularly review their own access using Access Reviews. Have managers reguarly review their employees' access using Access Reviews. Just-In-Time (JIT) access.
Which of the following database models is optimized for the day-to-day operations of a company's business? Data warehousing CSV files OLTP (online transaction processing) OLAP (online analytics processing).
Which of the following is a valid IP address range using the CIDR address method? 110.0.0.* 220.127.116.11-18.104.22.168 22.214.171.124/8 126.96.36.199-255.
You are developing a Power BI report for users to view on their desktop workstations. The report needs to show detailed data, and allow the user to customize the filters and modify the column to sort on. Additionally, users should be able to drill-through the report to other reports if they wish to see the data in another way. What type of Power BI report should you create? PDF Reports Paginated Reports Interactive Reports Dashboard.
You are having trouble connecting to an Azure SQL Database inside Azure from your home. Other clients are able to connect to it successfully. You have the software installed, and are able to connect to other Azure SQL Databases on your subscription. What is the most likely reason you can't connect to this particular SQL Database? You need to grant your Azure AD user read rights to the DB You need to connect through port 1433 You need to add your client IP address to the firewall. You need to give the user specific rights to the individual DB.
You are a Power BI report designer, and in talking with the client, they are looking for a sales report that lists all of the cars sold in the past month. Each row represents one car sold, and each column contains the characteristics of the sale including the make and model, who sold it, the date sold, and the amount it sold for. The client expects there are thousands of rows per month, but they want this report anyways. Which type of report should you create for them in Power BI? A one-page report with thousands of rows Dashboard Paginated Reports Jupyter Notebook.
Name all of the Azure non-relational data stores that store data as key-value pairs. Azure Database for MySQL, Azure Database for PostgreSQL, Azure Database for MariaDB Azure SQL Database, SQL Server in a VM, SQL Managed Instance Cosmos DB Table API, Azure Cache for Redis, Table Storage Cosmos DB.
With a relational data store, when data transaction volumes get too high and database performance suffers, which of the following is a common yet difficult method of distributing those data transactions over multiple servers? SQL Database autoscale Server scale-up Manual sharding SQL Server Stretch DB.
Which of the following metrics affect how much an Azure Redis Cache instance costs? Region, pricing tier, hours Per transaction Region, Consumed storage, pricing tier Region, Pricing tier.
Which of the following data types can be called unstructured data? Azure Table Storage SQL Database table Contents of a Blob storage container JSON data.
Which of the following activities would be considered part of Azure Data Factory's Control Flow? Copy Data If Condition Data Flow MapReduce.
When it comes to data security, what is the principle of least privilege? Users only have the permissions they need to complete their job, and no more. Users access rights should be reviewed regularly, every month or every quarter, to ensure that they still require access to the resources they have access to. Users are only granted permissions for the specific task that they are trying to do, at the moment they are trying to do it. Administrative users should be forced to use MFA when logging in.
Which type of data analytics workload is best for processing data that arrives from an external source once per day? Real-time processing Queue messaging Stream processing Batch processing.
Which of the following methods is commonly used to secure data in transit? Site-to-site VPN Azure Active Directory Hard disk encryption User id and password.
Which of the follwing is a consequnce of having a foreign key relationship between two relational data tables? An INSERT statement will fail if the value of the foreign key column, other than NULL, doesn't exist in the other table. If the user attempts to INSERT data into one table, and the foreign key doesn't exist in the other table, the database will insert a new row for it to maintain intregity. A foreign key on one table always refers to the primary key of another table You can DELETE a row of a data table that has several other rows in other tables dependent on it as a foreign key.
What is one way that you can secure all data coming to and from an Azure Storage Account? Regenerate the Primary Access Key Enable "Secure transfer required" property for the storage account Use Always Encrypted client library Dynamic Data Masking.
What is the minimum number of Request Units per second (RU/s) that you can allocate to a Cosmos DB database or container? 100 RU/s 400 RU/s 1000 RU/s 0 RU/s.
Why would someone choose Azure Table Storage instead of Azure Cosmos DB Table API? Guaranteed single-digit millisecond latency for reads and writes Scalable to any number of regions Complete indexing of on all properties by default Lowest-cost option.
Who's responsibility is "data security" in the Azure Shared Responsibility model? Shared between Azure and the client Entirely Microsoft's responsibility Nobody's responsibility Entirely the client's responsibility.
What method of provisioning a non-relational database involves writing a script, which is a set of commands that you can run from any operating system prompt such as Linux, macOS or Windows? Visual C# ARM templates PowerShell, or CLI Azure Portal.
You have a production application that reads and writes to an Azure SQL Database around 100 times per second. Ocassionally, you get an exception inside your application, "40501 - The service is currently busy." What is the likely cause of this type of error? And what is the mitigation for that? Azure SQL Database has per DTU IOPS limits. Those limits can be increased by opening a support ticket with Azure. Azure SQL Database has per DTU IOPS limits. Increase the DTUs to a higher level, or retry the request after a few seconds delay. Azure SQL Database runs on the same server as other Azure clients, and sometimes their usage will affect yours. Move to an isolated DB instance. Azure SQL Database has IOPS limits. Move the database to a SQL Server in a VM or a Managed SQL Instance.
What type of storage is Azure Table Storage? Column-family storage Document storage Key-value storage Object storage.
When deploying an Azure Storage account, and you choose Zone Redundant Storage (ZRS), how many copies of your data does Azure keep? 3 3 copies in each Availability Zone 6 1.
You have a SQL Database Server named SQLDB, and two SQL Databases named DB1 and DB2. SQLDB has a server-level firewall that allows IP addresses in the range 188.8.131.52-184.108.40.206 and denies all other traffic. DB1 has a database level firewall rule that allows IPs in the range 220.127.116.11-18.104.22.168. When a client using the IP address 22.214.171.124 attempts to access DB1, are they successful? No, the connection will not succeed Yes, the connection will succeed.
What is the concept of NORMALIZATION when it comes to relational databases? The process of eliminating redundancy in data tables by splitting large tables up into several smaller tables, establishing relationships between those tables, and reducing the size of the overall database. Regenerating a table's indexes to increase performance Removing duplicate rows from a table Compressing a data table to it's smallest possible size.
What feature of SQL Database ensures that data can be encrypted end to end, and never in a decrypted state at any time outside the client machine? Always Encrypted Azure Threat Detection Dynamic Data Masking Row-level security
You are trying to determine which type of database to store your Employee data in. First, you need to figure out what kind of data you have. The data comes from an external source, and can be formatted in any way that you need. The thing is, not every entity has value for every property. Some entities have middle names, and for other records, that information doesn't exist. One thing you've discovered is that, at any time, this external data source can add a new never-seen-before field (like a list of awards an employee has won) and you need to store it. What type of data do you have? Unstructured data Comma-separated files (CSV) Structured data Semi-structured data.
The SQL SELECT statement is part of which group of SQL statements? Data Manipulation Language (DML) Data Definition Language (DDL).
What is the advantage of using Transaction Optimized storage for Azure File Storage? It stores files in memory, providing much faster performance than storing to the disk drive It provides the same performance as Premium Storage, for half the price Around 25%-33% of the cost of Hot storage per read-write operation, but twice as expensive per GB for storage. This can save you money for heavily accessed files without using the Premium access tier. It costs the same as Hot storage, but provides better performance for smaller files
You need a non-relational data store that supports key-value storage. This needs to be the most cost-effective way for storing data in Azure as you are expecting a large volume of data that needs to be sorted, processed and cleaned up before being migrated into another long-term data format. Which non-relational data store do you recommend? Azure SQL Database Cosmos DB Azure Table Storage Azure Data Lake Storage Gen2.
What feature of Azure Blob Storage, if enabled, allows you to retrieve files that have previously been deleted within a time period? Immutable blobs Azure Policy Soft Delete Change Feed.
How many databases can you create in a single Cosmos DB account? 1 10 100 Unlimited.
A customer just purchased a service from your company, and a new data row was added to table SALES to indicate this event as soon as it happened. What type of database is this? OLAP OLTP Data Warehousing Cache.
What type of non-relational data revolves around storing and retriving large binary files or blobs, such as images, videos, text files and audio files? Object data Key-value data Document data Graph data.
What type of file system does Azure Data Lake Storage Gen2 use? EXT3 NTFS Hadoop Distributed File System (HDFS) FAT32.
Which Azure data service is best used for moving data from one source to another destination, with the ability to transform the data (process it) along the way? Azure Data Migration Azure Machine Learning Azure SQL Database Azure Data Factory.
You are a developer for ACME organization, and you run a basic SQL SELECT query against the customer database. Some of the fields come back partly hidden, such as this phone number - XXX-XXX-8866. What SQL Database feature is being used to hide the data? Azure Data Encryption Row-level security Dynamic Data Masking Always On Encryption.
You have 10 TB of log files stored in an Azure Data Lake Storage Gen2, and would like to save some money on storage. These files are historical, and you don't expect to be needing to access them any more. Because of company policy, you still need to keep them around for 3 more months in case they are needed. What actions can you take to reduce the cost, in the fewest possible steps? Implement lifecycle management policies on the Azure Data Lake storage to move files to cool or archive storage tier Implement a compression algorithm (like ZIP) to reduce the size of the files Use Azure Data Factory to move the data from high cost Data Lake storage to lower cost standard Blob Storage Set the default access tier on the account to Cool tier.
You have a small 25MB database currently hosted in AWS DynamoDB that you'd like to move to Azure Cosmos DB. You've chosen Core SQL API as the database type. Which is the best database migration tool or technique to get data from AWS DynamoDB to Azure CosmosDB? Data Migration Tool Export the DB using bcp and import into Azure using the same tool Export the DB using a database backup (BACPAC) and create a new SQL DB using that file When creating the SQL Database in the Azure Portal, choose "DynamoDB" as the source of the new database.
Which type of data analytics workload is best for processing time-sensitive data that arrives from an external source every few seconds? Real-time processing Batch processing Event-based messaging Azure Blob Storage.
Every day, car dealers upload their sales and service reports into your web portal. Your web portal stores these files in a Blob Storage container. The data is formatted exactly as your Cosmos DB data needs it. You don't anticipdate needing to modify it before getting it into the database. Which data ingestion model seems to work best for this scenario? ETL ELT.
What type of data does Azure Table Storage store? Graph data Key-value data Unstructured data Relational data.
What type of data is stored in Azure Blob Storage? Key-value data Unstructured data Structured data Partitioned data.
When it comes to data security, what is the Zero Trust model? Require a log-in every session from every user. Users are prompted with Multi-factor Authentication for extra authentication vertification. Allow users to save a cookie so that they do not have to log in again next time. Assume that you have been breached.
By default, what is the security model of Cosmos DB? Azure Active Directory User name and password Security client certificate A valid authorization token.
You have a SQL Database Server named SQLDB, and two SQL Databases named DB1 and DB2. SQLDB has a server-level firewall that allows IP addresses in the range 126.96.36.199-188.8.131.52 and denies all other traffic. DB1 has a database level firewall rule that allows IPs in the range 184.108.40.206-220.127.116.11. When a client using the IP address 18.104.22.168 attempts to access DB1, are they successful? Yes, the connection will succeed No, the connection will not succeed.
What is the cheapest type of storage in Azure per GB stored? Cosmos DB document storage SQL Server Managed Instance Azure Table Storage Azure Redis Cache.
Which of the following can be called semi-structured data? SQL Database table Data stored in XML format A printed invoice Images in a blob storage account.
What types of threats does Advanced Threat Protection protect your SQL Database against? SQL Injection, Potential data infiltration, and brute force attacks Network security threats such as access from unknown IP addresses Long running queries that slow down data performance Queries that update too many rows at once.
Which Azure service is a managed-version of the open-source Apache Spark application, or provides a Spark environment in Azure? Azure HDInsight, Azure Databricks Azure Synapse Analytics, Azure ML Studio Azure Blob Storage, Azure Table Storage SQL Database, SQL Managed Instance.
What type of malicious attack attempts to read database values using form fields on a web site? XSS (Cross Site Scripting) SQL Injection Attack Distributed Denial of Service (DDoS) Attack Brute Force Attack.
What is the impact of allocating too many Request Units per second (RU/s) to a Cosmos DB database or container? The provisioned RU/s doesn't impact anything You will have to pay for the amount allocated regardless of how many are used Cosmos DB will scale the RU/s to what you use, regardless of what you provision Queries will scale in performance to the number of RU/s you have allocated.
Which of the following items best defines "data at rest" when it comes to securing data? Data that has yet to be physically written to the hard disk Data that exists statically on the physical media Data as it exists in a computer's memory Data as it's travelling over a network.
A customer just purchased a service from your company, and a new data row was added to table SALES to indicate this event as soon as it happened. What type of database is this? Data warehouse Analytics database Caching database Transactional database.
What type of cloud service is Cosmos DB? nfrstructure-as-a-Service (IaaS) Platform-as-a-Service (PaaS Software-as-a-Service (SaaS).
Which of the follwing sentences best describes what a TABLE is in SQL Server? Tables are database objects that contain all the data in a database. Tables are collections of key-value pairs. Data can be stored directly into a relational database, and the use of tables are optional. Tables are a collection of views.
In a relational database, can a foreign key reference another column on the same table? Yes No.
Which of the following database models is optimized for deep, complex queries that might take hours to run or tie up the computer from handling other tasks? OLAP (online analytical processing) Data Lake storage Azure Stream Analytics OLTP (online transaction processing).
Which of the following Azure databases is considered Infrastructure as a Service (Iaas)? SQL Server in a VM Cosmos DB SQL Database Managed SQL Instance.
Which of the following sentences best describes what a VIEW is in SQL Server? A VIEW is a virtual table whose contents are defined by a query. A VIEW is a group of one or more Transact-SQL statements. A VIEW is a special type of stored procedure that automatically runs with INSERT, UPDATE or DELETE statements take place. A VIEW is a collection of tables that stores a specific set of structured data.
Which CosmosDB API format works best with key-value data? Table API Cassandra API MongoDB API Gremlin API.
What is the purpose of a data dashboard, particularly in Microsoft Power BI? A dashboard breaks up reports into pages A dashboard is entirely visual elements such as charts and graphs, with no numbers A dashboard shows the detailed data of what happened historically, such as the full log file A dashboard tells a story of what is going on, and contains the most important elements of that story in one page.
When deploying an Azure Storage account, and you choose Geo Redundant Storage (GRS), how many copies of your data does Azure keep? 3 6 2 1.
What type of non-relational data revolves around quickly storing and retrieving a single value per unique item? It is not optimized for queries that requiring examining the contents of the data, such as a WHERE clause in a typical relational query, but is extremely scalable and designed for storing data across multiple nodes on separate machines. Key-value data Graph data Document data Object data.
In an Azure Data Factory, a ___________ is a logical grouping of activities that together perform a task. Fill in the blank. Package Node Pipeline Cluster.
Which of the following methods is commonly used to secure data in transit? Secure Sockets Layer (SSL) or HTTPS Azure Disk Encryption One-way hash function Bitlocker Encryption.
Your company has one SQL Database server that has two SQL Databases on it. You would like to allow connections over the public internet to these databases. Each database has a different set of clients with no overlap. You would like clients of one company to be able to access one database but not the other. How do you configure your firewall to enable this? Server-level IP firewall Network Security Group (NSG) Database-level IP firewall Azure Firewall service.
What type of security does Transparent Data Encryption (TDE) provide? Secure storage of secrets, keys and certificates Data-at-rest encryption End-to-end (E2E) encryption Data-in-transit encryption.
Data Definition Language (DDL) primarily does what? Define data structures Provide ways to create backups and restore from backups. Affect the information stored in the database Determine which users and logins can access data and perform operations.
What do you get when you use Archive access tier for Azure Blob Storage? Slightly less expensive to store the file per GB, and around double the cost to access the file. No coding changes required compared to the Hot tier. The fastest way to retrieve files in Azure for high-performance needs The default level of access, set when you first create the storage account as default. Way less expensive to store the file, and long delay to access the file (perhaps hours).
Which of the following products/services is a suite of business analytics tools that allow analysts to easily create beautiful dashboards and reports on your organizations data? SQL Query Analyzer Power BI Synapse Analytics (formerly SQL Data Warehouse) Azure Analysis Services.
Your company is expecting terabytes of data to come in as non-structured JSON data. You can store it as a key-value pair. There is no requirement for maintaining relationships between the different entities at all, and your main consideration is speed of storing data and price. Which is the best non-relational data store for this scenario that you would recommend? Azure Queue Storage Redis Cache Azure Table Storage Cosmos DB.
Cosmos DB uses a primary key model to give people full control over a Cosmos DB account. How do you limit someone to having only read-only access to your database? Network Security Group (NSG) Encrypt the database Access Key and Endpoint Resource Tokens.
Which of the following are examples of Data Manipulation Language (DML) SQL statements? GRANT, REVOKE CREATE, DROP, ALTER SELECT, INSERT, UPDATE COMMIT, ROLLBACK.
You have a SQL Server running inside your own environment, and you'd like to migrate it into the cloud. You happen to know that the settings on the database has been customized for a business reason. You need to be sure that absolutely NO code will have to change when you move this database - only the connection string. Which is the best way to migrate a SQL Server to Azure to ensure absolutely guaranteed no coding or SQL database schema changes required? Migrate to SQL Server in a VM Migrate to Azure Managed SQL Instance Migrate to Azure Table Storage Migrate to Azure SQL Database.
What is a feature of Power BI Interactive reports? The ability to create customizable online web reports, that are beautiful and can be customized and modified in various complex ways. The ability to create detailed reports that are intended to be printed and shared. The ability to create dashboards that give you a visual look at the status of the business.
Which CosmosDB API format works best with document (JSON) data? Graph API MongoDB API Cassandra API Core SQL.
You've created a Cosmos DB account named Account1. Inside, you create one database named Db1, and one container named Container1. The data you are storing is document data using the Core (SQL) API. You have a new requirement to add a graph database using the Gremlin API. Can you create another database named Db2 inside Account1 for the graph data? No, each account can only contain one type of data Yes, you can use any API to call a Cosmos DB database of any type Yes, each database can use a different API in one account.
Synapse Analytics and Azure Databricks are both Spark-based analytics platforms. What feature does Synapse Analytics offer thatn Databricks currently does not? Ability to perform parallel processing Ability to ingest data from Azure Blob Storage Ability to scale based on business need Based on the SQL Engine, familiar for existing SQL Server environments.
Which of the following scenarios would be a poor environment for an analytical database? Data that has been de-normalized from it's original source Data that has been pre-proceessed into Cubes Data that is stored on a system specifically designed for analytics and is not used for any other purpose Data that is constantly changing.
Through what method can you enable single sign-on for Cosmos DB, so that users can use their corporate user name and password to access the contents of that database? Enable Privileged Identity Management Grant the user access to the Cosmos DB Reader role in RBAC Enable Azure AD Conditional Access Enable Azure AD Authentication.
What do you get when you use Premium access tier for Azure Blob Storage? More expensive per GB to store the file, and way less expensive to access the file with less delay Slightly less expensive to store the file per GB, and around double the cost to access the file. No coding changes required compared to the Hot tier. Way less expensive to store the file, and long delay to access the file (perhaps hours) Extra data redundancy options, with more copies of your files stored in more places.
How do you disable SQL Database encryption at rest so that the data is stored on the hard disk in a readable format? The setting is in the security menu of the Azure Portal for SQL Database. You cannot. TDE is enabled by default and cannot be disabled. It must be disabled on creation of the storage account, not after. Switch to Customer-Managed Keys using Azure Key Vault.
What type of non-relational data revolves around data that is formatted in a readable format (JSON, XML, YAML, etc)? It is sometimes called semi-structured data. It can support queries that require examining the contents of the data, such as a WHERE clause, but as well can support scaling globally for quick reads and writes. Document data Key-value data Object data Graph data.
Which of the following metrics affect how much a Cosmos DB database costs? Number of executions (queries) and storage only Provisioned throughput, number of regions, number of availability zones, consumed storage Based on the tier chosen - Basic, Standard or Premium Provisioned throughput and storage only.
Which Azure service includes an end-to-end machine learning environment inside the context of a data analytics platform? Azure SQL Database Azure Stream Analytics Azure Data Lake Storage Gen2 Azure Databricks.
Which of the following best describes the concept of data warehouse workloads? The data contained in a SQL Data Warehouse The amount of storage required to keep the data in Azure The processing required to run queries against a SQL Data Warehouse The entire process of loading data into the warehouse and all of the data warehouse activities such as analyzing, reporting, managing and exporting data.
By what orchestration method does the Azure Data Factory move data from source, through several transformational steps, into it's final destination? SQL statements Activities Pipelines HDInsight clusters.
Cosmos DB measures its performance in terms of Request Units per second (RU/s). What is a Request Unit? Each read request takes 1 Request Unit Reading, writing, and updating data takes 1 Request Unit each Each read request takes 1 Request Unit per partition The amount of resources roughly required to read one 1KB document with 10 fields. .
Which statement best describes a STORED PROCEDURE in a relational database? Can only be triggered when a data row is inserted, modified or deleted. A group of one or more SQL statements. A virtual table whose contents are defined by a query. Database objects that contain all the data in a database.
Which of the following sentences best describes what an INDEX is in SQL Server? A collection of tables that stores a specific set of structured data. A virtual table whose contents are defined by a query. A structure associated with a table or a view that speeds up retrieval of rows. A special type of stored procedure that automatically runs with INSERT, UPDATE or DELETE statements take place.
Your company has a Azure SQL Database, and each user of that database has their own username and password unique to that database server, known as SQL Server Authentication. Your security team wants to eliminate this, and use the same username and password that users use in the corporate network. What type of security can you enable to allow this single sign-on model? Azure AD Authentication IP-based Firewall Social Media authentication (e.g. Facebook, LinkedIn, Microsoft, etc) Access Control Lists.
Which of the following is a consequence of having a primary key on a relational data table? All the items in a logical partition have the same primary key value. All tables must have one and only one primary key. It is mandatory. The database enforces uniqueness and no other row can have the same primary key. A table can have several primary keys.
What are the three types of activities that Azure Data Factory supports? Copy Data, MapReduce, Stored Procedure Hive, Pig, Spark Data set, Activity, Pipeline Data movement, Data transformation, and Control.
By what method can you limit who has access to your Cosmos DB account from the Internet? IP policy-based access control Regenerate the primary key Azure Firewall Disable public network access to Cosmos DB.
Which of the following types of data is an example of a transactional workload? A database that feeds into PowerBI to provide rich and interactive reports. A database that contains the day-to-day operations of an organization. A database that feeds into machine learning to build and train models. A database that feeds into Azure Analysis Services for complex and processing intensive analytics.
Data Manipulation Language (DML) primarily serves which function? Determine which users and logins can access data and perform operations. Provide ways to create backups and restore from backups. Affect the information stored in the database. Define data structures.
Which of the following is an advantage to using a non-relational database over a relational one? Follows the open-source model Uses indexes to make searches as fast as possible Uses foreign keys to enforce data integrity across the DB Supports different types of data instead of being forced into a row/column model.
When a customer wants to manage their own encryption keys for SQL Database Transparent Data Encryption (TDE), where are those keys stored? Azure Blob Storage account On premises Azure Key Vault Inside the SQL Database.
Which of the following tools allow you to query an Azure SQL Database from a command line? Sqlcmd SQL Server Management Studio Azure Cloud Shell Azure Data Studio.
What is the maximum amount of data that can be stored in a Azure Table Storage database? 5 PB 1 TB Unlimited 100 TB.
Which of the following statements best defines "data in transit" when it comes to securing data? Data while it's being transferred between components, locations or programs such as over a network Data that a user can read, on a computer screen Data that still exists in the source location, and has not yet been sent to the destination location Data that exists statically on the physical media.
Why would someone choose Azure Cosmos DB Table API instead of Azure Table Storage? Programmable using an SDK in almost any programming language It has a 99.99% SLA Single-digit millisecond latency for reads and writes Less expensive option.
Which of the following data types can be called structured data? Excel spreadsheet JSON data Blob files Contents of SQL Database table.
Which of the following methods is commonly used to secure data at rest? Azure Information Protection Azure Disk Encryption HTTPS / SSL Azure Active Directory (Azure AD).
What feature of SQL Database (based on the SQL Server engine) allows you to prevent sensitive fields (such as social security number, phone number, credit card number) from being displayed in a report by partly hiding the value to provide increased data privacy? Dynamic Data Masking Row-level security Always On Encryption Azure Data Encryption.
Which of the following database API formats is not currently supported in CosmosDB? Gremlin MongoDB Cassandra MaxDB .
You have a SQL Server running inside your own environment. As far as you know, it's not used very often and is only used as the backend for an admin application inside your company, and only standard SQL Server features have been used. Your goal is to save money. What SQL database would you recommend migrating the database to inside Azure? Azure SQL Database elastic SQL Managed Instance Azure SQL Database single instance.
You need a storage solution in Azure that supports binary data. Your application will receive multiple GBs per day of images and videos, and needs to store it some place for later access. Each video or image will have a unique key, and that key will be later used to retrieve the correct data. You need a solution that is optimized to store these types of data, can handle the transaction volume easily, can label each image/video by a unique key, and is not expensive. Which non-relational data store do you recommend? Azure Blob Storage Azure SQL Database Cosmos DB Table Storage.
How do you implement the Zero Trust model of security? Require all users to be registered in Azure Active Directory for access. Use Azure's Advanced Threat Protection feature for AI monitoring of activities. Verify each request as though it originated from an uncontrolled network. Add Multi-Factor Authentication using Azure AD Conditional Access.
Which Azure storage solution allows you to mount the storage as a drive in Windows Servers and assign it a drive letter using the SMB protocol Azure Data Lake Azure Table Storage Azure Blob Storage Azure File Storage.
Generally speaking, regardless of which region, which is the lowest cost redundancy option for Blob Storage? GZRS ZRS GRS LRS .
Which CosmosDB API format works best with graph data? Core (SQL) API Cassandra API Table API Gemlin API.
Which type of data analytics workload is best for processing data that is large, complex and takes a significant amount of time to process? Azure Function Web Trigger Batch processing Azure Stream Analytics Real-time processing.
You company has one SQL Database server that has two SQL Databases on it. The databases are both parts of the same application and anyone who can access one database should also be granted access to the other. How do you configure your firewall to enable this? Azure Firewall service Network Security Group Server-level IP firewall Database-level IP firewall.
You have a CosmosDB account named Acct1 and it has two security keys - primary key 1 and 2. You believe primary key 1 was accidentally exposed to the public in a video tutorial. Luckily, nothing bad has happened, but you need to take action. What action should you take? Regenerate key 1 Ensure only applications on the corporate network can access the database through a firewall rule Create a new Cosmos DB account and migrate the data to the new account; deploy the app using the new endpoint and key Switch all apps to Key 2 and rengerate key 1.
Can Azure Data Factory be used to copy data from an external source such as Amazon Redshift? No Yes .
What data structure allows a database server to find data much faster than without it? Indexes Columns Rows Foreign Keys.
Which type of data analytics workload is best for processing data that arrives in a stream, without a start or an end? Batch processing ETL pipeline Real-time processing.
What data structure represents "entities" in a relational database? Tables Indexes Rows Databases.
Which of the following is an advantage of running your SQL database on the PaaS model in Azure? Maximize your control of the hardware settings Keep control of your data inside your own corporate environment Cheapest per-day operational expenditure Cheapest up-front capital expenditure.
Which of the following database features would be best for an analytics workload and not a transactional workload? Semi-structured data, stored in JSON documents A fully-normalized table structure, requiring a lot of JOINs to extract reports Unstructured data, stored as binary files in a Blob storage account Optimized for reading data and not optimized (or even able) to update data.
Which of the following data processing techniques would be best used for handling a file containing millions of rows of data? Batch processing Stream processing.
What feature of Azure Blob Storage would allow recovery of a file that was accidentally deleted? Choose two. Blob versioning Soft delete Change feed Immutable blobs.
Can a SQL Database server have both Server-level IP firewall rules AND Database-level IP firewall rules? Or must you choose one or the other? Any IPs in the database-level firewall must also exist in the server-level firewall You can have both server-level rules and database-level rules No, you must choose one or the other.
What are the four pricing tiers for Azure File Storage? Premium, Transaction Optimized, Hot, Cool Premium, Hot, Cold, Glacier S1, S2, S3, S4 Basic, Standard, Premium, Isolated.
Which type of SQL query language is used to creating and modifying the structure of a database? DML DQL DDL DCL.
Which of the following statements best describes Azure Databricks? A relational database data analytics platform optimized for Azure cloud services A machine learning platform A non-relational data store.
Which of the following terms means "processing data as it arrives"? Templating Streaming Buffering Batching.
Which SQL server query tool offers a modern editor experience, Intellisense, code snippets, source control integration, and an integrated terminal? Azure Portal Data Explorer Microsoft Visual Studio sqlcmd Azure Data Studio.
What method of provisioning a non-relational database would be best for users that only need to do this one time? Bicep scripting PowerShell scripting ARM templates Azure Portal.
Which Azure Storage service is specifically designed to store large quantities of raw and unprocessed data, at very fast speeds? That is, where would a Data Warehouse store it's raw data before being ingested? Azure Queue Storage Azure SQL Database Azure Data Lake Storage Azure Table Storage.
Your company is implementing an Enterprise Data Warehouse, and the first step is to get the data from an external source into Azure. You anticipate there being a lot of data to bring into Azure, and you can't estimate with certainty how much. There could possibly be an Exabyte of data. You need a data storage solution designed for storing a large amount of non-relational data, before using a Data Factory to process the data. What data store is appropriate for the first step? Azure Blob Storage Azure Data Lake Storage Gen2 Azure Synapse Analytics Azure Cosmos DB.
Which of the following is an advantage of batch processing of data? Choose two. You can choose a time when computers are idle, such as overnight Processing data altogether is sometimes more efficient than processing data one at a time One single bad row of data doesn't affect the whole job Data gets processed immediately.
Which data visualization style is a tabular structure? Line chart Treemap Matrix Bar chart.
What is one reason why someone would design a report as a paginated report? It will be consumed entirely online It needs to be a visual summary of the data, including charts and graphs Generating the report will likely go into the 100,000s of pages. It needs to be printed or shared.
Which of the following data processing techniques would be best used for a stock market trading app that relies on real-time changes in the price of a stock? Stream processing Batch processing.
With SQL Server in a Virtual Machine, can you select the specific version of SQL Server you need or does it only run the latest version? You can choose from any number of still-supported SQL Server versions Running SQL Server in the cloud means you have to accept whatever version they are running.
Can you run SQL Server on Linux in Azure? Yes! Azure has SQL Server 2017 and 2019 on Linux No, SQL Server is Windows only.
Which of the following SQL statements is most likely to retrieve all of the columns and rows of the Employees table? SELECT VIEW Employees; SELECT Employees WHERE Location = 'Idaho'; SELECT TABLE Employees; SELECT * FROM Employees;.
Which data loading approach is more suitable for situations that require scaling, and is ideal for large volumes of data? ELT ETL.
Your company has an Azure Function with a public URL. An outside service periodically calls that URL with a binary image as data in the body of the request. You want this Azure Function to take this request, and store the binary image data somewhere in Azure for later retrival. You need an Azure storage service that can store binary data such as images. Which is the best non-relational data store for this scenario that you would recommend? SQL Database Cosmos DB Azure Blob Storage Redis Cache.
Which of the following Azure data services is said to be in the IaaS model? SQL Server running on premises Azure SQL Database SQL Managed Instances SQL Server in a Virtual Machine.
What method of provisioning a non-relational database involves first defining the database in a JSON file, which can then be checked into a code repository for source control, sometimes also referred to as Infrastructure as Code? PowerShell Scripts ARM templates CLI Bash Shell Azure Portal.
Which Azure service allows data analysts, data scientists, machine learning engineers, and data engineers to collaborate together in an interactive workspace? The workspace exists inside an Apache Spark cluster. Azure Databricks Azure SQL Database Azure Synapse Analytics Azure Data Factory.
In what way can ETL help with data privacy and compliance? ETL allows you to run reports on the data before it is ingested ETL cannot help with privacy and compliance ETL is ideal for large volumes of data ETL allows you to filter out sensitive data before it's loaded into the data store.
When deploying an Azure Storage account, and you choose Locally Redundant Storage (LRS), how many copies of your data does Azure keep? 3 6 1 copy in each Availability Zone 1.
What happens if you do not provision enough Request Units per second (RU/s) than your application requires? You will be charged for the excess Request Units The application will not receive any errors but you will see a notification in the Azure portal Requests will be asked to retry later Requests will take longer than expected.
Which of the following metrics affect how much an Azure Table Storage account costs? Consumed storage only Per transaction - reads and writes Region, geo-replication, consumed storage Tier - Standard or Premium.
Which of the following terms means "processing data in groups"? Batching Streaming Buffering Templating.
When data analytics output only answers questions about what happened in the past based on historical data, what category is it? Descriptive Prescriptive Diagnostic Cognitive.
What type of non-relational data revolves around nodes and the relationships between the nodes? This would be a good data type for databases that need to navigate from node to related nodes, like a company organization chart or a social network. MongoDB data Graph data Document data Core (SQL) data.
Does MySQL, PostgreSQL and SQL Database share the exact same SQL syntax? Yes, SQL is a standard and all Azure managed databases use the same version of SQL. No, even though SQL is a standard, each database has it's own version of that standard that is not 100% the same.
Which data visualization style is colored rectangles of varying size? Scatter chart Matrix Pie chart Treemap.
Which of the following columns would make a good ID field for a data table? A timestamp field with the current date and time, down to the second Customer name A sequential number starting from 1 that increments by 1 every time a data row is added to the table.