Select the answer that correctly completes the sentence.
Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.
Which type of data store should you use?
Which type of database is Azure Database for PostgreSQL?
You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer.
Which two Transact-SQL statements should you include in the query? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.
Which type of analysis is shown for the fourth quarter?
Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates,
backups, and maintenance tasks?
Which service can be used to build extract, transform, and load (ETL) pipelines?
Match the data processing languages to the appropriate real-time analytics services.
To answer, drag the appropriate language from the column on the left to its service on the right. Each language may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Which statement is an example of Data Manipulation Language (DML)?
What can you use to create data ingestion pipelines?
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.
To complete the sentence, select the appropriate option in the answer area.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?
Select the answer that correctly completes the sentence.
To complete the sentence, select the appropriate option in the answer area.
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
Which file format has defined names and data types for each column and uses compressed columnar storage?
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 the answer that correctly completes the sentence.
You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.
What should you use?
You have a banking application that transfers money in to and out of accounts.
Of which type of solution is this is an example?
You have an application that runs on Windows and requires across to a mapped drive.
Which Azure service should you use?
To complete the sentence, select the appropriate option in the answer area.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
To complete the sentence, select the appropriate option in the answer area.
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.
You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)
NOTE: Each correct selection is worth one point.
You need to store event log data that is semi-structured and received as the logs occur. What should you use?
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?
What is the responsibility of a database administrator?
Select the answer that correctly completes the sentence.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You need to modify a view in a relational database by adding a new column.
Which statement should you use?
What is required to provision Azure Data Lake Storage in an Azure Storage account?
You have a database that stores data in the format shown in the following table.
Of which type of database is this an example?
To complete the sentence, select the appropriate option in the answer area.
To complete the sentence, select the appropriate option in the answer area.
Select the answer that correctly completes the sentence.
You have a table named Sales that contains the following data.
You need to query the table to return the average sales amount day. The output must produce the following results.
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.
Match the datastore services to the appropriate descriptions.
To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
Which service is optimized for loT scenarios that involve streaming time series data?
Which Azure Storage service implements the key/value model?
What can be used with native notebook support to query and visualize data by using a web-based interface?
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.)
NOTE: Each correct selection is worth one point.
Select the answer that correctly completes the sentence.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Match the database normalization 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 the answer that correctly completes the sentence.
Match the Azure Data Lake Storage 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 the answer that correctly completes the sentence.For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?
Select the answer that correctly completes the sentence.
To complete the sentence, select the appropriate option in the answer area.
How is raw data stored in a data lakehoose?
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
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?
Which three actions are used when performing diagnostic analytics?
What is the primary purpose of a data warehouse?
Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
To complete the sentence, select the appropriate option in the answer area.
Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution use?
What is a characteristic of batch processing?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
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.
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.
Select the answer that correctly completes the sentence.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Select the answer that correctly completes the sentence.
Which Azure Data Factory component initiates the execution of a pipeline?
Select the answer that correctly completes the sentence.
correctly completes the sentence.
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types 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.
Select the answer that correctly completes the sentence.
To complete the sentence, select the appropriate option in the answer area.
Select the answer that correctly completes the sentence.
You manage an application that stores data in a shared folder on a Windows server.
You need to move the shared folder to Azure Storage.
Which type of Azure Storage should you use?
Select the answer that correctly completes the sentence.
To complete the sentence, select the appropriate option in the answer area.
