DP900 Udemy

Which Azure service includes an end-to-end machine learning environment inside the context of a data analytics platform?

Azure Databricks Azure Databricks has several features, and one includes a complete ML platform where you can build, train and test models.

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. Increase the DUTs to a higher level, or retry the request after a few seconds delay. here are IOPS limits tied to the number of DTUs in a database tier. Moving to a higher tier will increase those limits

Can Azure Data Factory be used to copy data from an external source such as Amazon Redshift?

Can Azure Data Factory be used to copy data from an external source such as Amazon Redshift? Yes (Correct) No Explanation Yes, Azure Data Factory supports many different internal and external data sources for it's Copy Data activity, including Redshift. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities

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?

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 (Correct) No, you must choose one or the other Explanation You can have both server- and database-level firewall IP rules, and they exist independently. An IP can exist in a database rule and not a server rule, and the user would have access to the specific database and not all databases on the server. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/azure-sql/database/firewall-configure

Can you run SQL Server on Linux in Azure?

Can you run SQL Server on Linux in Azure? No, SQL Server is Windows only. Yes! Azure has SQL Server 2017 and 2019 on Linux (Correct) Explanation Yes! Azure has SQL Server 2017 and 2019 on Linux

Does MySQL, PostgreSQL and SQL Database share the exact same SQL syntax?

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. (Correct) Explanation SQL Server runs T-SQL, while MySQL

What type of file system does Azure Data Lake Storage Gen2 use?

Hadoop Distributed File System (HDFS) The Azure Data Lake uses a driver compatible with the Hadoop File System (HDFS). It is designed to be highly fault-tolerant, provide high throughput access, and is suitable for applications that have large data sets. It runs on top of the underlying disk file system. FAT32 has serious limitations for large data, and NTFS has certainly improved that with some tradeoffs. HDFS is the correct answer. R

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. Premium storage using SSD (solid-state disks) and is optimized for high transaction rates and single-digit consistent storage latency. It is available in select regions, supports block blob storage only, supports high throughput block blobs, and only supports LRS and ZRS for redundancy.

Which of the following metrics affect how much a Cosmos DB database costs?

Provisioned throughput, number of regions, number of availability zones, consumed storage Cosmos DB is charged based on the following metrics: Provisioned throughput, number of regions, number of availability zones, consumed storage

Cosmos DB measures its performance in terms of Request Units per second (RU/s). What is a Request Unit?

The amount of resources roughly required to read one 1KB document with 10 fields

Which of the following is a consequence of having a primary key on a relational data table?

The database enforces uniqueness and no other row can have the same primary key. A table typically has a column or combination of columns that contain values that uniquely identify each row in the table. This column, or columns, is called the primary key (PK) of the table and enforces the entity integrity of the table. Because primary key constraints guarantee unique data, they are frequently defined on an identity column. They are optional

Which of the following best describes the concept of data warehouse workloads?

The entire process of loading data into the warehouse and all of the data warehouse activities such as analyzing, reporting, managing and exporting data (Correct) The processing required to run queries against a SQL Data Warehouse The data contained in a SQL Data Warehouse The amount of storage required to keep the data in Azure The Data Warehouse workload is all of the efforts to bring data into Azure, and all of the efforts to analyze the data combined

ow many databases can you create in a single Cosmos DB account?

Unlimited There is no limit to the number of databases in a single Cosmos DB account, currently.

What are the four pricing tiers for Azure File Storage?

What are the four pricing tiers for Azure File Storage? Premium, Hot, Cold, Glacier Basic, Standard, Premium, Isolated Premium, Transaction Optimized, Hot, Cool (Correct) S1, S2, S3, S4 Explanation Azure File Storage can support Premium storage on premium disks, or transaction optimized storage, hot and cool options as well. Refer to Microsoft Doc: https://azure.microsoft.com/en-us/pricing/details/storage/files/

What data structure allows a database server to find data much faster than without it?

What data structure allows a database server to find data much faster than without it? Indexes (Correct) Rows Columns Foreign Keys Explanation Indexes allow a database query engine to find data much faster than searching the entire table for the data.

What data structure represents "entities" in a relational database?

What data structure represents "entities" in a relational database? Rows Indexes Databases Tables (Correct) Explanation A table represents a unique entity in the real world - such as a customer, an order, or a product.

Which of the following terms means "processing data as it arrives"?

Which of the following terms means "processing data as it arrives"? Buffering Batching Templating Streaming (Correct) Explanation Streaming data is processed as it arrives.

Which of the following terms means "processing data in groups"?

Which of the following terms means "processing data in groups"? Batching (Correct) Buffering Templating Streaming Explanation Batching data is processed in groups.

Which of the following tools allow you to query an Azure SQL Database from a command line?

sqlcmd Using a tool such as sqlcmd can allow you to run SQL commands from the command line. The others are generally Interactive Development Environments (IDEs) that using a user interface to run SQL queries. And Azure Cloud Shell gives you access to a shell, but you still need to use a command line tool like sqlcmd to run the query.

ou 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?

Dashboard Interactive Reports (Correct) Paginated Reports PDF Reports Interactive reports allow the user to interact with the report (shocking!). They can show detailed data, and optional features such as drill-downs, filters and sorting.

Which of the following activities would be considered part of Azure Data Factory's Control Flow?

Data Flow Control flow activities are the ones that allow looping, if conditions, filtering, and having a pipeline invoke another pipeline.

What are the three types of activities that Azure Data Factory supports?

