Exam DP-900 final

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Descriptíve analytics tells you _______. what is most likely to occur in the future. what occurred in the past. which actions you can perform to affect outcomes. why something occurred in the past.

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Normalization involves eliminating relationships between database tables. Normalizing a database reduces data redundancy. Normalization improves data integrity.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: An extract, transform, and load (ETL) process requires ________. a matching schema in the data source and the data target. a target data store powerful enough to transform data. data that is fully processed before being loaded to the target data store. that the data target be a relational database.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: In batch processing, _________. data is always inserted one row at a time. data is processed in real—time. latency is expected. processing can only execute serially.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Transcribing audio ñles is an example of _______. cognitive. descriptive. predictive. prescriptive.

Match the types of analytics that can be used to answer the business questions. To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Cognitive. Diagnostic. Descriptive. Predictive. Prescriptive.

OTSPOT - You have the following JSON document. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document. NOTE: Each correct selection is worth one point. Customer is [answer choice]. Address is [answer choice]. Social media is [answer choice].

HOTSPOT - You are reviewing the data model shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point Hot Area: The data model is a [answer choice]. Customer is a [answer choice] table.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: The massiver parallel processing (MPP) engine of Azure Synapse Analytics. distributes processing across compute nodes. distributes processing across control nodes. redirects client connections across compute nodes. redirects client connections across control nodes.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: is an object associated with a table that sorts and stores the data rows in the table based on their key values. A clustered index. A FileTable. A foreign key. A stored procedure.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A relational database is appropriate for scenarios that invotve a high volume of. changes to relationships between entities. geographically distributed writes. transactional writes. writes that have varying data structures.

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Batch processing can output data to a file store. Batch processing can output data to a relational database. Batch processing can output data to a NOSQL database.

Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place: An in-memory data integration tool. The CRM system. The data warehouse.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A visualization that shows a university's current student enrollment versus the maximum capacity is an example of _______. cognitive. descriptive. predictive. prescriptive.

DRAG DROP - Match the types of visualizations to the appropriate descriptions. To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Key influencer. Scatter. Treemap.

You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically. Which two types of replication can you use for the storage account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. zone-redundant storage (ZRS). read-access geo-redundant storage (RA-GRS). locally-redundant storage (LRS). geo-redundant storage (GRS).

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Platform as a service (PaaS) database offerings in Azure require less setup and configuration effort than infrastructure as a service (laaS) database offerings. Platform as a service (PaaS) database offerings in Azure provide administrators with the ability to control and update the operating system version. All relation and non-relational platform as a service (PaaS) database offerings in Azure can be paused to reduce costs.

Which statement is an example of Data Manipulation Language (DML)?. REVOKE. DISABLE. INSERT. GRANT.

You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query. What should you create?. an index. a view. a scalar function. a table.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A key/value data store is optimized for _________. enforcing constraints. simple lookups. table joins. transactions.

Match the types of data to the appropriate Azure data services. To answer, drag the appropriate data type from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Image files. Key/value pairs. Relationships between employees.

Match the Azure Data Lake Storage Gen2 terms to the appropriate levels in the hierarchy. To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Azure Storage account. File share. Container.

What are two characteristics of real-time data processing? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. Data is processed periodically. Low latency is expected. High latency is acceptable. Data is processed as it is created.

Match the Azure Data Factory components to the appropriate descriptions. To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Dataset. Linked service. Mapping data flow. Pipeline.

Match the types of workloads to the appropriate scenarios. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Batch. Streaming.

DRAG DROP - Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place: A standalone data analysis tool. The CRM system. The data warehouse.

Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. Which type of analysis is shown in the fourth quarter?. predictive. prescriptive. descriptive. diagnostic.

Which statement is an example of Data Manipulation Language (DML)?. REVOKE. DISABLE. CREATE. UPDATE.

