Azure Databases MCQ solution | TCS Fresco Play | Fresco Play
Disclaimer: The primary purpose of providing this solution is to assist and support anyone who are unable to complete these courses due to a technical issue or a lack of expertise. This website's information or data are solely for the purpose of knowledge and education.
Make an effort to understand these solutions and apply them to your Hands-On difficulties. (It is not advisable that copy and paste these solutions).
All Question of the MCQs Present Below for Ease Use Ctrl + F with the question name to find the Question. All the Best!
If you found answer for any of the questions is wrong. Please do mention in the comment section, could be useful for others. Thanks!
Azure Databases MCQ solution
Azure database course answer
Azure database fresco play course answer
_________________________
1. If an Azure SQL Data Warehouse is not going to be used for a few weeks, which of the following methods could be used to minimize ongoing costs and keep the database in place for later use?
Ans: Pause the Azure SQL Data Warehouse.
2. If an Azure SQL Database is not going to be used for a few weeks, which of the following
methods could be used to minimize ongoing costs?
Ans: Pause the Virtual machine (Incorrect)
3. Templates for Azure Resource Manager deployment are written in which format?
Ans: JSON
4. In relation to contained Azure SQL Database users, which of the following is true?
Ans: They can only access a single database.
5. Before users can connect from their applications to an Azure SQL server that has just been created, what must you configure?
Ans: Firewall Rule
6. When migrating an existing on-premises SQL Server database, what type of export file needs to be created when both schema and data need to be exported?
Ans: .bacpac
7. When configuring Azure SQL Data Warehouse to access text files in an Azure Storage
container, which of the following features is used?
Ans: Ploy base
8. Which of the following tools can be used to connect to Azure SQL Database?
Ans: SSMS, SQL-CMD, SSIS
9. How is Azure SQL Database Auditing configured?
Ans: Via an Azure portal configuration
10. Which three of the following settings need to be configured for a new Azure SQL Server?
Ans: All the options
11. You are concerned that someone may try to insert malicious statements into your database. Which type of threat detection event should you enable?
Ans: SQL Injection
12. Where is the output of Azure SQL Database Auditing stored?
Ans: In a log written to Azure storage
13. In relation to the Azure SQL database active geo-replication, which of the following is not true?
Ans: All databases need to be in the same data center
14. If you have configured Azure SQL Database Alerts, and you are receiving alerts too frequently, for the same issue, which configuration parameters do you need to review, to reduce the volume of alerts?
Ans: Metric and threshold (Incorrect)
15. Which of the following is/are the standard monitoring uses for Dynamic Management Views available in Azure SQL Database?
Ans: All the options
16. In relation to Azure SQL Database firewall rules, which of the following is true?
Ans: All the options
17. Active Geo-Replication allows you to configure up to how many readable secondary databases?
Ans: 4
18. Azure SQL Database is an example of what type of service?
Ans: PaaS
19. Which of the following services is designed for storage, automatic indexing, and rapid querying of JSON documents that are commonly found in NoSQL applications?
Ans: Azure Document DB
20. Which of the following characteristics relate to Azure SQL Database?
Ans: All the options
=========================
21. Which statements are true about Azure DocumentDB?
Ans: Azure DocumentDB provides developers with a schema-free data model embracing standards like JSON and JavaScript.
22. What is the maximum number of concurrent logins you can have with the Azure SQL database using the Basic pricing tier?
Ans: 30
23. Which of the following is not a benefit of running Azure SQL database?
Ans: The ability to run any desired database platform inside an Azure virtual machine
24. Which of the following options is best for working with large scale, high volume non relational data?
Ans: Azure Cosmos DB
25. You are planning on creating a new Azure SQL Database on an existing SQL Server by using Azure portal. Which settings can you configure for the new database?
Ans: sign in and password
26. In relation to the Azure SQL database active geo replication, which of the following is not true?
Ans: All databases need to be in the same data center
27. Which of the following characteristics relate to Azure SQL Database?
Ans: All the options
28. Which of the following is are the standard monitoring uses for Dynamic Management Views available in Azure SQL Database?
Ans: All the options
29. In relation to Azure SQL Database export to the storage, which of the following is not true?
Ans: It can be written faster to Azure Premium Storage.
30. When creating an Azure SQL Data Warehouse, which of the following options is incorrect?
Ans: Create a blank database as the data source.
31. If an existing login can access the master database of an Azure SQL Server, which type of object needs to be created before the login can access another database on the same server?
Ans: User
32. In relation to Azure SQL Database firewall rules, which of the following is true?
Ans: All the options
33. Where is the output of Azure SQL Database Auditing stored?
Ans: In a log written to Azure storage
34. If it takes 15 minutes to load 3 tables into an Azure SQL Data Warehouse that has been provisioned with 100 DWUs, how many DWUs will it take to load those same tables in 3 minutes?
Ans: 500
35. You are creating a Firewall Blocked alert for your SQL Server database. You are using the Azure portal and need to specify a time span to monitor the metric data. Which parameter do you configure?
Ans: Period
36. Which three of the following settings need to be configured for a new Azure SQL Server?
Ans: All the options
37. Audit logs can be written to which two of the following?
Ans: Both blob and table storage
38. Which statements are true about Azure DocumentDB?
Ans: Azure DocumentDB provides developers with a schema-free data model embracing standards like JSON and JavaScript.
Post a Comment