Data movement, Data Transformation, and control Data movement, Data transformation, and Control are the three types of activities that Azure Data Factory supports. Copy Data is the Data Movement activity, while MapReduce and Stored Procedure are both transformation activities.

Which of the following scenarios would be a poor environment for an analytical database?

Data that is constantly changing You'll generally want to ingest data, do some pre-processing steps on it including possible de-normalization, in order to prepare it for analytics purposes. If the data can change as the analytics is going on, that is a bad environment for that task.

What type of storage is Azure Table Storage?

Azure Table storage is a service that stores non-relational structured data (also known as structured NoSQL data) in the cloud, providing a key/attribute store with a schemaless design. Because Table storage is schemaless, it's easy to adapt your data as the needs of your application evolve. Access to Table storage data is fast and cost-effective for many types of applications, and is typically lower in cost than traditional SQL for similar volumes of data.

In what way can ETL help with data privacy and compliance?

In what way can ETL help with data privacy and compliance? ETL allows you to filter out sensitive data before it's loaded into the data store (Correct) ETL is ideal for large volumes of data ETL allows you to run reports on the data before it is ingested ETL cannot help with privacy and compliance Explanation ETL means that you transform the data before it gets loaded into the data store, which can allow you to filter out sensitive fiels and personally-identifiable information.

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 (Correct) Key-value data is designed for quick storage and retrieval of data based on a key. It's not good for doing searches across multiple keys, or examining the contents of multiple values to find the relevant ones. Refer to Microsoft Doc: https://docs.microsoft.com/en-gb/azure/architecture/data-guide/big-data/non-relational-data

Name all of the Azure non-relational data stores that store data as key-value pairs.

Name all of the Azure non-relational data stores that store data as key-value pairs. Cosmos DB (Incorrect) 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 (Correct) Explanation Key-value pairs are a feature of the Table storage of Cosmos DB, Table storage, and Redis cache. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/non-relational-data

Which of the following data processing techniques would be best used for handling a file containing millions of rows of data?

Which of the following data processing techniques would be best used for handling a file containing millions of rows of data? Stream processing Batch processing (Correct) Explanation Batch processing is better designed to handle large quantities of data efficiently. Stream processing is intended for small batches of data or individual items.

Why would someone choose Azure Cosmos DB Table API instead of Azure Table Storage?

Single-digit millisecond latency for reads and writes Cosmos DB Table API offers single-digit millisecond latency for reads and writes, backed with <10 ms latency for reads and writes at the 99th percentile, at any scale, anywhere in the world. It is not less expensive than table storage. They both offer an SLA, and are both programmable.

What is the primary difference between the Standard tier of Azure File Share, and the Premium tier?

Standard tier uses hard disk-based storage, while Premium tier uses solid-state disks

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?

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? ARM templates (Correct) CLI Bash Shell PowerShell Scripts Azure Portal Explanation ARM templates are a way of defining your infrastructure using declaritive statements, as opposed to scripts. You define what you want your resources to look like, including the properties and values, and Azure will ensure they look that way. Scripts suffer from the problem of not being able to run the same script twice, whereas ARM templates can be deployed again and again without issue. This is sometimes called Desired State Configuration (or DSC). Refer to Microsoft Doc: https://docs.microsoft.com/en-us/learn/modules/explore-provision-deploy-non-relational-data-services-azure/2-describe-provision-non-relational-data-services

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.

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. Document data Graph data (Correct) MongoDB data Core (SQL) data Explanation Graph databases allow you to easily navigate the relationships between the data (edges) and not just the data itself. It was specially designed for things like social networks. Refer to Microsoft Doc: https://docs.microsoft.com/en-gb/azure/architecture/data-guide/big-data/non-relational-data

When data analytics output only answers questions about what happened in the past based on historical data, what category is it?

When data analytics output only answers questions about what happened in the past based on historical data, what category is it? Prescriptive Cognitive Descriptive (Correct) Diagnostic Explanation Descriptive analytics helps answers questions about what has happened, based on historical data.

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?

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 Data Lake Storage (Correct) Azure Table Storage Azure SQL Database Azure Queue Storage Explanation Azure Data Lake Storage is specifically designed to be the initial place data is ingested into Azure, before being further processed and moved into a more organized and structured data storage such as Azure SQL Database or Azure Cosmos DB for further analysis. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/learn/modules/examine-components-of-modern-data-warehouse/3-explore-azure-data-services-warehousing

Which data visualization style is a tabular structure?

Which data visualization style is a tabular structure? Bar chart Line chart Treemap Matrix (Correct) Explanation A matrix visual is a tabular structure that summarizes data.

Which of the following Azure data services is said to be in the IaaS model?

Which of the following Azure data services is said to be in the IaaS model? SQL Managed Instances SQL Server in a Virtual Machine (Correct) Azure SQL Database SQL Server running on premises Explanation SQL Server in a virtual machine is the Infrastructure as a Service Model. This requires you to have the expertise to maintain both the server software for patches and upgrades, as well as the operating system underneath. It is one of the easiest ways to migrate your on-prem SQL Server into Azure, as it usually requires very little coding or other changes.

Which of the following SQL statements is most likely to retrieve all of the columns and rows of the Employees table?

Which of the following SQL statements is most likely to retrieve all of the columns and rows of the Employees table? SELECT * FROM Employees; (Correct) SELECT Employees WHERE Location = 'Idaho'; SELECT TABLE Employees; SELECT VIEW Employees; Explanation The SQL syntax requires the verb SELECT, followed by a list of column names or *, followed by FROM, followed by the table name, and ending in a semi-colon.

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?

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 (Correct) Batch processing Explanation Any program that requires real-time processing and is extremely time-sensitive might want to consider stream processing data

