Interview questions dotnet azure
[Link]
questions/dot-net-developer/top-questions?
campaign=topQuestionWidget
[Link] kind of database you used in projects
-Ms sql server , azure sql, cosmosdb
[Link] is the components of dotnetframework which types
-The components of .NET Framework include Common Language Runtime, Class Library, and [Link].
Common Language Runtime (CLR) - manages memory, security, and execution of code . Class Library -
provides a set of reusable classes and types for building applications [Link] - a web application
framework for building dynamic web pages and web services . Other components include [Link],
Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF), and Windows
Workflow Foundation (WF)
3. Singlton architecture give examples
Ans. Singleton architecture is a design pattern that restricts the instantiation of a class to one
[Link] pattern ensures that only one instance of a class is created and provides a global point
of access to it.
Examples of Singleton pattern include database connections, logging classes, and configuration settings.
Singleton pattern can be implemented using lazy initialization, eager initialization, or thread-safe
initialization. *Singleton pattern can also be implemented using dependency injection frameworks like
Unity or Ninject.
4. what is application pool,what is IIS,how to host app in dev env,abstarction vs encapsulation,how to
optimize databse to improve performance,where to start check is application crashses
Ans---. Application pool is a group of one or more worker processes, IIS is a web server, hosting app in
dev env involves setting up IIS, abstraction focuses on hiding implementation details, encapsulation
bundles data and methods together, optimizing database involves indexing and query optimization,
check for application crashes in event logs or monitoring tools.
Application pool is a group of one or more worker processes that share the same configuration and
application boundaries.
IIS (Internet Information Services) is a web server created by Microsoft for hosting websites and web
applications.
To host an app in a dev environment, set up IIS on the local machine, configure the site and application
pool, and deploy the app files.
Abstraction involves hiding complex implementation details and exposing only necessary information to
the user.
Encapsulation bundles data and methods together within a class, providing data protection and code
organization.
Optimizing a database for performance includes indexing frequently queried columns, optimizing
queries, and normalizing data.
To check for application crashes, monitor event logs for error messages, use monitoring tools like
Application Insights, or set up crash reporting mechanisms.
what is CTE and explain
Ans.-- CTE stands for Common Table Expressions, which is a temporary result set that can be referenced
within a SELECT, INSERT, UPDATE, or DELETE statement.
CTEs are defined using the WITH keyword in SQL.
They help improve readability and maintainability of complex queries. CTEs can be recursive, allowing
for hierarchical data querying.
Example: WITH CTE AS (SELECT * FROM table_name) SELECT * FROM CTE;
Example: WITH RECURSIVE CTE AS (SELECT * FROM table_name UNION ALL SELECT * FROM CTE) SELECT
* FROM CTE;
How we secure our logic apps
[Link]
[Link]#google_vignette
Az logic apps
[Link]