- All Exams Instant Download
Match the terms to the appropriate descriptions
DRAG DROP 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. View AnswerAnswer:...
Which type of processing does the reporting solution 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?A . stream processingB . Online Transaction Processing (OLTP)C . batch processingD . Online Analytical Processing (OLAP)View AnswerAnswer: B Explanation: Reference: https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/
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.
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.A . containerB . itemC . databaseD . partitionView AnswerAnswer: AC Explanation: Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput
What should you use?
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?A . Microsoft SQL Server Management Studio (SSMS)B . Azure Data StudioC . Azure CLID . Azure...
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/
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
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...
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
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...
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...