Which of the following database features would be best for an analytics workload and not a transactional workload?

Which of the following database features would be best for an analytics workload and not a transactional workload? A fully-normalized table structure, requiring a lot of JOINs to extract reports Unstructured data, stored as binary files in a Blob storage account Semi-structured data, stored in JSON documents Optimized for reading data and not optimized (or even able) to update data (Correct) Explanation Analytics workloads focus on running reports, with complex and long-running queries. They are best unnormalized or at least partially-unnormalized. Data that can change at any moment would make such a DB difficult as reports would have different results between runs. Refer to Microsoft Doc: https://docs.microsoft.com/en-

Which of the following is an advantage of running your SQL database on the PaaS model in Azure?

Which of the following is an advantage of running your SQL database on the PaaS model in Azure? Keep control of your data inside your own corporate environment Cheapest up-front capital expenditure (Correct) Maximize your control of the hardware settings Cheapest per-day operational expenditure Explanation Starting a SQL Database in Azure costs nothing up front ($0), you simply pay for the ongoing per hour cost of running the database.

Which of the following statements best describes Azure Databricks?

Which of the following statements best describes Azure Databricks? A non-relational data store A data analytics platform optimized for Azure cloud services (Correct) A relational database A machine learning platform Explanation Azure Databricks offers a SQL platform for analysts to run queries against data, a platform to allow data scientists and engineers to work together on tough data science problems, and a machine learning environment to build, train and test models. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks

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 The minimum throughput you can allocate to a database or container is 400 RU/s. You can increase and decrease the RU/s for a container at any time. Allocating more RU/s increases the cost. However, once you allocate throughput to a database or container, you'll be charged for the resources provisioned, whether you use them or not.

What is the maximum amount of data that can be stored in a Azure Table Storage database?

5 PB

What is the difference between a clustered and unclustered index in SQL Server?

A Clustered index sort and store the data rows based on their key values. Nonclustered indexes have a structure separate from the data rows. Clustered indexes sort and store the data rows in the table or view based on their key values. These are the columns included in the index definition. There can be only one clustered index per table, because the data rows themselves can be stored in only one order. This is also called a PRIMARY KEY

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?

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 (Incorrect) Data Warehousing OLTP (Correct) Cache The management of transactional data using computer systems is referred to as online transaction processing (OLTP). OLTP systems record business interactions as they occur in the day-to-day operation of the organization, and support querying of this data to make inferences.

Which of the following types of data is an example of a transactional workload?

A database that contains the day to day operations of an organization The management of transactional data using computer systems is referred to as online transaction processing (OLTP). OLTP systems record business interactions as they occur in the day-to-day operation of the organization, and support querying of this data to make inferences.

Which statement best describes a STORED PROCEDURE in a relational database?

A group of one for more SQL statements A stored procedure in SQL Server is a group of one or more Transact-SQL statements. They can accept input parameters, contain programming statements, they can call other stored procedures, and they can return a status code to indicate success or failure.

Which of the following sentences best describes what an INDEX is in SQL Server?

A structure associated with a table or a view that speeds retrieval of rows. Indexes speed up the retrieval of rows by pre-sorting them in a manner that is fast to search. Too many indexes can make updating a database slower and less efficient, so there is a balance to make.

Data Manipulation Language (DML) primarily serves which function?

Affect the information stored in the database. (Correct) Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database. These statements include SELECT, INSERT, UPDATE and DELETE.

Which of the following methods is commonly used to secure data in transit?

Azure Active Directory (Incorrect) Hard disk encryption User id and password Site-to-site VPN (Correct) Explanation Because data is moving back and forth from many locations, we generally recommend that you always use SSL/TLS protocols to exchange data across different locations. In some circumstances, you might want to isolate the entire communication channel between your on-premises and cloud infrastructures by using a VPN.

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 Blob Storage is the best place to store binary data such as images, videos and other files. If you later need to reference it in a database, you might want to just provide a file name in the data table and leave the data in the storage account. SQL Database, Cosmos DB and Table Storage are not designed for storing large amounts of binary data such as videos.

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 File Storage Azure Files offers fully managed file shares in the cloud that are accessible via the industry standard Server Message Block (SMB) protocol or Network File System (NFS) protocol. Azure file shares can be mounted concurrently by cloud or on-premises deployments. Azure Files SMB file shares are accessible from Windows, Linux, and macOS clients.

When a customer wants to manage their own encryption keys for SQL Database Transparent Data Encryption (TDE), where are those keys stored?

Azure Key Vault Azure SQL Transparent Data Encryption (TDE) with customer-managed key enables Bring Your Own Key (BYOK) scenario for data protection at rest, and allows organizations to implement separation of duties in the management of keys and data. With customer-managed transparent data encryption, customer is responsible for and in a full control of a key lifecycle management (key creation, upload, rotation, deletion), key usage permissions, and auditing of operations on keys. This key is stored in the Azure Key Vault.

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 single instance You can have a small Azure SQL Database single instance (S0 plan) for only $14.70 per month. This includes 250 GB of storage. If your performance expectations are low (for an infrequently used internal application), this could be a great option.

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 Table Storage Azure Table Storage is designed for scaling inexpensively. Cosmos DB can scale but is not inexpensive. Redis Cache is a key-value store, but is also not inexpensive and not really designed for storing data that you cannot afford to lose. Azure Queue Storage is not a great option for storing data and is a messaging platform. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/learn/modules/explore-non-relational-data-offerings-azure/2-explore-azure-table-storage

