Activedumpsnet Logo
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location 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 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.
Select the answer that correctly completes the sentence.
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
In Azure Table storage, each row in a table must be uniquely identified by which two components?
Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
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?
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 Azure Storage service implements the key/value model?
Select the answer that correctly completes the sentence.
You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query. What should you create?
To complete the sentence, select the appropriate option in the answer area.
You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?
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.
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. Each location may be used 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.
To complete the sentence, select the appropriate option in the answer area.
Select the answer that correctly completes the sentence.
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.
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.
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?
Which clause should you use in a select statement to combine rows in one table with rows in another table?
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.
Select the answer that correctly completes the sentence.
To complete the sentence, select the appropriate option in the answer area.
What is required to provision Azure Data Lake Storage in an Azure Storage account?
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 data in a tabular format as shown in the following table.
Of which type of data is this an example?
Which statement is an example of Data Manipulation Language (DML)?
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 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?
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?
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 Azure Data Factory component provides the compute environment for activities?
To complete the sentence, select the appropriate option in the answer area.
Match the Azure services to appropriate requirements.
To answer, drag the appropriate services from the column on the left to its requirement on the right. Each service may be used once. more than once, or not at all.
NOTE: Each correct match is worth one point.
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.
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?
What is a characteristic of a non-relational database?
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.
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.
A bank has a system that manages financial transactions.
When transferring money between accounts, the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.
Of which ACID semantic is this an example?
A data engineer is responsible for which task?
Select the answer that correctly completes the sentence.
What is the primary purpose of a data warehouse?
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 storage solution supports role-based access control (RBAC) at the file and folder level?
You have a data store that has the structure shown in the following exhibit.
Which type of data store is this?
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.
Select the answer that correctly completes the sentence.
In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?
You have the following SQL query.
NOTE: Each correct selection is worth one point.
To complete the sentence, select the appropriate option in the answer area.
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Select the answer that correctly completes the sentence.
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.
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?
What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.
Select the answer that correctly completes the sentence.
Which three services support Apache Spark? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.
To complete the sentence, select the appropriate option in the answer area.
What is a characteristic of non-relational data?
For each of the following statements. select Yes if the statement is true. Otherwise, select No. NOTE Each correct selection is worth one point.
When you create an Azure SQL database, which account can always connect to the database ?
You need to design and model a database by using a graphical tool that supports project-oriented offline
database development.
What should you use?
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.
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 type of database is Azure Database for PostgreSQL?
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.
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?
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 the 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?
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?
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
You need to modify a view in a relational database by adding a new column.
Which statement should you use?
