Download our latest MNC Answers Application at Play Store. Download Now

Azure Databases MCQ solution | TCS Fresco Play | Fresco Play

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. 


______________________________

If you have any queries, please feel free to ask on the comment section.
If you want MCQs and Hands-On solutions for any courses, Please feel free to ask on the comment section too.

Please share and support our page!