Synapse Analytics and Azure Databricks are both Spark-based analytics platforms. What feature does Synapse Analytics offer thatn Databricks currently does not?

Based on the SQL Engine, familiar for existing SQL Server environments Both platforms can perform similar tasks, such as scaling, parallel processing and ingesting data from various sources. Synapse Analytics also supports SQL syntax, which will be familiar for developers of SQL Server.

Which of the following data types can be called structured data?

Contents of SQL Database table Structured data, sometimes referred to as relational data, is data that adheres to a strict schema, so all of the data has the same fields or properties. The shared schema allows this type of data to be easily searched with query languages such as SQL (Structured Query Language). This capability makes this data style perfect for applications such as CRM systems, reservations, and inventory management. Structured data is often stored in database tables with rows and columns with key columns to indicate how one row in a table relates to data in another row of another table.

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 Document data is data that is stored in a readable format, such as JSON. Using Cosmos DB Core SQL API, you can query this data. The database does not enforce a schema on the data. It scales for a global scale.

ou 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?

Dynamic Data Masking Dynamic data masking (DDM) limits sensitive data exposure by masking it to non-privileged users. It can be used to greatly simplify the design and coding of security in your application. Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to specify how much sensitive data to reveal with minimal impact on the application layer. DDM can be configured on designated database fields to hide sensitive data in the result sets of queries. With DDM the data in the database is not changed. DDM is easy to use with existing applications, since masking rules are applied in the query results. Many applications can mask sensitive data without modifying existing queries

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 Dynamic data masking (DDM) limits sensitive data exposure by masking it to non-privileged users. It can be used to greatly simplify the design and coding of security in your application. Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to specify how much sensitive data to reveal with minimal impact on the application layer. DDM can be configured on designated database fields to hide sensitive data in the result sets of queries. With DDM the data in the database is not changed. DDM is easy to use with existing applications, since masking rules are applied in the query results. Many applications can mask sensitive data without modifying existing queries.

By what method can you limit who has access to your Cosmos DB account from the Internet?

IP policy-based access control By default, your Azure Cosmos account is accessible from internet, as long as the request is accompanied by a valid authorization token. To configure IP policy-based access control, the user must provide the set of IP addresses or IP address ranges in CIDR (Classless Inter-Domain Routing) form to be included as the allowed list of client IPs to access a given Azure Cosmos account. Once this configuration is applied, any requests originating from machines outside this allowed list receive 403 (Forbidden) response. Disabling access to the public network may also be effective, but that eliminates access entirely and does not control access to a select group of people.

Generally speaking, regardless of which region, which is the lowest cost redundancy option for Blob Storage?

LRS Azure Storage always stores multiple copies of your data so that it is protected from planned and unplanned events, including transient hardware failures, network or power outages, and massive natural disasters. Redundancy ensures that your storage account meets its availability and durability targets even in the face of failures. Locally redundant storage (LRS) copies your data synchronously three times within a single physical location in the primary region. LRS is the least expensive replication option, but is not recommended for applications requiring high availability or durability.

Why would someone choose Azure Table Storage instead of Azure Cosmos DB Table API?

Lowest- cost option Table Storage is a good solution when you have a large volume of key-value data, and don't want to pay too much to store it. Especially when latency is not a huge issue for you.

Which of the following database API formats is not currently supported in CosmosDB?

MaxDB Choose from multiple database APIs including the native Core (SQL) API, API for MongoDB, Cassandra API, Gremlin API, and Table API.

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. The API determines the type of account to create. Azure Cosmos DB provides five APIs: Core (SQL) and MongoDB for document data, Gremlin for graph data, Azure Table, and Cassandra. Currently, you must create a separate account for each API.

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 123.123.123.0-123.123.123.255 and denies all other traffic. DB1 has a database level firewall rule that allows IPs in the range 123.123.123.0-123.123.124.255. When a client using the IP address 123.123.124.25 attempts to access DB1, are they successful?

No, the connection will not succeed. ou can have both server- and database-level firewall IP rules, and they exist independently. An IP can exist in a database rule and not a server rule, and the user would have access to the specific database and not all databases on the server. In this case, the client trying to access the database is allowed by a database-level IP rule.

By what orchestration method does the Azure Data Factory move data from source, through several transformational steps, into it's final destination?

Pipelines A pipeline is a series of activities, and is the process by which data travels from its source, gets transformed, into one or more destinations.

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?

Powershell, CLI You can use command-line scripts using Powershell or CLI to make changes to Azure. For instance, you can list all of the Virtual Machines in a region, add a new VM, delete a VM, or make other changes to your resources - all from the command line. You can provision Cosmos DB from the command line as well.

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 Real time processing deals with streams of data that are captured in real-time and processed with minimal latency to generate real-time (or near-real-time) reports or automated responses. For example, a real-time traffic monitoring solution might use sensor data to detect high traffic volumes. This data could be used to dynamically update a map to show congestion, or automatically initiate high-occupancy lanes or other traffic management systems. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-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?

Server-level IP firewall If you need to white-list (or preapprove) a specific Ip address or range to the entire server, a server-level firewall rule should suffice. You could add individual database-level IP firewall rules, but that is not the optimal solution. An NSG cannot help here, and the Azure Firewall service is more complicated to set up.

Which of the following is an advantage to using a non-relational database over a relational one?

