Codechef4u is a community for computer professionals,by computer professionals,just like you; who loves sharing and helping each others,Join them
Share your post

Sql azure interview questions

100 SQL Azure interview questions

In this article I will share around 100 quality questions that covers all area In SQL Azure and azure.

Prepare following question I am sure those 100 questions definitely help you to crack interview in SQL Azure, happy job searching friends.

Top 100 SQL Azure interview questions:

1. What is SQL Azure?

2. What are the advantages of SQL Azure?

3. What is cloud computing?

4. What is scale a cloud service?

5. What is a cloud service role?

6. What is a cloud service components?

7. How many types of deployment models are used in cloud?

8. How is SQL Azure different than SQL server?

9. How many replicas are maintained for each SQL Azure database?

10. CAN I USE SQL AZURE AS A BACKUP WITH LOG SHIPPING OR DATABASE MIRRORING?

11. What are two difference between SQL Azure and Azure Tables?

12. How can we migrate from SQL server to SQL Azure?

13. Which tools are available to manage SQL Azure databases and servers?

14. What encryption security is available in SQL Azure?

15. Explain security with SQL Azure.

16. What is SQL Azure Firewall?

17. What is the difference between web edition and business edition?

18. How do we synchronize On Premise SQL server with SQL Azure?

19. How do we Backup SQL Azure Data?

20. What is the current pricing model of SQL Azure?

21. What is the current limitation of the size of SQL Azure DB?

22. How do you handle datasets larger than 50 GB?

23. What happens when the SQL Azure database reaches Max Size?

24. How many databases can we create in a single server?

25. How many servers can we create in a single subscription?

26. How do you improve the performance of a SQL Azure Database?

27. What are REST-style architecture's?

28. What is code near application topology?

29. What were the latest updates to SQL Azure service?

30. When does a workload on SQL Azure get throttled?

31. What happens when the SQL Azure database reaches Max Size?

32. What is the current limitation of the size of SQL Azure DB?

33. How do you handle datasets larger than 50 GB?

34. What is it’s similarity with SQL Server?

35. How can we migrate from SQL server to SQL Azure?

36. Difference between Web and Worker Roles in Windows Azure?

37. What is AutoScaling?

38. What are Horizontal and Vertical Scaling?

39. Which tools are available to manage SQL Azure databases and servers?

40. How many databases can we create in a single server?

41. How many servers can we create in a single subscription?

42. What is the difference in accessing DB between SQL Server Vs SQL Azure?

43. What is the Data Tier Application?

44. What is the index requirement in SQL Azure?

45. How do you migrate data from MSSQL server to Azure?

46. Where actually SQL Azure Database is hosted?

47. List layers of abstraction Microsoft architectured to provide relational DB through cloud platform ?

48. Explain four layers of abstraction Microsoft architectured?

49. How do we synchronize On Premise SQL server with SQL Azure?

50. What is SQL Azure Fabric?

51. What is provisioning, billing and metering, and connection routing concepts in the service layer?

52. Explain managing session state in Windows Azure?

53. Explain Azure Service Level Agreement (SLA)?

54. What’s the benefit of Azure SLA?

55. How many instances of a Role should be deployed to satisfy Azure SLA (service level agreement) ?

56. How to connect to SQL Azure Database by using sqlcmd?

57. What are the three main components of Windows Azure Platform?

58. How would you categorize Windows Azure?

59. Explain IaaS, PaaS and SaaS?

60. Explain differences between web edition and business edition?

61. What is the difference between web edition and business edition?

62. What is Windows Azure compute emulator?

63. What is Windows Azure Storage Emulator?

64. What are the roles available in Windows Azure?

65. How to design applications to handle connection failure in windows Azure?

66. List languages/frameworks that can be used to develop Windows Azure applications?

67. What are the three types of roles in Compute component in Windows Azure?

68. What is VM role in Windows Azure?

69. What is worker role in Windows Azure and how does it help?

70. What is web role in Windows Azure?

71. What are the differences between web role and worker role?

72. What is a role instance?

73. What is a guest operating system?

74. What is SQL Azure Data sync?

75. Which are the two editions in which SQL Azure database available?

76. What is Azure Diagnostics?

77. What is a service package?

78. What is a service configuration file?

79. What is a service definition file?

80. What is minimal vs. verbose monitoring?

81. What is swap deployments?

82. Explain in details security in SQL azure?

83. Ways to improve the performance of a SQL Azure Database?

84. What is a fan-out query in SQLAzure?

85. List types of tables in SQLAzure?

86. Explain tables in SQLAzure?

87. What is the index requirement in SQL Azure?

88. What were the latest updates to SQL Azure service?

89. What is the difference between web edition and business edition?

90. What is TDS(Tabular Data Stream) Gateway?

91. How to connect Azure federated root database and apply federation in entity framework?

92. How to scale out a federation by Sql statement?

93. What is Federation and Federation Member?

94. What is Federation Root Database?

95. What is SQL Azure Federations?

96. What is code near application topology?

97. How do we Backup SQL Azure Data?

98. What is sharding?

99. What is server-level principal?

100. What is function of master database?

Invalid entry,please enter valid data.

Loading