web analytics

Which two actions should you perform? Each correct answer present part of the solution. NOTE: Each correct selection is worth one point.

A company has a real-time data analysis solution that is hosted on Microsoft Azure. The solution uses Azure Event Hub to ingest data and an Azure Stream Analytics cloud job

You need setup monitoring for tiers 6 through 8. What should you configure?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

You need to implement diagnostic logging for Data Warehouse monitoring. Which log should you use?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

You need to monitor for an invalid schema error. For which error should you monitor?

You configure monitoring for a Microsoft Azure SQL Data Warehouse implementation. The implementation uses PolyBase to load data from comma-separated value (CSV) files stored in Azure Data Lake Gen 2

You need to implement a solution to monitor cluster performance and status. Which technology should you use?

You manage a solution that uses Azure HDInsight clusters. You need to implement a solution to monitor cluster performance and status. Which technology should you use? A. Azure HDInsight .NET

You need to determine a monitoring solution to track down the issue in the least amount of time. What should you use?

A company has a Microsoft Azure HDInsight solution that uses different cluster types to process and analyze data. Operations are continuous. Reports indicate slowdowns during a specific time window. You

Solution: Download Azure HDInsight cluster logs by using Azure PowerShell. Does the solution meet the goal?

Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated

Solution: Monitor clusters by using Azure Log Analytics and HDInsight cluster management solutions. Does the solution meet the goal?

Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated

Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Which two Transact-SQL commands should you run? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You plan to use Microsoft Azure SQL Database instances with strict user access control. A user object must: Move with the database if it is run elsewhere Be able to

You need to set up Azure Data Factory pipelines to meet data movement requirements. Which integration runtime should you use?

You need to set up Azure Data Factory pipelines to meet data movement requirements. Which integration runtime should you use? A. self-hosted integration runtime B. Azure-SSIS Integration Runtime C. .NET

Which two options should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You need to process and query ingested Tier 9 data. Which two options should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth

You need to ensure that phone-based poling data can be analyzed in the PollingData database. How should you configure Azure Data Factory?

You need to ensure that phone-based poling data can be analyzed in the PollingData database. How should you configure Azure Data Factory? A. Use a tumbling schedule trigger B. Use

Which three options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A company uses Azure SQL Database to store sales transaction data. Field sales employees need an offline copy of the database that includes last year’s sales on their laptops when

You need to select the appropriate data technology to implement the pipeline. Which data technology should you implement?

Each day, company plans to store hundreds of files in Azure Blob Storage and Azure Data Lake Storage. The company uses the parquet format. You must develop a pipeline that

Which three technologies should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You develop data engineering solutions for a company. You need to ingest and visualize real-time Twitter data by using Microsoft Azure. Which three technologies should you use? Each correct answer

You need to implement the data integration solution. Which tool should you use to configure a pipeline to copy data?

You develop data engineering solutions for a company. You must integrate the company’s on-premises Microsoft SQL Server data with Microsoft Azure SQL Database. Data must be transformed incrementally. You need

Does the solution meet the goal?

Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated

Does the solution meet the goal?

Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated

Does the solution meet the goal?

Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A company plans to use Azure Storage for file storage purposes. Compliance rules require: A single storage account to store all operations including reads, writes and deletes Retention of an

Which three technologies should you implement? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A company plans to use Azure SQL Database to support a mission-critical application. The application must be highly available without performance degradation during maintenance windows. You need to implement the

You must perform an assessment of databases to determine whether data will move without compatibility issues. You need to perform the assessment. Which tool should you use?

A company is designing a hybrid solution to synchronize data and on-premises Microsoft SQL Server database to Azure SQL Database. You must perform an assessment of databases to determine whether

Which two APIs should you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You are the data engineer for your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type. Developers need to

You need to implement a solution that deploys multiple HDInsight clusters with minimal effort. What should you implement?

The data engineering team manages Azure HDInsight clusters. The team spends a large amount of time creating and destroying clusters daily because most of the data pipeline process runs in

You need to migrate the databases to Microsoft Azure by using a backup and restore process. Which data technology should you use?

A company manages several on-premises Microsoft SQL Server databases. You need to migrate the databases to Microsoft Azure by using a backup and restore process. Which data technology should you

You need to implement the Azure SQL Database elastic pool to minimize cost. Which option or options should you configure?

A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution contains a dedicated database for each customer organization. Customer organizations have peak usage at

You need to implement this synchronization solution. Which synchronization method should you use?

You are a data architect. The data engineering team needs to configure a synchronization of data between an on-premises Microsoft SQL Server database to Azure SQL Database. Ad-hoc and reporting

You need to secure the transfer of data between on-premises databases and Microsoft Azure. What should you do?

You develop data engineering solutions for a company. The company has on-premises Microsoft SQL Server databases at multiple locations. The company must integrate data with Microsoft Power BI and Microsoft

You need to create an HDInsight cluster to meet the requirements. Which type of cluster should you create?

You are a data engineer implementing a lambda architecture on Microsoft Azure. You use an open-source big data solution to collect, process, and maintain data. The analytical data store performs