Supports different types of data instead of being forced into a row/column model A non-relational database is a database that does not use the tabular schema of rows and columns found in most traditional database systems. Instead, non-relational databases use a storage model that is optimized for the specific requirements of the type of data being stored. For example, data may be stored as simple key/value pairs, as JSON documents, or as a graph consisting of edges and vertices.

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?

Switch all apps to Key 2 and regenerate key 1 Primary keys provide access to all the administrative resources for the database account. Each account consists of two primary keys: a primary key and secondary key. The purpose of dual keys is to let you regenerate, or roll keys, providing continuous access to your account and data.

How do you implement the Zero Trust model of security?

Verify each request as though it originated from an uncontrolled network Instead of believing everything behind the corporate firewall is safe, the Zero Trust model assumes breach and verifies each request as though it originated from an uncontrolled network. Regardless of where the request originates or what resource it accesses, the Zero Trust model teaches us to "never trust, always verify." Some of these techniques may contribute to security, but the Zero Trust model is about verification and assuming that your systems have been breached.

What do you get when you use Cool access tier for Azure Blob Storage?

What do you get when you use Cool access tier for Azure Blob Storage? Less expensive per GB to store the file, and more expensive to access the file (Correct) The lease expensive way to store files per GB in Azure 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 (Incorrect) Explanation Azure storage offers different access tiers, allowing you to store blob object data in the most cost-effective manner. Cool tier is optimized for storing data that is infrequently accessed and stored for at least 30 days. It's roughly 25% cheaper to store data than the Hot tier, but twice as expensive to read and write data. Refer to Microsoft Doc: https://docs.microsoft.com/e

What feature of Azure Blob Storage would allow recovery of a file that was accidentally deleted? Choose two. Change feed Soft delete (Correct) Immutable blobs Blob versioning (Correct)

What feature of Azure Blob Storage would allow recovery of a file that was accidentally deleted? Choose two. Change feed Soft delete (Correct) Immutable blobs Blob versioning (Correct) Explanation The best answer is the soft delete feature. This enforces a time in which a deleted blob is recoverable. Blob versioning also allows a deleted blob to be recovered. The other two answers do not specifically deal with recovering deleted data. Refer to Microsoft Doc: https://docs.

What feature of Azure Blob Storage, if enabled, allows you to retrieve files that have previously been deleted within a time period?

What feature of Azure Blob Storage, if enabled, allows you to retrieve files that have previously been deleted within a time period? Change Feed Soft Delete (Correct) Immutable blobs Azure Policy (Incorrect) Explanation Soft Delete allows you to recover deleted files within a set time period as configured. Change Feed would not allow you to recover deleted files. Immutable blobs can restrict deletion but not help you recover files. And Azure Policy does not have an option that deals with the contents of a storage account. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/learn/modules/explore-non-relational-data-offerings-azure/3-explore-azure-blob-storage

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?

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 (Correct) Dynamic Data Masking Row-level security Azure Threat Detection (Incorrect) Explanation Always Encrypted is a feature designed to protect sensitive data, such as credit card numbers or national identification numbers (for example, U.S. social security numbers), stored in Azure SQL Database or SQL Server databases. Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to the Database Engine (SQL Database or SQL Server). As a result, Always Encrypted provides a separation between those who own the data and can view it, and those who manage the data but should have no access. By ensuring on-premises database administrators, cloud database operators, or other high-privileged unauthorized users, can't access the encrypted data, Always Encrypted enables customers to confidently store sensitive data outside of their direct control. This allows organizations to store their data in Azure, and enable delegation of on-premises database administration to third parties, or to reduce security clearance requirements for their own DBA staff. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryptio

What happens if you do not provision enough Request Units per second (RU/s) than your application requires?

What happens if you do not provision enough Request Units per second (RU/s) than your application requires? The application will not receive any errors but you will see a notification in the Azure portal Requests will take longer than expected You will be charged for the excess Request Units Requests will be asked to retry later (Correct) Explanation If you underprovision (by specifying too few RU/s), Cosmos DB will start throttling performance. Once throttling begins, requests will be asked to retry later when hopefully there are available resources to satisfy it. If an application makes too many attempts to retry a throttled request, the request could be aborted. Refer to Micro

What is one reason why someone would design a report as a paginated report?

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. (Correct) Explanation Paginated reports are great when you need all of the details in one place. Instead of printing thousands of rows on the screen, you paginate them which makes it easier to navigate. It can also be printed. Charts and graphs are more likely to appear on a dashboard, where data needs to be summarized. And I would not suggest creating a report that spans 100,000s of pages because no one will every read that. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

What is one way that you can secure all data coming to and from an Azure Storage Account?

What is one way that you can secure all data coming to and from an Azure Storage Account? Dynamic Data Masking (Incorrect) Regenerate the Primary Access Key Use Always Encrypted client library Enable "Secure transfer required" property for the storage account (Correct) Explanation You can configure your storage account to accept requests from secure connections only by setting the Secure transfer required property for the storage account. When you require secure transfer, any requests originating from an insecure connection are rejected. Microsoft recommends that you always require secure transfer for all of your storage accounts

What is the advantage of using Transaction Optimized storage for Azure File Storage?

What is the advantage of using Transaction Optimized storage for Azure File Storage? It costs the same as Hot storage, but provides better performance for smaller files (Incorrect) 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. (Correct) 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 Explanation Transaction Optimized storage provides better a cost profile for frequently accessed files. It costs more to store the file, but much less to access it. And it supports Standard Tier of storage. Refer to Micro

What is the concept of NORMALIZATION when it comes to relational databases?

What is the concept of NORMALIZATION when it comes to relational databases? Removing duplicate rows from a table (Incorrect) 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. (Correct) Regenerating a table's indexes to increase performance Compressing a data table to it's smallest possible size Explanation Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description

What method of provisioning a non-relational database would be best for users that only need to do this one time?

What method of provisioning a non-relational database would be best for users that only need to do this one time? Azure Portal (Correct) ARM templates PowerShell scripting Bicep scripting Explanation If you only need to perform a task once, or have custom configuration needs, using the Azure Portal to create a resource is probably the best approach. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/learn

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?

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? Key-value data (Incorrect) Document data Graph data Object data (Correct) Explanation Object data, which is Azure Blob Storage inside Azure, uses a container metaphor. You can store any type of binary or text data into it, using files. The data store is optimzed for files such as images and videos.

When deploying an Azure Storage account, and you choose Locally Redundant Storage (LRS), how many copies of your data does Azure keep?

When deploying an Azure Storage account, and you choose Locally Redundant Storage (LRS), how many copies of your data does Azure keep? 3 (Correct) 1 copy in each Availability Zone 1 6 Explanation Azure Storage always stores multiple copies of your data so that it is protected from planned and unplanned events, including transient hardware failures, network or power outages, and massive natural disasters. Redundancy ensures that your storage account meets its availability and durability targets even in the face of failures. Locally redundant storage (LRS) copies your data synchronously three times within a single physical location in the primary region. LRS is the least expensive replication option, but is not recommended for applications requ

When deploying an Azure Storage account, and you choose Zone Redundant Storage (ZRS), how many copies of your data does Azure keep?

When deploying an Azure Storage account, and you choose Zone Redundant Storage (ZRS), how many copies of your data does Azure keep? 1 6 3 copies in each Availability Zone 3 (Correct) Explanation Azure Storage always stores multiple copies of your data so that it is protected from planned and unplanned events, including transient hardware failures, network or power outages, and massive natural disasters. Redundancy ensures that your storage account meets its availability and durability targets even in the face of failures. Zone-redundant storage (ZRS) copies your data synchronously across three Azure availability zones in the primary region. For applications requiring high availability, Microsoft recommends using ZRS in the primary region, and also replicating to a secondary region. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy

When it comes to data security, what is the principle of least privilege?

When it comes to data security, what is the principle of least privilege? Users are only granted permissions for the specific task that they are trying to do, at the moment they are trying to do it. (Incorrect) 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. Administrative users should be forced to use MFA when logging in. Users only have the permissions they need to complete their job, and no more. (Correct) Explanation Grant the least privilege that's required to complete task; audit and log access requests. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/security/fundamentals/protection-customer-data

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?

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 SQL Database (Incorrect) Azure Machine Learning Azure Data Factory (Correct) Azure Data Migration Explanation If you have to do processing of data along the way, Azure Data Factory has the ability to move data from one source to another destination with processing along the way. Azure Data Migration is more about simple movement of data from one source to another. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/data-factory/introduction

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.

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 SQL Database Azure Data Factory Azure Synapse Analytics Azure Databricks (Correct) Explanation Azure Databricks is a data analytics platform optimized for the Microsoft Azure cloud services platform. Azure Databricks offers three environments for developing data intensive applications: Databricks SQL, Databricks Data Science & Engineering, and Databricks Machine Learning. Databricks Data Science & Engineering provides an interactive workspace that enables collaboration between data engineers, data scientists, and machine learning engineers. For a big data pipeline, the data (raw or structured) is ingested into Azure through Azure Data Factory in batches, or streamed near real-time using Apache Kafka, Event Hub, or IoT Hub. This data lands in a data lake for long term persisted storage, in Azure Blob Storage or Azure Data Lake Storage. As part of your analytics workflow, use Azure Databricks to read data from multiple data sources and turn it into breakthrough insights using Spark. Refer to Microsoft Doc: https://docs.microsoft.com/

Which CosmosDB API format works best with graph data?

Which CosmosDB API format works best with graph data? Table API Cassandra API Gemlin API (Correct) Core (SQL) API Gremlin API allows users to make graph queries and stores data as edges and vertices. Cassandra API stores data in column-oriented schema. Core (SQL) API stores data in document format. Table API stores data in key/value format.

Which SQL server query tool offers a modern editor experience, Intellisense, code snippets, source control integration, and an integrated terminal?

Which SQL server query tool offers a modern editor experience, Intellisense, code snippets, source control integration, and an integrated terminal? Azure Data Studio (Correct) Azure Portal Data Explorer sqlcmd Microsoft Visual Studio Explanation Azure Data Studio is a modern data development environment that offers all of those features. In the Azure Portal, you can run some basic queries against your database, but won't get access to those featuers. sqlcmd is a command line tool. Microsoft Visual Studio offers a lot of those features for code development, and not specifically for SQL Server data development. Refer

Which data loading approach is more suitable for situations that require scaling, and is ideal for large volumes of data?

Which data loading approach is more suitable for situations that require scaling, and is ideal for large volumes of data? ELT (Correct) ETL Explanation ELT is a more scalable approach, because the data is transformed after it's loaded into the cloud database.

Which data visualization style is colored rectangles of varying size?

Which data visualization style is colored rectangles of varying size? Scatter chart Treemap (Correct) Matrix Pie chart Explanation Treemaps are charts of colored rectangles, with size representing the relative value of each item. They can be hierarchical, with rectangles nested within the main rectangles.