To complete the sentence, select the appropriate option in the answer area. Hot Area: Creating closed caption text for audio files is an example of _______. cognitive. descriptive. predictive. prescriptive.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A visualization that illustrates a university's current student enrollment per department is an example of ________ analytics. cognitive. descriptive. predictive. prescriptive.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: An extract, load, and transform (ELT) process requires ________. a separate transformation engine. a target data store powerful enough to transform data. data that is fully processed before being loaded to the target data store. a data pipeline that includes a transformation engine.

You need to create an Azure resource to store data in Azure Table storage. Which command should you run?. az storage share create. az storage account create. az cosmosdb create. az storage container create.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: The Azure Cosmos DB ________ API enables the use of SELECT statements to retrieve documents from Azure Cosmos DB. Core (SQL). Gremlin. MongoDB. Table.

You need to modify a view in a relational database by adding a new column. Which statement should you use?. MERGE. ALTER. INSERT. UPDATE.

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Extract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems. Extract, load, and transform (ELT) transforms data by using a compute resource independent of the source system and destination system. Extract, load, and transform (ELT) minimizes the time it takes to copy large volumes of data to destination systems.

HOTSPOT - You plan to deploy a PostgreSQL database to Azure. Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. PostgreSQL on Azure VMs:. Azure Database for PostgreSQL:.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: ________ natively support the analysis of relationships between entities. Column family databases. Document databases. Graph databases. Key-value stores.

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?. Azure Table storage. Azure Data Lake Storage. Azure Queue storage. Azure Files.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Relational data is stored in __________. a file system as a unstructured data. a hierarchal folder structure. a tabular form of rows and columns. a comma-separated value (CSV) files.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: ________ physically sorts the data in a table based on the values in a specified column. A view. A clustered index. A stored procedure. A nonclustered index.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A block of code that runs in a database is called ______. a stored procedure. a table. a view. an index.

You have an inventory management database that contains the following table. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?. INSERT. MERGE. UPDATE. CREATE.

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?. Azure HDInsight. Azure SQL Database. Azure Cosmos DB. SQL Server on Azure virtual machines.

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use?. Microsoft SQL Server Management Studio (SSMS). Azure Data Studio. Azure CLI. Azure PowerShell.

Match the terms to the appropriate descriptions. To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Index. View. Table.

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?. stream processing. batch processing. Online Analytical Processing (OLAP). Online Transaction Processing (OLTP).

When can you use an Azure Resource Manager template?. to automate the creation of an interdependent group of Azure resources in a repeatable way. to apply Azure policies for multi-tenant deployments. to provision Azure subscriptions. to control which services and feature administrators and developers can deploy from the Azure portal.

You have an Azure SQL database that you access directly from the Internet. You recently changed your external IP address. After changing the IP address, you can no longer access the database. You can connect to other resources in Azure. What is a possible cause of the issue?. role-based access control (RBAC). Dynamic Host Configuration Protocol (DHCP). Domain Name Service (DNS). a database-level firewall.

Match the tools to the appropriate descriptions. To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all. Select and Place: Azure Data Studio. Microsoft SQL Server Data Tools (SSDT). Microsoft SQL Server Management Studio (SSMS). Microsoft Visual Studio Code.

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Relational database tables contain columns and rows. lndexes in a relational database describe the data types in a table. A database view is a virtual table whose content is defined by a query.

Which command-line tool can you use to query Azure SQL databases?. sqlcmd. bcp. azdata. Azure CLI.

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Azure SQL Database includes a managed backup service. Azure SQL Database has built-in high availability. Azure SQL Database can use Azure Defender.

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: You can use Azure Data Studio to query a Microsoft SQL Server big data cluster. You can use Microsoft SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics data warehouse. You can use MySQL Workbench to query Azure Database for MariaDB databases.

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Platform as a service (PaaS) database offerings in Azure provide built-in high availability. Platform as a service (PaaS) database offerings in Azure provide configurable scaling options. Platform as a service (PaaS) database offerings in Azure reduce the administrative overhead for managing hardware.

You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically. Which two types of replication can you use for the storage account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. Dbo.Products:. ProductName:.

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: You must apply operating system updates to Azure SQL databases regularly. You need a Microsoft 365 subscription to create an Azure SQL database. You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases.

