Which task should you use?
HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package.
The package must run a parameterized query against a Windows Azure SQL Database
database.
You need to use the least amount of development effort to meet the package requirement.
Which task should you use? (To answer, select the appropriate task in the answer area.)
Which table hint should you use?
You develop a Microsoft SQL Server 2012 database that contains a heap named
OrdersHistoncal.
You write the following Transact-SQL query:
INSERT INTO OrdersHistorical
SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement. Which table hint
should you use?
Which setting should you select?
HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package to implement an
incremental data load strategy. The package reads rows from a source system and
compares them to rows in a destination system. New rows will be inserted and changed
rows will be updated.
You have used a Lookup transformation and a Conditional Split transformation. The Lookup
transformation joins the source and destination table on the business key, and includes all
columns from the destination table in the data flow output. The Conditional Split
transformation inspects the destination columns and directs data flow to either insert new
records or update existing records.
You need to configure the Lookup transformation to ensure that all records flow to the
Conditional Split transformation, regardless of whether the rows match an existing row in the
destination table.
Which setting should you select? (To answer, select the appropriate option in the answer area.)
Which three actions should you perform in sequence?
DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package contains an ADO object source variable that holds a result set that was
returned by a stored procedure execution.
You need to add and configure a container that will execute several tasks for each row in the
ADO object source variable.
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,)
Which Transact-SQL query should you use?
Your database contains a table named Purchases. The table includes a DATETIME column
named PurchaseTime that stores the date and time each purchase is made. There is a nonclustered index on the PurchaseTime column. The business team wants a report that
displays the total number of purchases made on the current day. You need to write a query
that will return the correct results in the most efficient manner.
Which Transact-SQL query should you use?
Which command should you use?
HOTSPOT
You are using the Master Data Services (MDS) Add-in for Excel to configure the entities in a
model- The model consists of two entities: one named Customer and one named State. You
opened the Customer entity.
Currently, data stewards can enter any text value in the Customer entity’s State attribute.
You must restrict the entry of values in the State attribute to members defined in the State entity.
You need to configure the State attribute of the Customer entity.
Which command should you use? (To answer, select the appropriate command in the answer area.)
You need to store media files in several tables
You develop a database for a travel application. You need to design tables and other
database objects. You need to store media files in several tables. Each media file is less
than 1 MB in size.
The media files will require fast access and will be retrieved frequently.
What should you do?
You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading pe
You develop a SQL Server Integration Services (SSIS) package that imports Windows Azure
SQL Database data into a data warehouse every night.
The Windows Azure SQL Database data contains many misspellings and variations of
abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to
choose the closest-matching string from a reference table of allowed values. The number of
rows in the reference table is very large.
If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.
The current setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are incorrectly matched.
You need to ensure that more accurate matches are made by the Fuzzy Lookup
transformation without degrading performance.
What should you do?
You need to display dates and times in several international formats
You develop a database for a travel application. You need to design tables and other
database objects. You create a view that displays the dates and times of the airline
schedules on a report.
You need to display dates and times in several international formats.
What should you do?
You need to ensure that users can update only the phone numbers by using this view
You have three tables that contain data for vendors, customers, and agents. You create a
view that is used to look up telephone numbers for these companies.
The view has the following definition:
You need to ensure that users can update only the phone numbers by using this view. What
should you do?