Which of the following columns would make a good ID field for a data table?

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 A sequential number starting from 1 that increments by 1 every time a data row is added to the table (Correct) Email address Customer name Explanation The most common type of ID field is a sequential number that starts from 1, managed by the database itself. This is to ensure each row is unique and can be addressed by a unique number. A customer name would make a terrible ID field as it might not be unique. ID fields are typically decimal or hexidecimal numbers.

Which of the following data types can be called unstructured data?

Which of the following data types can be called unstructured data? Contents of a Blob storage container (Correct) Azure Table Storage JSON data SQL Database table (Incorrect) Explanation The organization of unstructured data is ambiguous. Unstructured data is often delivered in files, such as photos or videos. The video file itself may have an overall structure and come with semi-structured metadata, but the data that comprises the video itself is unstructured. Therefore, photos, videos, and other similar files are classified as unstructured data. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/learn/modules/choose-storage-approach-in-azure/2-classify-data

Which of the following database models is optimized for the day-to-day operations of a company's business?

Which of the following database models is optimized for the day-to-day operations of a company's business? Data warehousing OLAP (online analytics processing) CSV files OLTP (online transaction processing) (Correct) Explanation OLTP is specially for data that can be added, updated and deleted as business is done. It's a good general mix between searching and selecting data, and modifying data. OLAP is specifically designed for complex searching and selecting of data. Data warehouse is similar to OLAP in that respect. And CSV files... well, those are not great for a business database. Re

Which of the following is a valid IP address range using the CIDR address method?

Which of the following is a valid IP address range using the CIDR address method? 110.0.0.0-255 (Incorrect) 110.0.0.* 110.0.0.0/8 (Correct) 110.0.0.0-110.0.0.255 Explanation CIDR introduced a new method of representation for IP addresses, now commonly known as CIDR notation, in which an address or routing prefix is written with a suffix indicating the number of bits of the prefix, such as 192.0.2.0/24 for IPv4, and 2001:db8::/32 for IPv6. Refer to Microsoft Doc: https://whatismyipaddress.com/cidr

Which of the following is an advantage of batch processing of data? Choose two.

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 (Correct) Processing data altogether is sometimes more efficient than processing data one at a time (Correct) Data gets processed immediately One single bad row of data doesn't affect the whole job Explanation Batch processing of data allows you to schedule a job in an off-peak hour such as overnight. It is also sometimes easier to run a batch of data through a process instead of a constant stream of one at a time. But batch processing does add delay to data processing, and it can happen that a bad piece of data stops the job, affecting other data too.

Which of the following is considered a downside to using a non-relational data store compared to a relational database?

Which of the following is considered a downside to using a non-relational data store compared to a relational database? It's harder to modify the data schema of a non-relational data store (Incorrect) Relational data stores are better for extremely high-throughput Non-relational data store does not support different data storage types An non-relational data store does not enforce a consistent data state within the database. (Correct) Explanation If your database has a lot of links that require data to exist in one place in order for data in another place to have meaning, you might need to do more work to ensure that consistency in a non-relational database. Relational databases support foreign keys, and can block certain INSERTS, UPDATES or DELETES if the foreign key relationship doesn't allow it. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/cosmos-db/relational-nosql

Which of the following metrics affect how much an Azure Redis Cache instance costs?

Which of the following metrics affect how much an Azure Redis Cache instance costs? Per transaction (Incorrect) Region, Pricing tier Region, Consumed storage, pricing tier Region, pricing tier, hours (Correct) Explanation Redis Cache is charged by the hour, and varies by region. It also depends on the tier you choose. Refer

Which of the following metrics affect how much an Azure Table Storage account costs?

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 (Correct) Tier - Standard or Premium Explanation Storage tables are charged based on the region they are located in, the replication option, the consumed storage, and a few cents per million transactions. Refer to Microsoft Doc: https://azure.microsoft.com/en-us/pricing/details/storage/tables/

Which of the following techniques is an example of Least Privileged Access?

Which of the following techniques is an example of Least Privileged Access? Have managers reguarly review their employees' access using Access Reviews. Just-In-Time (JIT) access (Correct) Have users regularly review their own access using Access Reviews. Enable auditing and logging. Explanation Limit user access with Just-In-Time and Just-Enough-Access (JIT/JEA), risk-based adaptive policies, and data protection.

Which of the follwing is a consequnce of having a foreign key relationship between two relational data tables?

Which of the follwing is a consequnce of having a foreign key relationship between two relational data tables? You can DELETE a row of a data table that has several other rows in other tables dependent on it as a foreign key. (Incorrect) 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. An INSERT statement will fail if the value of the foreign key column, other than NULL, doesn't exist in the other table. (Correct) Explanation When a value other than NULL is entered into the column of a FOREIGN KEY constraint, the value must exist in the referenced column. Otherwise, a foreign key violation error message is returned. To make sure that all values of a composite foreign key constraint are verified, specify NOT NULL on all the participating columns.

Which type of SQL query language is used to creating and modifying the structure of a database?

Which type of SQL query language is used to creating and modifying the structure of a database? DDL (Correct) DQL DCL DML Explanation DDL is Data Definition Language, and is used for creating data schema elements.

Which type of data analytics workload is best for processing data that arrives from an external source once per day?

