Describe Automated Testing? Automated Testing/(test automation) is the use of special software(Testing tools) to control the execution of...
What would be the output of following query? 😄 SELECT CASE WHEN 1 = 1 THEN 'Vikas Ahlawat1' WHEN 2 = 2 THEN ...
You can obtain the greatest improvement in database application performance by looking first at the area of data access, including logical/...
SQL SERVER PERFORMANCE TUNING TICK If SSMS Priority is low then it will degrade SSMS performance so if your server responding slow then y...
Microsoft SQL Server provides a dedicated administrator connection (DAC). The DAC allows an administrator to access a running instance of S...
Sticking with development, on premise allows for custom developed plug-ins. Online allows for this as well, but with limitations. Plug-in...
Below are the syntaxs of aliasing in T-SQL, you can use any one of three <expression> AS <alias> <expression> <ali...
You not allowed to refer to a column alias defined by the SELECT clause in the WHERE clause, because the WHERE clause is logically evaluate...
1- FROM 2- WHERE 3- GROUP BY 4- HAVING 5- SELECT 6- ORDER BY
1- SELECT 2- FROM 3- WHERE 4- GROUP BY 5- HAVING 6- ORDER BY
Unlike grouping, partitioning is specific to one function's window and can be different for different functions in the same query.
The partitioning element allows you to restrict the window to only those rows that have the same values in the partitioning attributes as t...
Below are the types of View in SQL Server Indexed Views: An indexed view is a view that has been materialized. This means the view defi...
Following are the major problem areas that can degrade SQL Server performance: Poor indexing/Bad indexing Inaccurate statistics Poor q...
Below are my regular jobs to keep my SQL Server fast. Identifying problematic SQL queries Analyzing a query execution plan Evaluating...
The DMVs were introduced in SQL 2005, DMVs allow you to get better insight into what is happening in SQL Server. Without these new tools a...
SQL Server R Services. R Services (In-Database) provides a platform for developing and deploying intelligent applications that uncover new ...
Microsoft Dynamics CRM is undoubtedly one of the top products in the CRM space. However, following are the other products that compete Micr...
Below is the Microsft CRM versions history: Microsoft CRM 1.0 (first version) Microsoft CRM 1.2 Microsoft Dynamics CRM 3.0 Microsoft D...
Are you looking for a job for months? Have you sent your resume to hundreds of job applications without obtaining just results? In this a...
Ans:- By following below steps
Tables:- 1. Write a query to get all employee detail from "EmployeeDetail" table ANS: SELECT * FROM [EmployeeDeta...
Microsoft Dynamics 365 and Microsoft Dynamics 365 (online) provide a security model that protects data integrity and privacy, and supports ...
Role-based security: Role-based security in Microsoft Dynamics 365 focuses on grouping a set of privileges together that describe the re...
In Microsoft Dynamics 365 and Microsoft Dynamics 365 (online), you use field-level security to restrict access to high business impact fiel...
CRM stands for customer relationship management. CRM is a category of integrated, data-driven solutions that improve how you interact and d...
Ans: DDL
Sessions – when the client application connects to SQL Server the two sides establish a “session” on which to exchange information. Stric...
A page is the most basic unit of storage in SQL Server. The disk space allocated to a data file (.mdf or .ndf) in a database is logically d...
In SQL Server a page(8KB size) is the basic unit of data storage in SQL server. Data is stored in the leaf-level pages of Index. The perce...
Convert : enables you to convert data stored in one data type to another. The conversion might fail if you attempt to convert between data ...
Names are the object keys. The name for a key is a sequence of Unicode characters whose UTF-8 encoding is at most 1024 bytes long.
Using UI: In your security group: Click the inbound tab Create a custom ICMP rule Select echo request Use range 0.0.0.0/0 for e...
aws s3 rm --recursive s3://your_bucket_name/foo/ Or delete everything under the bucket: aws s3 rm --recursive s3://your_bucket_name If...
Write, read, and delete objects containing from 1 byte to 5 terabytes of data each. The number of objects you can store is unlimited.
Amazon SNS allows applications to send time-critical messages to multiple subscribers through a “push” mechanism, eliminating the need to...
Stop the instance. Detach the root EBS volume. Attach the alternate EBS volume (as the root e.g. /dev/sda1) Start the instance. This p...
s3cmd sync s3://from/this/bucket/ s3://to/this/bucket/
Rebooting an instance is like rebooting a PC. The hard disk isn't affected. You don't return to the image's original state, but...
s3cmd can show you this by running s3cmd du, optionally passing the bucket name as an argument.
I will generate a bucket policy which gives access to all the files in the bucket. The bucket policy can be added to a bucket through AWS c...
Yes it is completely possible to host websites on AWS in 2 ways: Easy - S3 (Simple Storage Solution) is a bucket storage solution that...
As a heads up to anyone who uses the .ebextensions/*.config way: nowadays you can add, edit and remove environment variables in the Elastic...
wget -q -O - http://instance-data/latest/meta-data/instance-id If you need programatic access to the instance ID from within a script di...
EBS backed instances can be set so that they cannot be (accidentally) terminated through the API. EBS backed instances can be stopped whe...
WorkMail is a managed email and calendaring service with strong security controls and support for existing desktop and mobile email clients...
Amazon AppStream is an application streaming service that lets you stream your existing resource-intensive applications from the cloud with...
Use the ec2-describe-regions command as follows to describe your regions. PROMPT> ec2-describe-regions REGION us-east-1 ec2.us-east-1...
To reduce data latency in your applications, most Amazon Web Services products allow you to select a regional endpoint to make your request...
Amazon CloudSearch is a fully managed service in the cloud that makes it easy to set up, manage, and scale a search solution for your websi...
Amazon Kinesis Firehose is a fully managed service for delivering real-time streaming data to destinations such as Amazon Simple Storage Se...
AWS Data Pipeline is a web service that you can use to automate the movement and transformation of data. With AWS Data Pipeline, you can de...
Amazon Elastic MapReduce (Amazon EMR) is a managed cluster platform that simplifies running big data frameworks, such as Apache Hadoop and ...
AWS WAF is a web application firewall that lets you monitor the HTTP and HTTPS requests that are forwarded to Amazon CloudFront and lets yo...
The AWS Key Management Service (AWS KMS) is a managed service that makes it easy for you to create and control the encryption keys used to ...
ElastiCache is a web service that makes it easy to set up, manage, and scale distributed in-memory cache environments in the cloud.
Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. You can...
The buffer is used to make the system more robust to manage traffic or load by synchronizing different component. Usually, components rece...
C4 instances are ideal for compute-bound applications that benefit from high performance processors.
T2 instances are designed to provide moderate baseline performance and the capability to burst to significantly higher performance as requi...
By default, you can create upto 100 buckets in each of your AWS accounts.
S3: Amazon S3 is just a storage service, typically used to store large binary files. Amazon also has other storage and database services, ...
Amazon EC2 provides the following features: Virtual computing environments, known as instances Preconfigured templates for your instance...
An EC2 instance is a virtual server in Amazon's Elastic Compute Cloud (EC2) for running applications on the Amazon Web Services (AWS) i...
Amazon Elastic Compute Cloud (Amazon EC2) provides scalable computing capacity in the Amazon Web Services (AWS) cloud. Using Amazon EC2 eli...
Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all...
From a single AMI, you can launch multiple types of instances. An instance type defines the hardware of the host computer used for your in...
It’s a template that provides the information (an operating system, an application server and applications) required to launch an instance,...
S3 stands for Simple Storage Service. You can use S3 interface to store and retrieve any amount of data, at any time and from anywhere on t...
AWS Certificate Manager (ACM) handles the complexity of provisioning, deploying, and managing certificates provided by ACM (ACM Certificate...
AWS Identity and Access Management (IAM) is a web service that helps you securely control access to AWS resources for your users. You use I...
The key components of AWS are :- (AWS 2016 INTERVIEW QUESTIONS) Route 53: A DNS web service Simple E-mail Service: It allows sending e...
AWS stands for Amazon Web Service; it is a collection of remote computing services also known as cloud computing platform. This new realm ...
AWS INTERVIEW QUESTIONS SET-2 set-2 link available at bottom of this post 1.) What is Amazon RDS? 2.) In RDS, what is the max...
What is the underlying Hypervisor for EC2? Ans: Xen
What are the 4 level of AWS premium support? Ans: Basic, Developer, Business, Enterprise
In S3, what does RRS stand for? Ans: Reduced Redundancy Storage
If you want to run a database on an EC2 instance, which is the most recommended Amazon storage option, S3, RDS or EBS? Ans: EBS Click her...
Ans: True
Ans: 35 Days Note : This questions asked during Aon Hewitt Interview
RDS stand for Relational Database Service is a web service that makes it easier to set up, operate, and scale a relational database in the ...
Elastic Beanstalk automatically handles the deployment, from capacity provisioning, load balancing, auto-scaling to application health moni...
We need to assign a static internet-routable IP address to an Amazon VPC customer gateway. Note : This questions asked during Prospecta S...
Suppose that you are working with a customer who has 10 TB of archival data that they want to migrate to Glacier. The customer has a 1-Mbps...
AWS Multi-Factor Authentication (MFA) is a simple best practice that adds an extra layer of protection on top of your user name and passwor...
Amazon Virtual Private Cloud (Amazon VPC) enables you to launch Amazon Web Services (AWS) resources into a virtual network that you've ...
Click here for answer Note : This questions asked during NASA Interview
Normally, each EC2 instance you launch is randomly assigned a public IP address in the amazon EC2 address space. VPC allows you to create a...
When we create a default VPC, we do the following to set it up for you: ( Create a default subnet in each Availability Zone. Create an ...
Amazon VPC provides three features that you can use to increase and monitor the security for your VPC: Security groups — Act as a firewa...
What benefits to VPC security groups give you that EC2 security groups do not? ( AWS Interview Questions Answers) Ans: 1. Being able to c...
What is the difference between Network ACLs and Security Groups in AWS? Amazon Web Services Interview Question Network ACLs: A network ...
Here are the Top 20 Telerik Test Studio Interview Question with Answers, If you looking for job change and preparing for interview then thi...
Below are the Key Steps to Prepare and Execute the Testing of a Project Get to know the domain expert and user community. Fundamentally ...
The third major Test Studio R3 2016 is live now. Here are the new features of R3 2016 include support for Angular, iOS 10, our very own Nat...
Here we come with Advantages/benefits of Telerik Test Studio, This is becoming very popular testing tool among tester world. So If you are ...
In simple word you can define dirty read like, reading any value from any other transaction which is still not committed. Example. Suppos...
What is collation? Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules...
