[Free] Download New Updated (February 2016) Microsoft 70-458 Practice Tests 71-80
QUESTION 71
DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that imports unsorted data
into a data warehouse hosted on SQL Azure. You have the following requirements:
A destination table must contain all of the data in two source tables.
Duplicate records must be inserted into the destination table.
You need to develop a data flow that imports the data while meeting the requirements. How
should you develop the data flow?
To answer, drag the appropriate transformation from the list of transformations to the correct
location in the answer area.
Select and Place:
Correct Answer:
QUESTION 72
You are creating a SQL Server Master Data Services (MDS) mode). This model is used to store a
master list of products. An attribute must be added to the Product entity to define the sales
manager responsible for each product. You need to create an attribute in the Product entity that
prevents users from entering invalid sales manager values. Which type of attribute should you
create?
A. Derived
B. Domain-based
C. User-defined
D. Parent
E. Explicit
F. Recursive
Correct Answer: B
QUESTION 73
You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a
data warehouse every night. The SQL Azure data con
tains 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?
A. Decrease the maximum number of matches per lookup.
B. Change the similarity threshold to 0.55.
C. Change the Exhaustive property to True.
D. Increase the maximum number of matches per lookup.
Correct Answer: B
QUESTION 74
You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes
the dimllser and dimDistrict dimension tables and the factSales fact table. The dimUser table
contains records for each user permitted to run reports against the warehouse, and the
dimDistrict table contains information about sales districts. The system is accessed by users from
certain districts, as well as by area supervisors and users from the corporate headquarters. You
need to design a table structure to ensure that certain users can see sales data for only certain
districts. Some users must be permitted to see sales data from multiple districts. What should
you do?
A. Create a userDistrict table that contains primary key columns from the dimUser and
dimDistrict tables.
B. Partition the factSales table on the district column.
C. Add a district column to the dimUser table.
D. For each district, create a view of the factSales table that includes a WHERE clause for the
district.
Correct Answer: A
QUESTION 75
DRAG DROP
You are creating a sales data warehouse. When a product exists in the product dimension, you
update the product name. When a product does not exist, you insert a new record. In the current
implementation, the DimProduct table must be scanned twice, once for the insert and again for
the update. As a result, inserts and updates to the DimProduct table take longer than expected.
You need to create a solution that uses a single command to perform an update and an insert.
How should you use a MERGE T-SQL statement to accomplish this goal?
To answer, drag the appropriate answer choice from the list of options to the correct location or
locations in the answer area. You may need to drag the split bar between panes or scroll to view
content.
Select and Place:
Correct Answer:
QUESTION 76
You develop three Microsoft SQL Server 2012 databases named Database1, Database2, and
Database3. You have permissions on both Database1 and Database2. You plan to write and
deploy a stored procedure named dbo.usp_InsertEvent in Database3. dbo.usp_InsertEvent must
execute other stored procedures in the other databases. You need to ensure that callers that do
not have permissions on Database1 or Database2 can execute the stored procedure. Which
Transact-SQL statement should you use?
A. USE Database2
B. EXECUTE AS OWNER
C. USE Database1
D. EXECUTE AS CALLER
Correct Answer: B
QUESTION 77
DRAG DROP
You administer three Microsoft SQL Server 2012 servers named ServerA, ServerB, and ServerC.
ServerA is the acting principal and ServerB is the mirror. You need to add ServerC as a witness to
the existing mirroring session between ServerA and ServerB. You need to achieve this goal
without delaying synchronization. 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.
Select and Place:
Correct Answer:
QUESTION 78
DRAG DROP
You administer three Microsoft SQL Server 2008 R2 instances. Database mirroring is configured
in High-Safety mode with Automatic Failover between the following three servers:
SQL1 is the Principal server.
SQL2 is the mirror server.
SQL3 is the witness server.
You need to upgrade SQL1 and SQL2 to SQL Server 2012. You need to ensure that downtime is
minimized during the upgrade. Which six 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.
Select and Place:
Correct Answer:
QUESTION 79
You admi
nister a Microsoft SQL Server 2012 failover cluster that contains two nodes named Node
A and Node B. A single instance of SQL Server is installed on the cluster. An additional node
named Node C has been added to the existing cluster. You need to ensure that the SQL Server
instance can use all nodes of the cluster. What should you do?
A. Create a ConfigurationFile.ini file from Node B, and then run the AddNode command-line
tool on Node A.
B. Use Node A to install SQL Server on Node C.
C. Run the Add Node to SQL Server Failover Cluster Wizard on Node C.
D. Use Cluster Administrator to add a new Resource Group to Node B.
Correct Answer: C
QUESTION 80
You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on
a storage area network (SAN). The financial database has the following characteristics:
A data file of 2 terabytes is located on a dedicated LUN (drive D).
A transaction log of 10 GB is located on a dedicated LUN (drive E).
Drive D has 1 terabyte of free disk space.
Drive E has 5 GB of free disk space.
The database is continually modified by users during business hours from Monday through Friday
between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day. The
Finance department loads large CSV files into a number of tables each business day at 11:15
hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of
data to the database. These data load operations must occur in the minimum amount of time. A
full database backup is performed every Sunday at 10:00 hours. Backup operations will be
performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours. You need to
ensure that the minimum amount of data is lost. Which recovery model should the database
use?
A. FULL
B. DBO_ONLY
C. CONTINUE_AFTER_ERROR
D. CHECKSUM
E. NO_CHECKSUM
F. SIMPLE
G. Transaction log
H. SKIP
I. RESTART
J. COPY_ONLY
K. NORECOVERY
L. BULK_LOGGED
M. Differential
N. STANDBY
Correct Answer: A
Free VCE & PDF File for Microsoft 70-458 Real Exam
Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF