fbpx

Compass College News

November 11, 2017

Faculty Member at Compass College Wins an EMMY Award

Compass College faculty member, Thomas Phillips, received an NATAS Mid-America EMMY.

GRAND RAPIDS, Mich. (November 11, 2017) — Compass College faculty member, Thomas Phillips, received an NATAS Mid-America EMMY for his work in multiple roles, including Executive Producer and Production Manager on the television program, Missouri Life Special: Silver Dollar City. Phillips, who previously served as the Manager of Production and Content at KMOS-TV, a PBS station in Warrensburg, MO, is a recent addition to the world-class faculty teaching film and digital media at Compass College of Cinematic Arts.

Phillips brings to the team more than 25 years of production experience, having created content for PBS, ESPN, Showtime, FoxSports, ABC Wideworld of Sports and many corporate and government agencies. Phillips teaches TV Broadcast and Advanced Cinematography at Compass College, and takes every opportunity to share his industry knowledge with the students.

“These classes, especially TV Broadcast, give our students a different kind of production experience; one that better prepares them for a career in content creation,” said Phillips. “The skills they’ve developed working in the studio with industry equipment, along with the class’ Studio Certification, will earn them more employment options upon graduating.”

More information about KMOS-TV and Missouri Life Special: Silver Dollar City can be found at https://www.kmos.org/originals/missouri-life/.

QUESTION 9
You have a database that stores information for a shipping company. You create a table named Customers by running the following Transact-SQL statement.
(Line numbers are included for reference only.)
You need to ensure that salespeople can view data only for the customers that are assigned to them.
Which Transact-SQL segment should you insert at line 07?
A. RETURNS varchar(20)WITH Schemabinding
B. RETURNS dbo.CustomersORDER BY @salesPerson
C. RETURNS tableORDER BY @salesPerson
D. RETURNS tableWITH Schemabinding
Correct Answer: D
Explanation
Explanation/Reference:
The return value can either be a scalar (single) value or a table. SELECT 1 just selects a 1 for every row, of course. What it’s used for in this case is testing
whether any rows exist that match the criteria: if a row exists that matches the WHERE clause, then it returns 1, otherwise it returns nothing. Specify the WITH
SCHEMABINDING clause when you are creating the function. This ensures that the objects referenced in the function definition cannot be modified unless the
function is also modified.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-function-transact- sql
QUESTION 10
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question
presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The
environment hosts several customer databases, and each customer uses a dedicated instance. The environments that you manage are shown in the following
table.You need to monitor WingDB and gather information for troubleshooting issues.
What should you use?
A. sp_updatestats
B. sp_lock
C. sys.dm_os_waiting_tasks
D. sys.dm_tran_active_snapshot_database_transactions
Correct Answer: B
Explanation
Explanation/Reference:
The sp_lock system stored procedure is packaged with SQL Server and will give you insight into the locks that are happening on your system. This procedure
returns much of its information from the syslock info in the master database, which is a system table that contains information on all granted, converting, and
waiting lock requests.
Note: sp_lock will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that
currently use this feature. To obtain information about locks in the SQL Server Database Engine, use the sys.dm_tran_locks dynamic management view.
sys.dm_tran_locks returns information about currently active lock manager resources in SQL Server 2008and later. Each row represents a currently active request
to the lock manager for a lock that has been granted or is waiting to be granted.
References:https://docs.microsoft.com/en-us/sql/relational-databases/system-stored- procedures/sp-lock-transact-sql

https://www.exam2pass.com/500-325.html

QUESTION 11
You use SQL Server 2016 to maintain the data used by applications at your company.
You want to execute two statements.
You need to guarantee that either both statements succeed, or both statements fail together as a batch.
Which code should you use?A. Option A
B. Option B
C. Option C
D. Option D
E. Option E
Correct Answer: D
Explanation
Explanation/Reference:
Structure should be:
BEGIN TRY
BEGIN TRANSACTION
COMMIT TRANSACTION
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
END CATCH.
Reference: TRY…CATCH (Transact-SQL)
QUESTION 12
You are the administrator for a SQL Server 2016 instance that stores the data for an online transaction processing sales system.
The company takes full backups every week; differential backups on the days with no full backups; and hourly transaction backups. These backups are stored on
a backup server in the company’s data center.
Every week, the company places the full backup on a tape and sends it to a third-party backup storage system.
The company is worried that a disaster might occur that could destroy their computer center and cause them to lose orders.
You need to determine the best method for providing the smallest amount of data loss and downtime without leasing or purchasing additional physical locations.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.
A. Set up SQL Server Always On with a SQL Azure database as a replica.
B. Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine.
C. Put the differential backup on tape and send it to the third-party backup storage system.
D. Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a different geographical location.
Correct Answer: D
ExplanationExplanation/Reference:
SQL Server 2012 was the first version to provide the ability to back up databases to the Cloud, and SQL Server 2016 improves on the process.
Microsoft SQL Server Backup to Windows Azure Tool enables backup to Windows Azure Blob Storage and encrypts and compresses SQL Server backups stored
locally or in the cloud.
Reference:
Smart, Secure, Cost-Effective: SQL Server Back Up to Windows Azure – SQL Server Team Blog – Site Home – TechNet Blogs