Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.A . Azure DatabricksB . Azure Log AnalyticsC . Azure Time Series InsightsD . Azure HDinsightView AnswerAnswer: A, D Explanation: Reference: https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/

February 22, 2025 No Comments READ MORE +

Which type of authentication should you use?

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?A . service principal authenticationB . Azure Active Directory (Azure AD) authenticationC . SQL authenticationD . certificate authenticationView AnswerAnswer: B Explanation: Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview

February 20, 2025 No Comments READ MORE +

Which type of data store should you use?

Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema. Which type of data store should you use?A . key/valueB . documentC . graphD . columnarView AnswerAnswer: B Explanation: A key/value store associates each data value with a unique...

February 20, 2025 No Comments READ MORE +

Which command-line tool can you use to query Azure SQL databases?

Which command-line tool can you use to query Azure SQL databases?A . sqlcmdB . bcpC . azdataD . Azure CLIView AnswerAnswer: A Explanation: Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-content-guide?tabs=singledatabase

February 19, 2025 No Comments READ MORE +

How should you complete the query?

DRAG DROP 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...

February 18, 2025 No Comments READ MORE +

What should you use in Microsoft Power BI?

You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down. What should you use in Microsoft Power BI?A . a dashboardB . Microsoft Power AppsC . a dataflowD...

February 17, 2025 No Comments READ MORE +

Which storage tier should you use?

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?A . ArchiveB . HotC . CoolView AnswerAnswer: A

February 17, 2025 No Comments READ MORE +

Match the tools to the appropriate descriptions

DRAG DROP 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. NOTE: Each correct match is worth one point. View AnswerAnswer:...

February 16, 2025 No Comments READ MORE +

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?A . multi-master replicationB . Availability ZonesC . automatic failoverD . the strong consistency levelView AnswerAnswer: B Explanation: With Availability Zone (AZ) support, Azure Cosmos DB will ensure replicas are placed across multiple zones within a...

February 15, 2025 No Comments READ MORE +

A bar chart showing year-to date sales by region is an example of which type of analytics?

A bar chart showing year-to date sales by region is an example of which type of analytics?A . descriptiveB . diagnosticC . predictiveD . prescriptiveView AnswerAnswer: B

February 15, 2025 No Comments READ MORE +