Which statement is an example of Data Definition Language (DDL)?. SELECT. JOIN. UPDATE. CREATE.

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Azure Data Studio can be used to query an Azure SQL database from a device that runs macOS. Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks. Azure Data Studio can be used to restore a database.

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP). Which Azure service should you use to support the application?. Azure Cosmos DB. Azure HDInsight. Azure SQL Database. Azure Synapse Analytics.

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. access to the latest features. complete control over backup and restore processes. in-database machine learning services. reduced administrative effort for managing the server infrastructure.

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: If you have a platform as a service (PaaS) database in Azure, you are responsible for applying operating system updates. If you have a platform as a service (PaaS) database in Azure, backups are performed automatically. If you have a platform as a service (PaaS) database in Azure, you are responsible for upgrading the database engine.

You have a table named Sales that contains the following data. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place: CREATE. ORDER BY. GROUP BY. SELECT.

When you create an Azure SQL database, which account can always connect to the database?. the Azure Active Directory (Azure AD) account that created the database. the server admin login account of the logical server. the Azure Active Directory (Azure AD) administrator account. the sa account.

Which statement is an example of Data Definition Language (DDL)?. SELECT. INSERT. DELETE. DROP.

A team of developers has computers that run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as IntelliSense. What should the developers use?. sqlcmd. Microsoft SQL Server Management Studio (SSMS). Azure Data Studio. Azure Data Explorer.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Transparent Data Encryption (TDE) encrypts ______. a column to protect data at rest and in transit. queries and their results in order to protect data in transit. the database to protect data at rest. the server to protect data at rest.

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication should you use?. service principal authentication. Azure Active Directory (Azure AD) authentication. SQL authentication. certificate authentication.

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?. built-in high availability. native support for cross-database queries and transactions. system-initiated automatic backups. support for encryption at rest.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: By default, each Azure SQL database is protected by _______. a network security group (NSG). a server-level firewall. Azure Firewall. Azure Front Door.

You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?. Microsoft SQL Server Data Tools (SSDT). Microsoft SQL Server Management Studio (SSMS). Azure Databricks. Azure Data Studio.

Match the security components to the appropriate scenarios. To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Authentication. Firewall. Encryption.

You have a transactional application that stores data in an Azure SQL managed instance. When should you implement a read-only database replica?. You need to generate reports without affecting the transactional workload. You need to audit the transactional application. You need to implement high availability in the event of a regional outage. You need to improve the recovery point objective (RPO).

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A relational database must be used when _________. a dynamic schema is required. data will be stored as key/value pairs. storing large images and videos. strong consistency guarantees are required.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Relational data uses _________ to enforce relationships between different tables. collection. columns. keys. partitions.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: _________ is a virtual table that contains content defined by a query. A heap. A stored procedure. A view. An index.

You need to query a table named Products in an Azure SQL database. Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.) NOTE: Each correct selection is worth one point. You must be assigned the Reader role for the resource group that contains the database. You must have SELECT access to the Products table. You must have a user in the database. You must be assigned the Contributor role for the resource group that contains the database. Your IP address must be allowed to connect to the database.

DRAG DROP - Match the types of data stores to the appropriate scenarios. To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Graph. Object. Key/value.

You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point. the throughput. the read region. the partition key. the API.

Your company is designing a data store that will contain student data. The data has the following format. Which type of data store should you use?.  graph. key/value. object. columnar.

Which storage solution supports role-based access control (RBAC) at the file and folder level?. Azure Disk Storage. Azure Data Lake Storage. Azure Blob storage. Azure Queue storage.

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs. Which storage tier should you use?. Archive. Hot. Cool.

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?. document. columnar. graph. time series.

Match the Azure Cosmos DB APIs to the appropriate data structures. To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Cassandra API. Gremlin API. MongoDB API. Table API.

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation, ___________. enable the hierarchical namespace. set Account kind to BlobStorage. set Performance to Premium. set Replication to Read-access geo-redundant storage (RA-GRS).