Which of the following are the steps of database planning life cycle?
Which of the following are the steps of database planning life cycle? Each correct answer represents
a part of the solution. Choose three.
You need to implement a method that will ensure that all modifications to any objects with the Sales database
You manage a SQL Server 2008 server that hosts a database named Sales. Unauthorized odifications
to some tables within the Sales database have resulted in some views no longer working. You need
to implement a method that will ensure that all modifications to any objects with the Sales database
are logged. What should you do?
Which of the following are considered limitations of the legacy LOB implementation?
Which of the following are considered limitations of the legacy LOB implementation?
What will be the relationship between the two entities, namely, division and employee, if you model the databa
You work as a Database Designer for Allen Inc. You are designing the database of a company that has
several divisions (e.g. Spare Parts division). Each division has several departments (e.g. Quality
Control department), and every department has several employees. What will be the relationship
between the two entities, namely, division and employee, if you model the database?
Which of the following properties of the database transaction has been defined in the given statement…
Which of the following properties of the database transaction has been defined in the given
statement: “Either all the changes or no changes have been made in the database.”
Which of the following queries will he use to get the required output?
Roger is the HR Manager of Neon Inc. He wants to generate a report of all the employees working in
Department ID 30 from the Emp table on the following attributes:
Fname
Lname
Salary
All the records should be sorted in ascending order of the Lname attribute. Which of the following
queries will he use to get the required output?
Which of the following approaches is she using?
Merlyn works as a Database Administrator for DOW Inc. She is currently designing a database. She
wants to break down the preliminary specifications into smaller components so that each
component describes a basic fragment of the specifications. Which of the following approaches is
she using?
You need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica
You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently,
HA/Server01 is the primary replica. You have multiple queries that read data and produce reports
from the database. You need to offload the reporting workload to the secondary replica when
HA/Server01 is the primary replica. What should you do?
Which three actions should you perform in sequence?
DRAG DROP
You are a database administrator of a Microsoft SQL Server 2012 environment. The environment
contains two servers named SQLServer01 and SQLServer02. The database Contoso exists on
SQLServer01. You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by
using database mirroring. You need to prepare the Contoso database for database mirroring. Which
three actions should you perform in sequence? (To answer, move the appropriate actions from the
list of actions to the answer area and arrange them in the correct order.)
You need to identify the correct replication method for each scenario
DRAG DROP
You administer several Microsoft SQL Server 2012 servers. Your company has a number of offices
across the world connected by using a wide area network (WAN). Connections between offices vary
significantly in both bandwidth and reliability. You need to identify the correct replication method
for each scenario. What should you do? (To answer, drag the appropriate replication method or
methods to the correct location or locations in the answer area. Each replication method may be
used once, more than once, or not at all.)