You need to grant only the necessary permissions
You administer a Windows Azure SQL Database database named Inventory that contains a
stored procedure named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored
procedure.
You need to grant only the necessary permissions.
What should you do?
Which permission or permissions should you choose?
DRAG DROP
You administer a Microsoft SQL Server 2012 server along with a Windows Azure SQL
Database database.
For both servers, you need to grant users the ability to create logins and create databases.
You need to determine which permission to grant users in each instance.
Which permission or permissions should you choose? (To answer, drag the appropriate
permission or permissions to their corresponding instance type or types in the answer area.
Answer choices may be used once, more than once, or not at all. Answer targets may be
used once or not at all. Additionally, you may need to drag the split bar between panes or
scroll to view content.)
Which command or commands should you use?
DRAG DROP
You administer a Microsoft SQL Server 2012 database.
The database contains a schema named CUSTOMER. CUSTOMER contains several tables
and views with sensitive data, as well as various stored procedures and functions.
In order to configure security for CUSTOMER, you need to determine how to meet the
security requirements listed in the answer area.
Which command or commands should you use? (To answer, drag the appropriate command
or commands to their corresponding security requirement or requirements in the answer
area. Answer choices may be used once, more than once, or not at all. Answer targets may
be used once or not at all. Additionally, you may need to drag the split bar between panes or
scroll to view content.)
You need to design a solution that meets the requirements
You are designing a SQL Server Integration Services (SSIS) solution. The solution will
contain an SSIS project that includes several SSIS packages. Each SSIS package will
define the same connection managers and variables.
You have the following requirements:
Ensure that the deployment model supports changing the content of connection strings by
using parameters at execution time.
Ensure that the deployment model automatically starts from calls to the
catalog.start_execution stored procedure in the SSISDB database.
Maximize performance at execution time.
Minimize development effort.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
Which user account should you use?
You administer a SQL Server 2012 database instance.
You need to configure the SQL Server Database Engine service on a failover cluster.
Which user account should you use?
You need to partition the table to maximize the performance of queries
You are designing a partitioning strategy for a large fact table in a data warehouse. Tens of
millions of new records are loaded into the data warehouse weekly, outside of business
hours.
Most queries are generated by reports and by cube processing. Data is frequently queried at
the day level and occasionally at the month level.
You need to partition the table to maximize the performance of queries. What should you
do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Which three actions should you perform in sequence?
DRAG DROP
You plan to deploy a SQL Server Integration Services (SSIS) project by using the project
deployment model.
You need to monitor control flow tasks to determine whether any of them are running longer
than usual. Which three actions should you perform in sequence? (To answer, move the
appropriate actions from the list ofactions to the answer area and arrange them in the correct order.)
Which three actions should you perform in sequence?
DRAG DROP
You are designing a SQL Server Integration Services (SSIS) package to execute 12
Transact-SQL (T-SQL) statements on a SQL Azure database. The T-SQL statements may
be executed in any order. The T-SQL statements have unpredictable execution times.
You have the following requirements:
The package must maximize parallel processing of the T-SQL statements.
After all the T-SQL statements have completed, a Send Mail task must notify administrators.
You need to design the SSIS package. 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.)
what sequence should you order four of the listed components for the data flow task?
DRAG DROP
You are creating a SQL Server Integration Services (SSIS) package to populate a fact table
from a source table. The fact table and source table are located in a SQL Azure database.
The source table has a price field and a tax field. The OLE DB source uses the data access
mode of Table.
You have the following requirements:
The fact table must populate a column named TotalCost that computes the sum of the price
and tax columns.
Before the sum is calculated, any records that have a price of zero must be discarded.
You need to create the SSIS package in SQL Server Data Tools.
In what sequence should you order four of the listed components for the data flow task? (To
answer, move the appropriate components from the list of components to the answer area
and arrange them in the correct order.)
You need to grant users access according to the following requirements: CORP\Employees should have SELECT acce
You administer a Windows Azure SQL Database database named Human_Resources. The
database contains 2 tables named Employees and SalaryDetails.
You add two Windows groups as logins for the server:
CORP\Employees – All company employees
CORP\HRAdmins – HR administrators only
HR Administrators are also company employees.
You need to grant users access according to the following requirements:
CORP\Employees should have SELECT access to the Employees table.
Only users in CORP\HRAdmins should have SELECT access to the SalaryDetails table.
Logins are based only on Windows security groups.
What should you do?