Which type of data analytics workload is best for processing data that arrives from an external source once per day? Batch processing (Correct) Stream processing Real-time processing Queue messaging A common big data scenario is batch processing of data at rest. In this scenario, the source data is loaded into data storage, either by the source application itself or by an orchestration workflow. The data is then processed in-place by a parallelized job, which can also be initiated by the orchestration workflow. The processing may include multiple iterative steps before the transformed results are loaded into an analytical data store, which can be queried by analytics and reporting components.

Which type of data analytics workload is best for processing data that arrives in a stream, without a start or an end?

Which type of data analytics workload is best for processing data that arrives in a stream, without a start or an end? ETL pipeline Real-time processing (Correct) Batch processing Explanation Real-time processing is defined as the processing of unbounded stream of input data, with very short latency requirements for processing - measured in milliseconds or seconds. This incoming data typically arrives in an unstructured or semi-structured format, such as JSON, and has the same processing requirements as batch processing, but with shorter turnaround times to support real-time consumption. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/archite

Who's responsibility is "data security" in the Azure Shared Responsibility model?

Who's responsibility is "data security" in the Azure Shared Responsibility model? Nobody's responsibility (Incorrect) Shared between Azure and the client (Correct) Entirely Microsoft's responsibility Entirely the client's responsibility Explanation Data security is a shared responsibility between you, the customer, and your database provider. Depending on the database provider you choose, the amount of responsibility you carry can vary. If you choose an on-premises solution, you need to provide everything from end-point protection to physical security of your hardware - which is no easy task. If you choose a PaaS cloud database provider such as Azure Cosmos DB, your area of concern shrinks considerably. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/cosmos-db/database-security

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?

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? Running SQL Server in the cloud means you have to accept whatever version they are running You can choose from any number of still-supported SQL Server versions (Correct) Explanation You can select from any of the still-supported versions of SQL Sever on a VM.

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?

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 SQL Server Stretch DB Server scale-up Manual sharding (Correct) Explanation One of the most obvious challenges when maintaining a relational database system is that most relational engines apply locks and latches to enforce strict ACID semantics. This approach has benefits in terms of ensuring a consistent data state within the database. However, there are heavy trade-offs with respect to concurrency, latency, and availability. Due to these fundamental architectural restrictions, high transactional volumes can result in the need to manually shard data. Implementing manual sharding can be a time consuming and painful exercise. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/azure/cosmos-db/relational-nosql

ou 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?

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 Jupyter Notebook Paginated Reports (Correct) Dashboard Explanation Any time your client asks for detail, in rows and columns, you should be thinking about a paginated report. A Dashboard is more likely used as a single page summary of things in an easy-to-read visual form. A one-page report is probably a bad idea here. And although Jupyter Notebooks are cool, I would never give one directly to a client unless they are sophisticated. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

How do you disable SQL Database encryption at rest so that the data is stored on the hard disk in a readable format?

You cannot. TDE is enabled by default and cannot be disabled. In Azure, all newly created databases are encrypted by default and the database encryption key is protected by a built-in server certificate. Certificate maintenance and rotation are managed by the service and require no input from the user. Customers who prefer to take control of the encryption keys can manage the keys in Azure Key Vault.

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?

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 Table Storage (Correct) Azure SQL Database Cosmos DB Azure Data Lake Storage Gen2 (Incorrect) Explanation Azure Table Storage allows you to store key-value data as the cheapest per GB rate. Cosmos DB also have a key-value option, but is not as cost effective. Azure SQL Database is a relational data store. And Azure Data Lake Storage is a good option for data ingestion, but is not a key-value storage. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/learn/modules/explore-non-relational-data-offerings-azure/2-explore-azure-table-sto

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?

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? Cosmos DB Redis Cache Azure Blob Storage (Correct) SQL Database Explanation Blob Storage is the best place to store binary files such as images. Neither Cosmos DB nor Redis Cache can handle large amounts of data such as this, and it does not make sense to do it using SQL Database. Refer to Microsoft Doc: https://docs.microsoft.com/en-us/learn/modules/explore-non-relational-data-offerings-azure/3-explore-azure-blob-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?

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 Cosmos DB Azure Data Lake Storage Gen2 (Correct) Azure Blob Storage Azure Synapse Analytics Explanation Azure Data Lake is the correct answer. Blob Storage is also a place to store data before processing, but if you can't estimate how much data, there are limits on the size per account. Cosmos DB is not great for large amounts of unprocessed data. A Data Lake is a much better answer for ingesting data before processing. Synapse is a good data warehouse solution, but typically is used after you have ingested and processed the data. Refer to Microsoft Doc: https://docs.microsoft.com/en-ca/azure/storage/blobs/data-lake-storage-introduction

The SQL SELECT statement is part of which group of SQL statements?

he SQL SELECT statement is part of which group of SQL statements? Data Manipulation Language (DML) (Correct) Data Definition Language (DDL) Explanation Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database. These statements include SELECT, INSERT, UPDATE and DELETE. Refer to Microsoft Doc: h

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?

ou 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 add your client IP address to the firewall. (Correct) You need to connect through port 1433 You need to give the user specific rights to the individual DB You need to grant your Azure AD user read rights to the DB Explanation Azure SQL Database has a server and database firewall. By default, no IP addresses are allowed to access the database until you add one. Refer to Microsoft Doc: http

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?

ou 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? Semi-structured data (Correct) Unstructured data Structured data Comma-separated files (CSV) Explanation Semi-structured data is data that follows some format, but that format is not enforced by the database. The fields are labelled, but at any time, any field can be missing and the data would still be stored in the DB. Your application needs to deal with this variety. Refer to Microsoft